Linux Format forums Forum Index Linux Format forums
Help, discussion, magazine feedback and more
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Check differences in MySQL tables/database

 
Post new topic   Reply to topic    Linux Format forums Forum Index -> Programming
View previous topic :: View next topic  
Author Message
bobthebob1234
LXF regular


Joined: Thu Jan 03, 2008 9:38 pm
Posts: 1369
Location: A hole in a field

PostPosted: Mon May 30, 2011 2:04 pm    Post subject: Check differences in MySQL tables/database Reply with quote

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
_________________
For certain you have to be lost to find the places that can't be found. Elseways, everyone would know where it was
Back to top
View user's profile Send private message
Jonathanwri73



Joined: Mon Aug 22, 2005 8:12 pm
Posts: 13
Location: UK

PostPosted: Tue May 31, 2011 12:23 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: View next topic  
Display posts from previous:   
Post new topic   Reply to topic    Linux Format forums Forum Index -> Programming All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Linux Format forums topic RSS feed 


Powered by phpBB © 2001, 2005 phpBB Group


Copyright 2011 Future Publishing, all rights reserved.


Web hosting by UKFast