Here is a useful article about fixing replication when it stops.

Basically:

  1. STOP SLAVE;

  2. SHOW SLAVE STATUS; (make a note of exec_master_log_pos and master_log_file).

  3. RESET SLAVE;

  4. CHANGE MASTER TO...

CategoryDatabase

ResettingMysqlReplication (last edited 2008-08-27 13:42:15 by DavidKeen)