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]