Mysql Fix Duplicate Entry | Mysql Master Slave
mysql> show slave status\G
Last_SQL_Error: Error 'Duplicate entry 'example@google.com' for key 'PRIMARY'' on query.
STEP:
Delete the entry on the slave (make sure you check if you need the data copy it! )
mysql> slave stop;
mysql> SET GLOBAL sql_slave_skip_counter = 1;
mysql> slave start;
Insert the data on your master and it should replicate now on the slave.
Last_SQL_Error: Error 'Duplicate entry 'example@google.com' for key 'PRIMARY'' on query.
STEP:
Delete the entry on the slave (make sure you check if you need the data copy it! )
mysql> slave stop;
mysql> SET GLOBAL sql_slave_skip_counter = 1;
mysql> slave start;
Insert the data on your master and it should replicate now on the slave.
Comments