WordPress.org

Support

Support » Plugins and Hacks » [Resolved] Not able to import tables from backup

[Resolved] Not able to import tables from backup

  • I accidently dropped ALL of my tables on WordPress. When I try to reimport them, I get error messages.

    This is my ONLY backup and if I can’t use it, I lose my entire blog.

    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘CREATE TABLE wptbl_users (
    ID bigint(20) unsigned NOT NULL auto_increment,’ at line 1

    I get error messages for this and all other tables I try to bring in. I try to use UFT8.

    What is the issue?

Viewing 3 replies - 1 through 3 (of 3 total)
  • My host says the syntax needs to be updated to the right version of SQL. They are using version 5.0.45.

    I’m not sure HOW to fix this since the backup is already created and the entire WP installation is gone. (Meaning I can’t do another backup of it.)

    Sorry, that was the server version. The phpMyAdmin SQL Dump they did is from version 2.8.0.1.

    I need some answers on how to fix this.

    Thanks.

    For now, I have my database back. My host restored it. I think the problem may have been the fact that the original tables were created in Latin1, while the new tables were in UTF8. (Character Encoding).

    I don’t know for sure if this is the problem. But I thought I would leave that nugget here in the event that someone else has this problem.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[Resolved] Not able to import tables from backup’ is closed to new replies.