Finding missing records from two tables
So, dump both tables into two files and then see the difference with diff:

 mysql -h host1 -NB -e "SELECT * FROM db.table ORDER BY id" &gt; t1
 mysql -h host2 -NB -e "SELECT * FROM db.table ORDER BY id" &gt; t2

 diff -u t1 t2