mysql restore

  • I have had to reinstall my site.
    I made a complete backup of files and SQL database.
    I removed completely the WP install from my host.
    I reinstalled WP.
    I am now trying to restore the tables into the new SQL database.

    Error: #1062 Duplicate entry 104 for key 1

    Any advise?

    thanks

Viewing 2 replies - 1 through 2 (of 2 total)

  • try uploading the database sql file not table through backend of server not yourself manually copying into new sql .
    Upload the old sql as it is

    Thread Starter pxpworld

    (@pxpworld)

    Thanks for your reply.
    Your suggestion prompted me to think that I should be importing the tables into an empty database. So I dropped all the tables in the new database and then imported the old and it work OK!

    BUT sadly it did not solve my core problem.
    The reason why I had to do a complete new WP install was the following:

    I was using V3.2.1 and everything has been OK for months. Then suddenly
    I can not upload images due to HTTP error, and also can not edit or preview a new page change, due to the following error:

    Internal Server Error

    The server encountered an internal error or misconfiguration and was unable to complete your request.

    Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

    I have tried every suggestion on the forums with no joy, hence my last attempt was to delete all and restart!

    BUT as this did not solve the problem, I am now wondering if it is existing because of something in my content folder or maybe in the structure of the old database??

    ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘mysql restore’ is closed to new replies.