Source of the article

http://stackoverflow.com/questions/225772/compare-two-mysql-databases

If you want to compare use following shell script, from the stackover flow question.

!/bin/sh echo "Usage: dbdiff [user1:pass1@dbname1] [user2:pass2@dbname2] [ignore_table1:ignore_table2...]" dump () { up=${1%%@}; user=${up%%:}; pass=${up##:}; dbname=${1##@}; mysqldump --opt --compact --skip-extended-insert -u $user -p$pass $dbname $table > $2 } rm -f /tmp/db.diff # Compare up=${1%%@}; user=${up%%:}; pass=${up##:}; dbname=${1##@}; for table in mysql -u $user -p$pass $dbname -N -e "show tables" --batch; do if [ "echo $3 | grep $table" = "" ]; then echo "Comparing '$table'..." dump $1 /tmp/file1.sql dump $2 /tmp/file2.sql diff -up /tmp/file1.sql /tmp/file2.sql >> /tmp/db.diff else echo "Ignored '$table'..." fi done less /tmp/db.diff rm -f /tmp/file1.sql /tmp/file2.sql

Ignore Joomla tables, Since data is getting created on login..

jos_session,jos_content,jos_users,jos_updates.jos_update_sites