[Dbmail] Error 1062 at line 53 in migrate_fro, _1.x_to_2.0_innodb.mysql

[Jacques Beaudoin]

Hi Paul

I first add this error in the mysql innodb migrating
script but did not report it to the mailing list.

error 1062 at line 53: duplicate entry '3668-INBOX' for key 3

THE SECTION OF THE SCRIPT WITH LINE 53 IS:

# alter mailboxes
RENAME TABLE mailboxes TO dbmail_mailboxes;
ALTER TABLE dbmail_mailboxes       <<<<<<<<<<<<< LINE 53 <<<<<<<<<<<<
##      DROP INDEX mailboxidnr_2,
        ADD INDEX name_index (name),
        ADD INDEX owner_idnr_index (owner_idnr),
        ADD UNIQUE INDEX name_owner_idnr_index (owner_idnr, name),
        ADD FOREIGN KEY owner_idnr_fk (owner_idnr)
                REFERENCES dbmail_users (user_idnr)
                ON DELETE CASCADE;

I have a test server setup and running dbmail_1.2.11 i have
1900 users and a 7gig innodb database.

You have all my help in making the innodb migrating script
work from start to finish.

Bien à vous

Jacques Beaudoin
Agent d'administration
Les services des technologies
de l'information et des communications
Commission scolaire de la Pointe de l'Île
Montréal, Québec, Canada