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 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 found a "DISABLE KEYS" command in ALTER TABLE nut it's a per table > setting. > > When you dump a DB with --opt (disabling keys, etc) it [put a disable keys > before insert data dumped but not before a "create table" statement. Then > it doesn't work. > > I could not believe there are no clear command/setting for this simple and > typicall procedure..... :( > > > Any idea ??? > > > <jl> > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]