Just use
SET FOREIGN_KEY_CHECKS=0
To turn off all foreign key contraints before you import the data.
Then use
SET FOREIGN_KEY_CHECKS=1
to turn them back on.
Go to http://www.innodb.com/ibman.html and search for foreign_key_checks for the docs.
Hope this helps.
Toro
> On 01/09/2003 at 1:01 Chris
On 01/09/2003 at 1:01 Chris Nolan wrote:
>Hi!
>
>If you have a look at the documentation at www.innobase.com, you'll find
>somewhere it mentions a few directives that you can use to turn off FK
>checking for a temporary period. The solution to your problem is there.
>
Thanks for your reply.
I o
Hi
I've a DB using InnoDB tables and FK. If dump DB and try to import the
resulting text file I receive many errors because at import time mysql try
to import tables that have FK on tables not yet imported.
How could I dump/import telling MySQL to order dump tables having in mine
FK to avoid err
