Export and import data from PHPMYADMIN

Question

I exported data with phpMyAdmin, but when I import the data I get this error:

#1452 - Cannot add or update a child row: a foreign key constraint fails

I can set the data accordingly and then I don't get the error. But is there a better way to do this? Something like disabling some options in phpMyAdmin or adding some query to SQL?

Answer 1

The problem is pma doesnt care about the order for the insert rows. so it happens a table-row is inserted with an FK where the FK row is not yet imported.

To solve this use the checkbox Disable Foreign Key Checks when exporting from PhpMyadmin. Or set it yourself:

SET FOREIGN_KEY_CHECKS=0;

and at the end:

SET FOREIGN_KEY_CHECKS=1;