Compare (collate) MySQL databases

Recently I used to be in a group that had a task to migrate few servers without downtime, and by mistake made by one of our system administrators one of the servers went live with outdated database.

Since when we discovered that mistake two days later, there were major changes happened on the database and we had to compare it with the most recent one.

I will not fall into details, but I will say that on that server we didn’t have SSH access, as well as that the remote access to 3306 port number was forbidden. PHPMyAdmin installation was the only way to dump the database.

Then we had to compare the MySQL changes that were made on the database while it was live.
During that time I found ExamDiff which is a freeware Windows tool for visual database comparison. It has a number of simple and convenient features that many users have been asking for a long time from a file comparison tool.

The tool usage is rather easy. Start the application and then choose the MySQL databases backups to compare.

Compare (collate) MySQL databases

There is also ‘Options’ menu which is pretty self explainable for an experienced MySQL database user.

Click ‘Ok’ and the differences will be displayed as listings with line numbers.

Compare (collate) MySQL databases

As you can see there are number of visual options that allows you display the MySQL database differences in the best way you need them.
It has a long list of options described in this article: Visual file comparison – ExamDiff preferences

If you prefer the command line usage here are the available options:

Tags

Filed Under: MySQL

Anthony Gee About the Author: Anthony G. is an IT specialist with more than 9 years of solid working experience in the Web Hosting industry. Currently works as server support administrator, involved in consultative discussions about Web Hosting and server administration. One of the first writers in the Onlinehowto.net website, now writing for Free Tutorials community - he is publishing tutorials and articles for the wide public, as well as specific technical solutions.

Leave a Reply