redirect your standard errors to some log file.. mysqldump --all-databases --flush-logs --master-data=2 > /bk01/all_databases_`date +%a`.sql 2> /tmp/test.log
i follow the above syntax for logging the errors in my script. Thanks Anand On Fri, May 28, 2010 at 5:44 PM, Angelina Paul <arshup...@gmail.com> wrote: > Could you please inform me how to test the mysql databases backup failure > by > using the mysqldump utility. I written a unix script for sending status > notification against ten mysql databases. I need to test the nine databases > backups have completed successfully and one failed due some reason. > > Thanks for your help. >