Consolidate multiple MySQL databases into one preserving referential integrity
I'm wanting to consolidate numerous MySQL databases, all with the same schema definition, into a single database. If I have a dump file from each database, how will I import them all into the same database without their primary keys and foreign keys clashing?

Is there a fairly simple way to do this, or will I need to write some custom code that understands the data and creates a consolidated set of records 'manually'?
Consolidate multiple MySQL databases into one preserving referential integrity
===

I'm wanting to consolidate numerous MySQL databases, all with the same schema definition, into a single database. If I have a dump file from each database, how will I import them all into the same database without their primary keys and foreign keys clashing?

Is there a fairly simple way to do this, or will I need to write some custom code that understands the data and creates a consolidated set of records 'manually'?