We have a MySQL backup. Did some changes on our database and some data was lost. In the mean time new records were added.
We have to restore the mysql backup over our latest data. Some of the tables have auto increment columns which means that we will end up with the same primary key but different values in some tables. The majority of the tables are from a many-to-many or one-to-many relationships.
What is the best approach to resync the same schema between the backup and the current data?