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
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