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
>constraints.
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 ?
>
>Thanks,
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
