I looking for a way to corrupt a mysql database forcefully for testing
purpose
and then the mysqldump utility will fail for taking backup against it.

On Fri, May 28, 2010 at 8:06 AM, Anand.S <anand....@gmail.com> wrote:

> 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.
>>
>
>

Reply via email to