Soren, the SQL command
SET FOREIGN_KEY_CHECKS=0 is in the TODO list of May 2002. It will probably be in 3.23.52. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com ----- Original Message ----- From: <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, May 30, 2002 12:32 PM Subject: Dumping in the right order (Innodb) > Hello, > > i have a problem with foreign key constrains. > > If i dump some tables (type = innodb) with mysqldump, i get a dump, > which is in alphabetical order. > > The problem is now, if the first table has an foreign key to the second > table, i will get an error, if i dump the dump into the database. > > How i can fix that? > > My idea is a simple Perl script, witch dump all the tables alone with a > given order and then ad them all to one (dump-) file ... if mysql has not a > right "features" against that problem. > > Sören > > --------------------------------------------------------------------- > Im Juni geht's ab! Die MTV Campus-Invasion rockt die Unis mit > absoluten Top-Acts: Silverchair, Reamonn, Naidoo und viel andere. > Mehr unter http://www.firstcampus.com/de/ > --------------------------------------------------------------------- > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
