Compare Two MySQL Database With Mysql Structure Compare
Developers often need to check the changes in some particular databases, in such situations MySQL Structure Compare can come in real handy, as it lets you compare two MySQL databases.
It is a portable application so there is no need for the installation, simply download and run it, then specify the remote host IP, the databases names to be compared, and the login details for your remote mysql server and their connection ports. Once done with all the settings, hit the Compare Databases button, and it will display the changes between the structure of both the databases. The database specified in the first column is considered as the source data base and the database specified in the second column is considered as the destination database.
Download MySQL Structure Compare
It works on Windows XP, Windows Vista, Windows Server 2003/2008, and Windows 7.
You can try dbForge Schema Compare for MySQL for this issue, it completely solves database schema comparison and synchronization.