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 the above command
is
enough
the 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
--master-data
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
Hello,
I am dumping a single innodb DB using mysqldump. Everytime I do it, it
crashes the slave thread.
Below are the commands I'm using to dump [I also have tried
--delete-master-logs command in the actual data dump too (second line)
with the same problem.] I am willing to hear advice on the
Hello,
I am dumping a single innodb DB using mysqldump. Everytime I do it, it
crashes the slave thread.
Below are the commands I'm using to dump [I also have tried
--delete-master-logs command in the actual data dump too (second line)
with the same problem.] I am willing to hear advice on the