Eddie, ----- Original Message ----- From: "Eddie" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, August 07, 2003 11:06 AM Subject: transfer InnoDb in correct order ??
> Hellu, > > I want to transfer the structure of my InnoDb database to another > mysql server 3.23. > However, I don't seem to get this to work correctly as the tables are > not transfered in the correct order such that I get a bunch a foreign > key constraints. > Even if I use the MysqlPhp admin tool, Mysql Manager, SqlYog, it > doesn't work: they make an export of the db structure but the db > structure, that consists of create table statements, isn't in the > correct order, such that when I use the export script to make the new > database somewhere else, the tables can't be created because of > foreign key constraints. > > How can solve this, without putting the create statements in the > correct order manually ? Isn't there a handy tool that first checks if > other tables should be created, and if so, it does this, before adding > the table itself ?? > > Please some help, because ordering it manually isn't an option at > this moment with so periodically transfers and so many tables :( please upgrade to a recent version of MySQL and add SET FOREIGN_KEY_CHECKS=0; to the start of your dump file(s). > Eddie Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]