unable to get stable copies in mysqldump

[tiger]

Hello forum pals

I scheduled a cron job for mysqldump to run every day at midnight. But looks like many of the backups are partial, not a complete backup of the origianl db(when I recovered the backups, many of them only got the first table with less rows that there should be). Can anybody tell me where the problem resides?

The command I used is:
mysqldump --quick --flush-logs --master-data=2 --databases my_database --delete-master-logs --user my_user_name --password=my_password > /path_to_the_dir/my_backup.sql

Thanks in advance for your inputs -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[visionary]

Hey

Can't help you much there.
You will have to check the mysql error log, the messages or syslog file and hope that you have some information there.
Otherwise you will have to test run the backup script that you are using and see if it completes correctly when you run it manually.

Have a nice time -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --