Help
Once you have corrected the error, follow this procedure to determine where to restart the slave after the event that caused the error:
- Check the position it stopped on using the following command:
SHOW SLAVE STATUS
- Use
Master_Log_FileandRead_Master_Log_Posto determine the next event to transfer from the master.
- Use
Relay_Master_Log_FileandExec_Master_Log_Posto determine the next event to apply for the master log.
- Use
Relay_Log_FileandRelay_Log_Posto determine the next event to apply for the relay log.
- Use
mysqlbinlogto read the contents:
mysqlbinlog master-log.000001 mysqlbinlog relay-log.000001
- Investigate the problem and, if required, remove rows in database:
SET SQL_SLAVE_SKIP_COUNTER=1; START SLAVE
Consult the online MySQL Reference Manual for more details about MySQL replication if you're still having trouble.
