Can you show me your create statement for dbmail_sievescripts?
Am 13.02.2012, 16:06 Uhr, schrieb Reindl Harald <h.rei...@thelounge.net>:
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
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
