[Resolved] import innodb tables

[Erkilite]

I am trying to upload a webproject i was working on and I want to dump the test db to a sql file and import it into the production db.

I use mysqldump to export the tables but when i try to import the tables it fails because of foreign key errors.

when you do mysqldump it outputs the table in alphabetical order instead of order based on foreign keys.

any ideas how to import an innodb table?

[eoghain]

If you are positive that your referances are correct in your file you can add this to the beginning:

set foreign_key_checks=0;

This will turn off foreign key checks, set it back to 1 at the end of the file if you are going to be doing more work in the same session.