At 7:13 PM -0400 9/16/03, Irwin Boutboul wrote:
>It looks like the dump works... however the way it is made, there is no
>way to use it to recreate the database because key constraints fail. The
>dump contains table creations in an order which does not respect key
If you have problems reloading the table due to the order
in which the InnoDB tables appear in the dump files, add
SET FOREIGN_KEY_CHECKS = 0;
to the beginning of the file before reloading it.
>Is there any work around to rebuild a database with innodb tables ? Or
>shall I first move every table to myIsam and then do the dump, re-import
>and finally reconvert tables to innodb ?
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/