Microsoft Musings

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?

No related posts.