>-Original Message-
>From: Raj Shekhar [mailto:rajl...@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 ]
>>
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 Shek
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 --ma
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:
> Cou
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.
Than
Replicate your databases to another server, and take your dumps from
that, so you can lock your replication slave and take your dumps while
your site is still running. As an added bonus, you get a server
suitable for manual failover should anything happen to your master
database.
-Sheeri
On 3/10
>>Your table is missing. Try this:
>>mysqldump --single-transaction -u root clientdb
>>--where="FLD_CLIENT_ID=1" > client1_dbbackup.sql
>Yes. The tables are missing. That's because I want the backup of all the
>tables in the db, and those tables that have the column FLD_CLIENT_ID, they
>should b
>Your table is missing. Try this:
?>mysqldump --single-transaction -u root clientdb
--where="FLD_CLIENT_ID=1" > client1_dbbackup.sql
Yes. The tables are missing. That's because I want the backup of all the
tables in the db, and those tables that have the column FLD_CLIENT_ID, they
should be fil
ing list
Subject: mysqldump backup on filters
Hello.
We have a database driven system that serves multiple clients. We have a
single database for this purpose. The data(rows) in some of the tables are
specific to individual clients. In all such tables, we have a field
FLD_CLIENT_ID whose value depicts th
Hello.
We have a database driven system that serves multiple clients. We have a
single database for this purpose. The data(rows) in some of the tables are
specific to individual clients. In all such tables, we have a field
FLD_CLIENT_ID whose value depicts the client to whom that row of informatio
10 matches
Mail list logo
