View Single Post
Old 04-05-2017, 06:02 PM  
Barry-xlovecam
It's 42
 
Industry Role:
Join Date: Jun 2010
Location: Global
Posts: 18,083
run mysqldump with "--skip-opt" to get the 2 dumps files i.e:

Code:
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:

Code:
diff -y --suppress-common-lines /tmp/dump1 /tmp/dump2
diff - How do I see the differences between 2 MySQL dumps? - Stack Overflow

Interesting thread you would have to try and see ...

see: $ man diff
Barry-xlovecam is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote