I got the same problem on upgrading...
Paul could we truncate the dbmail_envelope table in the sql script?
Am 14.02.2012, 12:58 Uhr, schrieb Reindl Harald <h.rei...@thelounge.net>:
thanks
can you also have a look at the unique key in "dbmail_envelope"?
this was not present in the past and i had duplicate entries
in the dbmail-2.2 data, so i removed them and added the key
manually in the running 2.2 database to not run into this while
making the final upgrade
Am 14.02.2012 12:45, schrieb ITronic Harald Leithner:
I will update the sql script to detect the index key and drop it, so
the rest of the script should run fine.
Am 14.02.2012, 12:41 Uhr, schrieb Paul J Stevens <p...@nfg.nl>:
On 02/14/2012 12:10 PM, Reindl Harald wrote:
how acts mysql in this case if one of the queries is failing?
will it stop the whole execution or only skip the line?
mysql -u dbmail -p*** dbmail < sql-convert-2_2-3_0.sql
By default mysql will stop. If you want it to continue use the -f
switch
mysql -f dbmail < convert.sql
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
