> My problem is , > I take backup using MYSQLDUMP Utility and entre database get backed > up. But all the tables in squenitial order. When I restore backup, It > does not get restored because first it should create parent table > then child like in hirarchial order of relationship. >
Here is an answer from http://www.mysql.com/doc/en/mysqldump.html : for "mysqldump" ing innodb tables\ take the dump as you would normally do using mysqldump open the dump file put this statement at the beginning SET FOREIGN_KEY_CHECKS=0; of the sql dump text file and import the same file as you would nomally import an sql dump file Greetings, Jacek Wozniak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
