Posted by chuck peterson
MySQL Compare replicated database table
I needed to compare 2 tables in separate instances (siblings) of MySQL replication. So this script dumps the unique id from the first server into a temp table on the second server. This is assuming that the second server is having missing record errors. There are MANY comments in the code for more details. This is meant to be made executable and run on command line.