Combining multiple MySQL databases into one preserving referential integrity

Question

I want to combine multiple MySQL databases, all with the same schema definition, into one database. If I have a dump file from each database, how can I import them all into one database without their primary keys and foreign keys?

Is there an easy way to do this, or do I need to write some kind of custom code that understands the data and creates the consolidated record set “manually”?

Answer 1

, , , . , , , .