Skipping harmless replication errors.

From Notes

Jump to: navigation, search

When replication stop and the error is known and does not require resolution or the problem has been resolved, replication may be restarted with the following commands:

mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
mysql> START SLAVE;
Personal tools