There is a problem in the sql Script from Harald Reindl.
The script creates the envelope table to early.
You could try to use the 2_2-3_0.mysql script in sql/mysql directory found
in the dbmail.tar.gz
after "DROP PROCEDURE IF EXISTS dodropkeys;"
regards,
Harald
Am 17.04.2012, 10:30 Uhr, schrieb Pascal Longrais
<[email protected]>:
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
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
