Transferring data from an old database to a modified new one?

Question

MySQL

Such a situation, there is a database already with data, I had to change / add several tables. I recreated the database, there is a dump of the old version of the database. How to transfer data from old to new?

Answer 1

If the dump was made with the --extended-insert option (that is, it contains the order of the values), then DROP TABLE/CREATE TABLE and DROP DATABASE/CREATE DATABASE must be removed from the dump, if necessary, set the default values ​​in the new database to those missing in field dump (it is possible temporarily) and then import the dump. Naturally, in the new database, before the import of the dump, there should not be any data before this, so as not to spoil the referential integrity and not to fall into duplicates of unique values.