Check differences in MySQL tables/database

[bobthebob1234]

I have two versions of a database at the moment (one on testing server, with more up to date info, one on production server, older info but may have some new /edited stuff)

Basically does anyone know of a script that I can run on the two databases to check for differences in data and possibly structure, before I overwrite the production database with the one on the testing server, or am I going to have to write one?
I did a quick google but couldn't find anything.

danke

[Jonathanwri73]

Hi,

Have you tried looking at mysqldiff, this is a perl script that could compare and highlight any differences between table definitions.

This may help some, otherwise you may want to look at mysqldump options and to try and compare the differences on a table-by-table level but that can get messy and time consuming.

regards,
Jonathan