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/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
