On Tue, 07 Dec 2004 16:51:10 -0700 Titus <[EMAIL PROTECTED]> wrote: > > On page 822 of the pdf copy of the documentation > that I have, it says: > > "To make it easier to reload dump files for tables > that have foreign key relationships, mysql automatically > includes a statement in the dump output to set FOREIGN_ > KEY_CHECKS to 0 as of MySQL 4.1.1." > > I'm using MySQL 4.1.7 and the dumps do not appear to > include this line automatically. I am having to add > it manually. What am I overlooking?
I THINK you have to add it manually to your dump file. Personally I wish MySQL would add this as an option to mysqldump as I can never remember the syntax to this command when I do an import with InnoDB tables. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]