MySQL Compare Databases

Last updated on September 21st, 2021 at 11:10 am

Sometimes you may need to compare two databases in MySQL. Here’s how to compare databases in MySQL using command line utility.

How to Compare databases in MySQL

Here are the steps to compare databases in MySQL.

Let us say you want to compare two MySQL databases db1 and db2.

First, we will take backup of both databases, that is, create .sql files for each database

# mysqldump --skip-comments --skip-extended-insert -u root -p db1>db_file1.sql
# mysqldump --skip-comments --skip-extended-insert -u root -p db2>db_file2.sql

Bonus Read : MySQL Alter Stored Procedure

In the above commands, –skip-comments skips comments and –skip-extended-insert creates separate insert statement for each row, making it easier to compare databases.

Second we use the diff tool to compare these two files