I've got two mysql databases created for DEV and TEST.
I created them both from the same sql script but in TEST, it identified some differences. This is a little odd as both databases were built from the same script but, no problem, i just need to run the synchronise script and they will be inline and report no differences right ? WRONG - After running the sync script to line up TEST with DEV, and rerunning the compare, it still shows 10 tables have diffferences but when viewing what it shows as different, they are the same.
In the schema, some of the tables are wordpress tables to which i have made no changes from the base wordpress install script and so these should not have any
The columns which seem to be identified as diferent are all VARCHAR columns that have no other parameter specified apart from being NOT NULL.
VARCHAR columns that have DEFAULT values or COLLATE set on them seem to be OK.