Import of db problems

Hi All,

I have a database that has innodb tables with foreign keys. The export via phpmyadmin runs fine. When I try to import the db I receive foreign keys errors for tables that have a reliance on tables that come "after" it.

The table structure is already in place, just that the tables are empty and I am trying to place the data in them.

Am I exporting this incorrectly?

I have started doing this one table at a time, but that is a pain and slow. Is there another way?

Thank you for your time,
oach

i stopped using phpmyadmin years ago so i don't recall how much flexibility it has in these matters

one way to approach the task is to re-sequence your INSERT statements manually (cut/paste in a text editor) so that the data for dependent tables comes after the tables they reference

alternatively, issue ALTER TABLE statements to DROP all your FKs, load all the data, then issue more ALTER TABLE statements to add the FKs back again -- this is the part i'm not sure if phpmyadmin can help you with, although it's certainly possible if done manually