Tue, Mar 13, 2007 at 11:40:39AM +0100, Paul J Stevens написал: > [EMAIL PROTECTED] wrote: > > Sat, Mar 10, 2007 at 12:31:22PM +0600, [EMAIL PROTECTED] написал: > >> hello > >> > >> ~$ mysql -u root dbmail < migrate_from_2.0_to_2.2.mysql > >> ERROR 1062 (23000) at line 22: Duplicate entry '3-Sent' for key 2 > >> > >> any ideas ? > > > > please help. i try it again with other db mysql, but still with this error. > > what can i do ? > > > Try running > > mysql -u root -v -v -v -T dbmail < ... > > so we can see what's going on.
mysql -u root -v -v -v -T dbmail < migrate_from_2.0_to_2.2.mysql -------------- ALTER TABLE dbmail_physmessage ENGINE=InnoDB -------------- Query OK, 21428 rows affected (0,59 sec) Records: 21428 Duplicates: 0 Warnings: 0 -------------- ALTER TABLE dbmail_messageblks MODIFY messageblk LONGBLOB NOT NULL -------------- Query OK, 45027 rows affected (7 min 50,49 sec) Records: 45027 Duplicates: 0 Warnings: 0 -------------- ALTER TABLE dbmail_mailboxes MODIFY name VARCHAR(100) NOT NULL default '' -------------- ERROR 1062 (23000) at line 22: Duplicate entry '3-Sent' for key 2 Bye -- Anatoly Y. aka Snelius | AY254-RIPE _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
