mySQL Restore (error 1062) problem

by admin on January 5th, 2009 |

  • I'm having some difficulties in restoring a database that I've tried backing up using phpMyBackupPro, vBulletin, the mySQL CLI, and phpMyAdmin.

    I've tried repairing and optimizing before making the backup, and always get an error on restore:


    ERROR 1062 (23000) at line 377726: Duplicate Entry 'sertXXrner' for key 2

    where the XX in the middle of 'sertXXner' represents some sort of ASCII character.

    I'm restoring a v4.0.23 database to a v4.1.11 server.

    Any ideas?


  • Well, I used:

    # mysqldump -u root -p [database] > [filename.sql]

    This was the least of my problems, I was upgrading to v4.1.11 and had MANY other problems (all of which are resolved now) but had this one solved by emptying my search indexes before backup and then recreating them on restore.


  • how did you backup your 4.0.xx forum database ?

    http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html


    Incompatible change: There are conditions under which you should rebuild tables. In general, to rebuild a table, dump it with mysqldump and reload the dump file. Some items in the following list indicate alternatives means for rebuilding.


  • investigating this a bit more, I've found that the problem is in my word table, at line 10961 INSERT INTO opio_word VALUES (10961,'sertürner'); what are these? passwords? if so, how do i tell who this belongs to so I can have it changed?

    any ideas on what i should do?


  • A note I'll include to say I found the answer in another thread here. Had to empty the indexes I did.

    Same duplicate key problem, same solution.







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about mySQL Restore (error 1062) problem , Please add it free.

    editTags: xn--4cr.com