======Overview====== Important function which the MySQL provides is the comparing of two databases. The utility which is used to achieve this is called: mysqldbcompare and can be found in the mysql utilities package: The utility is rather simple and can be used as follows: ====Usage==== The utility can perform three checks: * Definition Check * Row Count * Data Check And it is used as follows: PS C:\Program Files\MySQL\MySQL Utilities 1.6> mysqldbcompare.exe --server1='':''@: database1:database2 --run-all-tests --skip-data-check --format=vertical ====Output==== The output is also rather simple with comparing the: Definition, Row Count and/or Data content check: # # Defn Row Data # Type Object Name Diff Count Check # ------------------------------------------------------------------------- # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES pass pass SKIP # TABLE TABLE_NAMES FAIL FAIL SKIP <- In case we have a fail, the utility will show us what is the difference ====Difference==== In case the utility spots a difference, it will display the difference. # Object definitions differ. (--changes-for=server1) # --- ``.`` +++ ``.`` @@ -2,4 +2,4 @@ `id` int(6) NOT NULL AUTO_INCREMENT, `report` mediumtext, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=1583 DEFAULT CHARSET=latin1 +) ENGINE=InnoDB AUTO_INCREMENT=1627 DEFAULT CHARSET=latin1 <- In this case the AUTO_INCREMENT is different #