When you have databases in production and need to push upgrades, one of the scenarios is the database having more tables, more columns and extra or different data.
MySQL utilities can help with this:
https://downloads.mysql.com/archives/utilities/
After installing this and launching MySQL Utilities console, running:
mysqldbcompare --server1=user:password@server database1:database2
Will list all differences and update MySQL queries necessary to make them match.
Use the option –run-all-tests do the execution does not halt on exceptions.