How to re sync MySQL slave when duplicate entries exist.

So your slave is out of sync and RESET the slave but you see this error when doing a SHOW SLAVE STATUS \G;

Last_Errno: 1062

How to remedy.


1) > Stop slave.
2) update my.cnf with

slave-skip-errors = 1062

3) restart MySQL

4) Start Slave.

Bonus other Errors:

Delete_rows NO RECORD ERROR (1032) , Table already exists (1050)

add multiple like:
slave-skip-errors = 1062, 1032, 1050