Bug #38664 mysqldump does not backup all the databases
Submitted: 8 Aug 2008 12:12 Modified: 9 Sep 2008 17:35
Reporter: Kaustubh Kane Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Backup Severity:S3 (Non-critical)
Version:5.0.51 OS:Solaris (Soalris 10)
Assigned to: CPU Architecture:Any

[8 Aug 2008 12:12] Kaustubh Kane 
Description:
There’s an intermittent issue observed with mysqldump utility. When it is called with -–all-databases=”TRUE” it is seen that at times it does not backup all the databases. It just backs up our application database but not "mysql" database. The exact command we try is:

/usr/local/mysql/bin/mysqldump –u<username> –p<password> --flush-logs --all-databases="TRUE" > /tmp/mysqlbackup.sql

 

We also tried by specifying the all-databases=”TRUE” under “[mysqldump]” tag in configuration file “my.cnf” that exists /etc. But even this does not help to resolve the issue. 

 

How to repeat:
Run the mysqldump utility with --all-databases="TRUE" option.
[9 Aug 2008 17:35] Sveta Smirnova 
Thank you for the report.

Please connect using mysql command line client as <username>, run SHOW GRANTS query and provide us its output.
[9 Sep 2008 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".