Compare 2 database schemas on Mysql Compare 2 database schemas on Mysql database database

Compare 2 database schemas on Mysql


Navicat for MySQL does this with its "Structure Synchronization" tool, but it is not open source (US$179). It will compare tables showing you all the differences and also provide you with the SQL to sync them up.

There is a free 30-day trial which you could use to do a quick comparison. Windows, Linux, and Mac versions.