Hi all,
The updated MySQL migrations scripts are in CVS. All tables are now
prefixed by 'dbmail_'. They also remove some unwanted indexes.
I've tested the InnoDB script on our DBMail db, and all seems to work
OK. Can other people test the scripts as well?
There's a possibility that the script tries to remove an index that does
not exits in your installation (the dbmail 1.2.x creation script does
not result in the same indexes as we have
in our database) or that it does not remove all unwanted indexes. Please
check this too.
And of course, run the script on a backup. MySQL does not work with
transactions at the DDL level it seems, so nothing will be rolled back
in case of a failure. Why it does not work like that I don't know.
PostgreSQL works just fine..
Ilja
--
Ilja Booij
IC&S B.V.
Stadhouderslaan 57
3583 JD Utrecht
www.ic-s.nl
T algemeen: 030 6355730
T direct: 030 6355739
F: 030 6355731
E: [EMAIL PROTECTED]
