GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Tech Comparing/Diff-ing MySQL Tables

Barry-xlovecam · 04-05-2017, 06:02 PM

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

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