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`) ON
DELETE 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.sh
ERROR 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
