Bug #38664 mysqldump does not backup all the databases

• Submitted: 8 Aug 2008 14:12
• Modified: 9 Sep 2008 19:35
• Reporter: Kaustubh Kane
• Status: No Feedback
• Category: Server: Backup
• Severity: S3 (Non-critical)
• Version: 5.0.51
• OS: Sun Solaris (Soalris 10)

[8 Aug 2008 14: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 19: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.

[10 Sep 2008 1: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".