Hi Paul,

 

I'm doing some tests with real data but with a copied machine, and applying
an index from the sql changes I have:

 

CREATE UNIQUE INDEX dbmail_envelope_1 ON dbmail_envelope(physmessage_id);

ERROR 1062 (23000): Duplicate entry '2424860' for key 3

 

I saw and I have about 4000 records with this problem.

 

Question is, can i:

 

Truncate dbmail_envelope;

 

Apply the new unique index and then:

 

dbmail-utils -yb ?

_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Reply via email to