Announcement

Collapse
No announcement yet.

Moving Servers: ERROR 1062 when restoring database

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Moving Servers: ERROR 1062 when restoring database

    My new host (1and1) requires that you use this import procedure for a MySQL dump:

    myShell:~ > mysql -h dbxx.perfora.net -u dboxxxxxxxx -p dbxxxxxxxx < dump_file.sql
    Enter password:
    mysql>


    After following everything properly, the process starts, as my Putty pauses while the server is doing its magic. After about 20 seconds, it then gives me the error:

    ERROR 1062 at line 2403: Duplicate entry 'svard' for key 2

    Does anyone have any idea what may be causing this, and what I should do to rectify it?

    Sincerely,

    James

  • #2
    This is a bad backup. How was it made.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Steve,

      It was made via SSH (Putty). I'm going to retry, but first, do I need to delete my database first and then start over? Or is this not necessary?

      Sincerely,

      James

      Comment


      • #4
        Fixed! Thanks!

        James

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X