Check differences in MySQL tables/database

Code junkies hangout here

Moderators: ChriThor, LXF moderators

Check differences in MySQL tables/database

Postby bobthebob1234 » Mon May 30, 2011 1: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.

For certain you have to be lost to find the places that can't be found. Elseways, everyone would know where it was
LXF regular
Posts: 1373
Joined: Thu Jan 03, 2008 9:38 pm
Location: A hole in a field

Postby Jonathanwri73 » Mon May 30, 2011 11:23 pm


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.

User avatar
Posts: 13
Joined: Mon Aug 22, 2005 7:12 pm
Location: UK

Return to Programming

Who is online

Users browsing this forum: No registered users and 0 guests