Jorge Bastos wrote: > > > Hi Paul, > > > > I’m handling things to upgrade to the latest GIT on the production (I’ve > been testing on other machine), but, when I add the UNIQUE INDEX that is > on the sql upgrade file, I get this: > > > > mysql> CREATE UNIQUE INDEX dbmail_envelope_1 ON > dbmail_envelope(physmessage_id); > > ERROR 1062 (23000): Duplicate entry '294904' for key 3 > > mysql> > > > > How can I pass this without damaging my db?
Adding or removing indexes will never damage your db. It will only affect performance. Apparently you already have a unique index on dbmail_envelope.physmessage_id. So comment out or remove the statement involved. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ Dbmail-dev mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
