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