If you need to compare the structure or maybe even the content of two MySQL databases you will need a tool which will help you with this not too straight task. Here is an overview of some application which will help you succeeding the work.
Percona Toolkit
Has several database comparison and syncing tools among other things.
Liquibase
Open source library for tracking, managing and applying database changes.
Toad
Can do both a “Schema Compare” as well as a “Data Compare”
MySQL Diff
Free command line tool. Does a good job comparing the table structures, but does not support all MySQL features.
SQLyog MySQL
It is not free but doing a very good job in comparing databases.
February 11th, 2013 at 5:41 am
The toad url is a 404 FYI
February 11th, 2013 at 6:36 am
Thank you.
February 11th, 2013 at 10:17 am
If speed or ease of use are important to you, and commercial tools are an option, then also consider trialling Red Gate’s schema and data comparison tools:
http://www.red-gate.com/products/mysql/mysql-comparison-bundle/
I work for Red Gate and database deployment tools are a real speciality of ours. Do get in touch if you have any questions.
February 11th, 2013 at 2:31 pm
Why not list SQLyog? It has both Schema Sync and Data Sync tools (and both can ‘compare’ and ‘synchronize’; compare means generate a script without actually executing. And there is a Visual Data Compare Tool as well.
https://www.webyog.com/product/sqlyog
February 11th, 2013 at 4:05 pm
I have used this for years and have found it to be very useful and effective:
https://bitbucket.org/stepancheg/mysql-diff/wiki/Home