WordPress.org

Support

Support » How-To and Troubleshooting » [Resolved] Database import error to restore wp database

[Resolved] Database import error to restore wp database

  • elbriedekock
    Member

    @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
    Forum Moderator

    @esmi

    What kinds of errors are you seeing?

    elbriedekock
    Member

    @elbriedekock

    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
    Forum Moderator

    @esmi

    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.

    elbriedekock
    Member

    @elbriedekock

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

    esmi
    Forum Moderator

    @esmi

    did you mean blc_instances?

    Sorry – yes.

    elbriedekock
    Member

    @elbriedekock

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

    esmi
    Forum Moderator

    @esmi

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

    elbriedekock
    Member

    @elbriedekock

    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
    Forum Moderator

    @esmi

    No problem. Glad I could help. 🙂

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