MySql Compare databases schema and data options

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% [Read More]