Hi! In upcoming 3.23.52 you can put
SET NO_FOREIGN_KEY_CHECKS=1; at the start of your dump file. Then you can import your tables in any order. This syntax is not yet in 4.0.2. 4.0.2 will be released probably next week, 3.23.52 a few days later. 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: "Christopher Book" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, July 04, 2002 10:06 PM Subject: innodb database schema dump > I had the same problem, and while I don't think there's a way around it, you > can load the schema with the force option so that it will eventually make it > to the table the must be created first, (even if a previous table creation > gives an error). Running the script many times over and over will > eventually add all the tables :). > Chris > > >>how can i dump innodb tables schema with foreign key references so that > the tables are created in the right order ? thanks, Pierre -- sql,query > > > --------------------------------------------------------------------- > 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