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 17: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
