Ian, when you import the dump(s), put
SET FOREIGN_KEY_CHECKS=0; at the start of the dump file. I think that the latest version of mysqldump in upcoming 4.1.1 will put that automatically. Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL support from http://www.mysql.com/support/index.html ----- Alkuperäinen viesti ----- Lähettäjä: "Dwight Ian" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Saturday, November 29, 2003 8:33 AM Aihe: Re: Backup is Alphabetical > Hi, > I tried to set it in mysqld and it still alphabetize the tables... > my mysqldump syntax is this. > > mysqldump -acr c:\backup.sql prism > where prism is the database. > > All I wanted to happen is for the the tables to be in order of referential integrity NOT alphabetical > > Heikki Tuuri <[EMAIL PROTECTED]> wrote: > Dwight, > > SET FOREIGN_KEY_CHECKS=0; > > please address these general MySQL/InnoDB questions to > [EMAIL PROTECTED] > > Regards, > > Heikki > > > > ----- Alkuperäinen viesti ----- > Lähettäjä: "Dwight Ian" > Vastaanottaja: "Heikki Tuuri" > Lähetetty: Thursday, November 27, 2003 3:35 AM > Aihe: Backup is Alphabetical > > > > > > Hi. > > > > I have a table in innodb. I backup it using mysqldump and it did work. But > the problem is that the tables are listed in alphabetical order!. Since the > tables need to be in order of referencial integrity, it will not work if i > restore it. > > > > What will I do. > > > > Thanks. > > > > > > > > --------------------------------- > > Do you Yahoo!? > > Free Pop-Up Blocker - Get it now > > > > --------------------------------- > Do you Yahoo!? > Free Pop-Up Blocker - Get it now -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]