Merging MySQL Structure and Data

Posted by Shahid on Stack Overflow See other posts from Stack Overflow or by Shahid
Published on 2010-01-19T12:20:15Z Indexed on 2010/04/11 8:03 UTC
Read the original article Hit count: 273

Filed under:
|
|
|
|

I have a MySQL database running on a deployment machine which also contains data. Then I have another MySQL database which has evolved in terms of STRUCTURE + DATA for some time. I need a way to merge the changes (ONLY) for both structure and data to the DB in deployment machine without disturbing the existing data. Does anyone know of a tool available which can do this safely. I have had a look at a few comparison tools but I need a tool which can automate the merge operation. Note also that most of the data in the tables is in BINARY so I can't use many file comparison tools. Does any one know of a solution to this? thanks

© Stack Overflow or respective owner

Related posts about mysql

Related posts about tool