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

2004-10-19 Thread 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 dbmai

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

2004-10-20 Thread Paul J Stevens
Jacques, I'm guessing this is not a bug in the script perse, but rather in your database. The duplicate entry error means that mysql is unable to 'ADD UNIQUE INDEX name_owner ...' There must be an owner_idnr with two INBOXes. Before trying to migratie you could try to add this key manually, a