• Registered: 2005-11-28
  • Posts: 2

Topic: error 1062

I'm trying to move an existing, working PunBB forum database to a new host.  I have a mysql dump of the database for the forums, and when I try to load the dumped database into the new database on the new host (on the command line), I get the following error:

ERROR 1062 (23000) at line 408503: Duplicate entry '?¢?Ǩ?Äù?¢?Ǩ?Äù?¢?Ç' for key 1

I have no idea how to proceed from here.  Any suggestions?

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: error 1062

Hmm. Try emptying the search index before dumping the database from the old host. To do that, empty the tables search_matches and search_words. The following queries should do the trick:

TRUNCATE TABLE search_matches;
TRUNCATE TABLE search_words;

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Registered: 2005-11-28
  • Posts: 2

Re: error 1062

thanks Rickard, that did it!

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: error 1062

Don't forget to rebuild the search index once you've imported it. Admin->Maintenance.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website