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?