Difference between revisions of "MySQL Replication - Skip an error to continue replication"

(Created page with "You can skip certain errors that you find not important to continue the replication process. This ensures that replication is still working, after occurrence of the defined er...")
 
(No difference)

Latest revision as of 18:46, 14 April 2020

You can skip certain errors that you find not important to continue the replication process. This ensures that replication is still working, after occurrence of the defined error.

In Ubuntu (this path may differ):

vim /etc/mysql/mysql.conf.d/mysqld.cnf

Add this to the main mysql config file:

slave-skip-errors       = 1032

Here as an example skip replication inconsistency error (not recommended): 1032