Skip to content

Instantly share code, notes, and snippets.

@hugsbrugs

hugsbrugs/mysql-diff.sh

Last active April 12, 2016 13:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hugsbrugs/f479e57e9d9b4b5eda69c92b9c50c5ba to your computer and use it in GitHub Desktop.
Save hugsbrugs/f479e57e9d9b4b5eda69c92b9c50c5ba to your computer and use it in GitHub Desktop.
Download ZIP
Compare Mysql database
Raw
mysql-diff.sh
# Export first database
mysqldump --skip-comments --skip-extended-insert -u root -p database_1>file1.sql
# Export second database
mysqldump --skip-comments --skip-extended-insert -u root -p database_2>file2.sql
# Display differences between files
diff file1.sql file2.sql
# Ressource
http://www.mysqldiff.org/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment