mysqldump backup

--00c09fa2195eb35c810487a67409
Content-Type: text/plain; charset=ISO-8859-1

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.

--00c09fa2195eb35c810487a67409--

Re: mysqldump backup

--0016361e839a3134ab0487a72ed0
Content-Type: text/plain; charset=ISO-8859-1

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

--0016361e839a3134ab0487a72ed0--

Re: mysqldump backup

--001636283a7c81360f0487a786e6
Content-Type: text/plain; charset=ISO-8859-1

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

--001636283a7c81360f0487a786e6--

Re: mysqldump backup

In infinite wisdom Angelina Paul wrote:

> [1 ]
> 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.

kill -9 MYSQLD_PID while the backup is running should give you an
indication.


--
Raj Shekhar
-
If there's anything more important than my ego around, I want it
caught and shot now.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: mysqldump backup

>-----Original Message-----
>From: Raj Shekhar [mailto:rajlist@rajshekhar.net]
>Sent: Friday, May 28, 2010 2:40 PM
>To: mysql@lists.mysql.com
>Cc: mysql@lists.mysql.com
>Subject: Re: mysqldump backup
>
>In infinite wisdom Angelina Paul wrote:
>
>> [1 ]
>> 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.
>
>kill -9 MYSQLD_PID while the backup is running should give you an
>indication.
>
[JS] If you know the file name of one of your databases, how about just using
the cat (*nix) or copy (Windows) command to trash a little bit of it.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com



>
>--
>Raj Shekhar
>-
>If there's anything more important than my ego around, I want it
>caught and shot now.
>
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=jerry@gii.co.jp





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org