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 '15 at 14:54
have you checked in root user privilege of your new created database or not — Md Haidar Ali Khan, Sep 15 '15 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 '15 at 15:26

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

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.

1 Answer 1