the workaround is in the link you posted ALTER TABLE dbmail_sievescripts ADD UNIQUE INDEX dbmail_sievescripts_1 (owner_idnr, name);
no idea why your keys are different, my definitions are from fedora summer 2009, however i would generally reccomend exclude all unique-key-changes out of the migration-sql-file and add them BEFORE migration because i had also existing records which did not allow add unique keys in one of the tables becuase they were redundant/oprhaned over the years and i had to delet them before set unique keys the unique keys are to prevevent insert such records in the future but you can not add them if duplicate entries still exists _______________________ your `dbmail_sievescripts` CREATE TABLE `dbmail_sievescripts` ( `owner_idnr` bigint(21) NOT NULL default '0', `name` varchar(100) NOT NULL, `script` text, `active` tinyint(1) NOT NULL default '0', KEY `name` (`name`), KEY `owner_idnr` (`owner_idnr`), KEY `owner_idnr_2` (`owner_idnr`,`name`), CONSTRAINT `dbmail_sievescripts_ibfk_1` FOREIGN KEY (`owner_idnr`) REFERENCES `dbmail_users` (`user_idnr`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; _______________________ my dbmail-2.2 `dbmail_sievescripts` dbmail_sievescripts | CREATE TABLE `dbmail_sievescripts` ( `owner_idnr` bigint(10) unsigned NOT NULL DEFAULT '0', `name` varchar(100) NOT NULL, `script` text, `active` tinyint(3) unsigned NOT NULL DEFAULT '0', UNIQUE KEY `dbmail_sievescripts_1` (`owner_idnr`,`name`), KEY `name` (`name`), KEY `owner_idnr` (`owner_idnr`), CONSTRAINT `dbmail_sievescripts_ibfk_1` FOREIGN KEY (`owner_idnr`) REFERENCES `dbmail_users` (`user_idnr`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 Am 08.02.2012 21:07, schrieb drsyst...@globalcerts.net: > Here is one of the places where this problem is discussed, but I don't > find or understand the workarounds for this. > Thanks, > Dirce > > http://www.gossamer-threads.com/lists/dbmail/dev/30854?do=post_view_threaded> > > > >> >> Am 08.02.2012 19:46, schrieb drsyst...@globalcerts.net: >>> Hi, >>> >>> I am running the script >>> >>> /var/lib/mysql/dbmail[157] mysql < 2_2-3_0.mysql >>> >>> on an old host (test host) that I want to migrate. >>> >>> I get the error: >>> >>> ERROR 1025 (HY000) at line 68: Error on rename of >>> './dbmail/#sql-9dd_357e' >>> to './dbmail/dbmail_users' (errno: 150) >>> >>> I have been fixing it one db at a time by doing: >>> mysql>show create table dbmail_... >>> and then >>> mysql>alter table dbmail_sievescripts drop foreign key >>> dbmail_sievescripts_ibfk_1; (for example) >> >> * what mysql version >> * what OS >> * what yasys the mysqld errorlog >> * how much free space on disk >> >> the error message alone is pointless because >> this is only a standard message of the mysql-client >> >> _______________________________________________ >> DBmail mailing list >> DBmail@dbmail.org >> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail >> > > > _______________________________________________ > DBmail mailing list > DBmail@dbmail.org > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
