Why is mysqldump not saving newly added databases?

Question

I am using the following command to backup all mysql databases in script that is run as cronjob.

mysqldump -u root -p'***' --all-databases > backupdb.sql

I have added new databases recently and I noticed that the new databases are not saved in the backupdb.sql. What am I missing?

Unagaswamy, before mysqldump did you checked mysql >show databases ; what it show. — Md Haidar Ali Khan, Sep 15, 2015 at 14:54
have you checked in root user privilege of your new created database or not — Md Haidar Ali Khan, Sep 15, 2015 at 15:20
sorry, I don't understand the question! Are you asking if the root has privileges on the new databases? If so, yes, the root does! — UNagaswamy, Sep 15, 2015 at 15:26

naveen_sfx · Accepted Answer · 2015-10-13 21:16:43Z

0

1) check your last 10 lines of dump file

 tail dump.sql

it should show your dump file properly completed or not.

2) grep the database name in dump file

 cat dump.sql | grep newdb

with the above 2 steps you can find is your backup is completed propery or not and the new database exists or not.

answered Oct 13, 2015 at 21:16

naveen_sfx

1411 silver badge8 bronze badges

Add a comment |

1 Answer 1