Re: Check differences in MySQL tables/database

Jonathanwri73 — Tue May 31, 2011 12:23 am

Author: Jonathanwri73

Posted: Tue May 31, 2011 12:23 am

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

Check differences in MySQL tables/database

bobthebob1234 — Mon May 30, 2011 2:04 pm

Author: bobthebob1234

Posted: Mon May 30, 2011 2:04 pm

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

Linux Format forums

Re: Check differences in MySQL tables/database

Check differences in MySQL tables/database