>-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
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
Your table is missing. Try this:
?>mysqldump --single-transaction -u root clientdb
--where="FLD_CLIENT_ID=1" > client1_dbbackup.sql
-Original Message-
From: Rithish Saralaya [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 02, 2006 1:23 PM
To: MySQL general mailing list
Subject: mysqldum
