mysql - How to update a database that has foreign keys constraints? -

I have a virtual machine (VM_A) that runs a MySQL database DB_A schema with 200 rows in a tSQL_1. In another virtual machine (VMB) that runs a copy of the same DB_A schema, there is 50 rows in tbl_1. I

I want to update DB_B with data from DB_A.

Tbl_2 holds a foreign key from TBBI.

I have already created mysql dump to run in DB_A from DB_A, to update.

I do not want to use drop schema, before that drop tubbly

If I try to run the code in DBH, then I will have an error due to the foreign key construct in TBL.

What's the best way to update DB_B in this scenario? I have already tested this solution but have not worked

MS SQL-Server is in Mysql Modify your session variable

  SET FOREIGN_KEY_CHECKS = 0;