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 only