If you’re working with small databases I’ve found running mysqldump on both databases with the
--skip-extended-insert options to generate SQL scripts, then running diff on the SQL scripts works pretty well.
By skipping comments you avoid meaningless differences such as the time you ran the mysqldump command. By using the
--skip-extended-insert command you ensure each row is inserted with its