Support » Fixing WordPress » Database import error to restore wp database

  • Resolved elbriedekock

    (@elbriedekock)


    hi,

    I need some assistance with restoring my database. I made a manual backup, and uploaded the backup in phpMyAdmin using “import” button, however got a string of errors and need some help to sort out.

    many thanks.

Viewing 9 replies - 1 through 9 (of 9 total)
  • esmi

    (@esmi)

    Forum Moderator

    What kinds of errors are you seeing?

    I took a screenshot, http://dl.dropbox.com/u/64629755/wp-database-import-error.png

    I made a mistake earlier today to delete a user which had loads of content attached to it and didn’t ask to be transferred to another user. I made a manual backup a month ago, which I am happy to restore to, but it doesn’t seem to work.

    I am not technical at all, so struggle to even understand where to look for the errors.

    You’re assistance would be appreciated.

    esmi

    (@esmi)

    Forum Moderator

    Looks like you have an issue with a table for a plugin (bl_instances?). You’d need to empty that table before you restore a backup copy.

    how do I empty the table? can’t find bl_instances did you mean blc_instances? I have NO CLUE!!

    esmi

    (@esmi)

    Forum Moderator

    did you mean blc_instances?

    Sorry – yes.

    OK, so do I just empty the blc_instances table and then try and ‘import’ the backed-up database again?

    esmi

    (@esmi)

    Forum Moderator

    Yes. That should fix that particular error but I’d advise making a backup of your current database before you try anything.

    I had to empty all the tables and then import the database, but it seemed to have done the trick. Thank you very much for your help.

    esmi

    (@esmi)

    Forum Moderator

    No problem. Glad I could help. 🙂

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Database import error to restore wp database’ is closed to new replies.