merge/sync two mysql databases
Posted on 2012-03-21
I have two mysql databases with the same structure and a ton of tables.
I would like to merge the two.
(What happened was, I had to move to another hosting provider, and in the process, somebody placed an order on the old server, and my new database does not have this info. But the new database has new info, so I can't just replace it with the old one. I tried INSERT from TO, with individual tables, but there are too many linked tables, and I can't be sure everything was moved correctly.)
Maybe is there a widget out there that will sync these for me?