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, and delete it
again before running the migration script.
Jacques Beaudoin wrote:
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
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
________________________________________________________________
Paul Stevens [EMAIL PROTECTED]
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands_______________________________________www.nfg.nl
