What are some free tools for comparing mysql database structures?

Question

MySQL

There are two databases from different versions of the engines, I want to see what changes have been made to the structure of the new database, tables with 500 pieces, manually it is very hemorrhagic.

Answer 1

dbForge Studio for MySQL is a great program with a lot of features, including schema comparison. Free.

Answer 2

You can try to do mysqldump --no-data for two databases
and vimdiff db1.sql db2.sql

Answer 3

Mysql Workbench (http://www.mysql.com/products/workbench/) can be tried, especially if you need a sql script to change the structure of the old database. If not needed, then it's easier, as niko83 said , to make dumps and compare them.

Answer 4

I advise you to use the mysqldiff utility .
Instruction.

Answer 5

You can pull the code from here: github.com/idler/MMP/blob/master/lib/dbDiff.class.php