compare 2 database tables


sdiff <(mysql -B -e "show tables;" -D a_database) <(mysql -B -e "show tables;" -D b_database)

skip same record from first col:
sdiff <(mysql -B -e "show tables;" -D a_database) <(mysql -B -e "show tables;" -D b_database) | grep '[<>]'

Leave a Reply

Your email address will not be published. Required fields are marked *