Do you have any other sugestion?
Martín
At 0:15 +0000 10/18/03, Mart̀n Lahittette wrote:Hi,
I want to backup a MySQL 3.23 database to upgrade it to MySQL 4.0. My tables are InnoDB and they have foreign keys. I would like to know how to backup it, because it seems that neither mysqldump nor mysqlhotcopy can be easily used.
The restore script created by mysqldump contains the 'create table' (and data insert) instructions unsorted. So, when I run the script it fails because it many times tries to create tables referencing other tables that have not already been created.
Before loading the dump file, turn off foreign key checking. Invoke mysql, then issue these statements:
mysql> SET FOREIGN_KEY_CHECKS = 0; mysql> SOURCE your_dump_file;
On the other hand, the MySQL manual says (4.8.7 mysqlhotcopy) that mysqlhotcopy can only be used with MyISAM and ISAM tables.
Thanks in advance Martín
-- 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]
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]