I am importing a huge database manually and i have a problem. The error it very vague to me, as i am not much familiar with mysql. The error says the following

enter image description here

Its such data that i am unable to comprehend, where to find the error. It cannot be option_id, as its auto_increment. What is the problem? When it says Duplicate entry 1 for key primary?

  • Your database is already populated and you are trying to insert duplicates of "keys" that have to be unique. Please explain the situation in more detail. I am sure there is information missing.
    – s_ha_dum
    Nov 8 '13 at 15:43
  • @s_ha_dum yes i see the data in that table :) , i have imported database manually,the reason i am importing it manually is because i had error when using phpmyadmin-import tab with error now trying to make the website work, the wp_config has right credentials but when i load the website url, its a blank page.
    – localhost
    Nov 8 '13 at 15:55
  • Your import is bad. Start over from an empty database.
    – s_ha_dum
    Nov 8 '13 at 15:59
  • @s_ha_dum but the error i mentioned. that is what i get,when i import a full db using phpmyadmin import tab. how can i get rid of this error
    – localhost
    Nov 8 '13 at 16:13
  • That is a different error than the one in the question and it looks like you have a quote mismatch-- bad export perhaps, corrupt file, encoding mismatch... Hard to say, but probably not WordPress specific.
    – s_ha_dum
    Nov 8 '13 at 16:19

I was able to solve my own problem, while its was a very struggling effort.If your database is corrupt, but you want to restore your site. Just open your database in a any program like TextEdit, Notepad++ and make sure you copy the basic databases mention here in a new database, that will at least make your website up and running back as it was :)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.