List Info

Thread: 2.0->2.2 migrate sql error
2.0->2.2 migrate sql error
country flaguser name
Russian Federation		 2007-03-10 00:31:22 
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 ?

-- 
Anatoly Y. aka Snelius | AY254-RIPE
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: 2.0->2.2 migrate sql error
country flaguser name
Russian Federation		 2007-03-13 04:11:47 
Sat, Mar 10, 2007 at 12:31:22PM +0600, adminmail.tsu.ru ΞΑΠΙΣΑΜ:
> 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 ?

-- 
Anatoly Y. aka Snelius | AY254-RIPE
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: 2.0->2.2 migrate sql error
country flaguser name
Netherlands		 2007-03-13 05:40:39 
adminmail.tsu.ru wrote:
> Sat, Mar 10, 2007 at 12:31:22PM +0600, adminmail.tsu.ru ΞΑΠΙΣΑΜ:
>> 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.

-- 
 
____________________________________________________________
____
  Paul Stevens                                      paul at
nfg.nl
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: 2.0->2.2 migrate sql error
country flaguser name
Russian Federation		 2007-03-13 06:41:54 
Tue, Mar 13, 2007 at 11:40:39AM +0100, Paul J Stevens
ΞΑΠΙΣΑΜ:
> adminmail.tsu.ru wrote:
> > Sat, Mar 10, 2007 at 12:31:22PM +0600, adminmail.tsu.ru ΞΑΠΙΣΑΜ:
> >> 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
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
[1-4]

about | contact  Other archives ( Real Estate discussion Medical topics )