Oct 22, 2018

How to manually resume MySQL replication to bypass minor error

In MySQL, if your replication stops because of one minor error, you don't want to start your replication from scratch just because of this minor error which does not affect the replication on the whole. Then one option to keep the replication going is:

mysql>SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;



Then to make sure the replication is catching up without errors, run:
mysql> show slave status\G;

This is useful for some unexpected events happen to the server
.

It is not recommended for you to put

slave-skip-errors = error code (such as 1062)

in your mysql configuration file.


( You can even ignore all errors:
[mysqld]

slave_skip_errors=all
)

If this
skip just one query method doesn't help, then it is very likely you need to start your replication from scratch.