MySQL Replication Error: Duplicate Entry
Filed Under (Misc.) by Kirby Witmer on 08-07-2008
I just realized today that my MySQL slave box was like way out of sync. Yikes. The error message was ‘Duplicate Entry’. Which is like weird, because this is simply a replicated slave box, why would there be a duplicate entry anyway? After much searching I discovered this fix that worked like a charm. Just add the following line to the [mysqld] section of the slave’s my.cnf file.
slave-skip-errors = 1062
It worked, BUT is this a good idea? anyone have a betterĀ idea?

