How to import multiple related tables in MySQL?

Question

MySQL

There are two databases with the same structure. Each of them has ≈15 related tables. It is necessary to combine them into one, while maintaining the links between the records in the tables. If you import table by table, then the auto-increment fields will get new values, and the links between tables will be destroyed. Is there a tool or a way how to do an import while maintaining relationships between tables?

Answer 1

You can try like this. In one of the source databases, increase the ID values ​​by 1000000000 and the key values, respectively, too (this is if there is no ON UPDATE CASCADE). Import with iD values ​​so that they are not generated on insertion. After import, set AUTO_INCREMENT value for tables.