Now drops the index of the sievescripts table regardless of the name. Truncate the envelope table to prevent double key values.
HaraldAm 13.02.2012, 16:44 Uhr, schrieb ITronic Harald Leithner <[email protected]>:
schaut so aus...I have a key called owner_idnr_2 this key is a index on owner_idnr and name. (looks like the update from 2.0 to 2.2). You have the same fields as unique key from 2.2.5 to 2.3.0 maybe the sql script should be changed to consider this.Am 13.02.2012, 16:27 Uhr, schrieb Reindl Harald <[email protected]>:AFAIK this is from Fedora 10/11 2009 maybe they have backported constraints which was originally not there and with not exactly the same name :-( 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`) ONDELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED; Am 13.02.2012 16:18, schrieb ITronic Harald Leithner:Can you show me your create statement for dbmail_sievescripts?Am 13.02.2012, 16:06 Uhr, schrieb Reindl Harald <[email protected]>:Am 13.02.2012 15:35, schrieb Paul J Stevens:On 02/13/2012 03:24 PM, Reindl Harald wrote:hi is there a really good reason dropping all foreign keys and create them new? this queries are running a very long time (i am testing your convert-sql this moment)This script was changed to be more robust in the face of slightly different BIGINT columns. Changing the widths on columns involved in key constraints is only possible after first dropping the key entirely. If the 'old' script (pre-today) worked for you: use that.i will play around, something does not work here with the new one transition is running, time measure later [root@dbmail-test:/data/dbmail3-migration]$ ./convert.shERROR 1091 (42000) at line 200: Can't DROP 'owner_idnr_2'; check that column/key exists_______________________________________________ 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
mysqlupdate.patch
Description: Binary data
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
