How do I see the differences between 2 MySQL dumps?

Question

I have 2 MySQL dump files. I want to find the table data difference between 2 tables.

Answer 1

run mysqldump with "--skip-opt" to get the 2 dumps files i.e:

mysqldump --skip-opt -u $MY_USER -p$MY_PASS mydb1 > /tmp/dump1.sql  mysqldump --skip-opt -u $MY_USER -p$MY_PASS mydb2 > /tmp/dump2.sql 

compare using these diff options:

diff -y --suppress-common-lines /tmp/dump1 /tmp/dump2 

Answer 2

Use a DIFF tool - here are some graphical ones (both are free):

• KDIFF
• winmerge