Known Schema Comparison Problems
When comparing MySQL schemas, you may face some problems caused by MySQL limitations. Here is the list of widely-known problems:
- If you compare schema on MySQL 6.0 with another schema on MySQL 4 or 5.0, and there are tables with the TIMESTAMP column, the status of such tables will always be different even if they have the same structure or they were synchronized.
- MySQL does not allow editing tables with EXAMPLE table engine, so synchronization of such tables will fail.
- On the MySQL 6.0 table, containing VARCHAR column can have ROW_FORMAT = FIXED. On the earlier MySQL version, you may execute ALTER TABLE … ROW_FORMAT = FIXED but it does not do anything. So, such tables will have Different comparison status even if after their synchronization.