Tuesday, March 30, 2010

[Level 2] How to Repair MySQL Replication.

When MySQL slave stop, how to start it.
You can use the command as following:
mysql> stop slave;
mysql> set global sql_slave_skip_counter=1;
mysql> start slave;
mysql> show slave status;

Wish this helps.

regards,
Stanley Huang