Hello I am following Reindl Harald dbmail3-migration procedures.
Upstream version dbmail v2.2.17 with mysql 5.5.21. Target server is dbmail v3.0.2 with mysql 5.5.21 and Reindl's proposed config setup files in dbmail3-migration.zip package (dbmail.conf, my.cnf). Used scenario was: 1) mysqldump dbmail from v2.2.17 2) create fresh new dbmail v3 database 3) import mysqldump.sql 3) run sql-convert-2_2-3_0.sql After waiting several hours dodropkeys() procedure to be done, I got the following error: .... -------------- DROP TABLE IF EXISTS `dbmail_envelope` -------------- -------------- CREATE TABLE `dbmail_envelope` ( `physmessage_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `envelope` TEXT NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `physmessage_id_1` (`physmessage_id`), UNIQUE KEY `physmessage_id_2` (`physmessage_id`,`id`), CONSTRAINT `dbmail_envelope_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 -------------- ERROR 1005 (HY000) at line 77: Can't create table 'dbmail.dbmail_envelope' (errno: 150) Thanks for your help Pascal _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
