Re: mysqldump on slave.

2007-07-08 Thread Ananda Kumar
gt; Hi All, > I am planning to take mysqldump on slave running innodb engine. > > I going to use the below command > > /usr/bin/mysqldump --user=root --password= --flush-logs > --all-databases > --master-data=2 --single-transaction > alldbdump.sql > > Before doing the

Re: mysqldump on slave.

2007-07-07 Thread Alex Arul Lurthu
server needs to maintain due to the dump. Thanks Alex On 7/6/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: Hi All, I am planning to take mysqldump on slave running innodb engine. I going to use the below command /usr/bin/mysqldump --user=root --password= --flush-logs --all-databases --

mysqldump on slave.

2007-07-05 Thread Ananda Kumar
Hi All, I am planning to take mysqldump on slave running innodb engine. I going to use the below command /usr/bin/mysqldump --user=root --password= --flush-logs --all-databases --master-data=2 --single-transaction > alldbdump.sql Before doing the mysqldump, should i stop the slave or