How can I merge two mysql databases with identical schema?

I need to merge two two mysql databases with identical schema. I am looking for some tool that can read database meta-data (PK, FK) and automatically generate new PKs, updating all the FKs automatically.

From stackoverflow

• Check out SqlYog - http://www.webyog.com/en/. There is a 30 day trial for the enterprise edition which includes a tool to synchtonise data between databases (among many other useful tools).

• Not sure exactly what you mean, but if you got two databases and want to make them identifcal,try this tool - Database compare

  Christian Oudard : It seems that his databases are already identical, and he just wants to combine the data in them.