Bei Fen - WordPress Backup Plugin
[resolved] Not able to import tables from backup (4 posts)

  1. roseba
    Posted 5 years ago #

    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?

  2. roseba
    Posted 5 years ago #

    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.)

  3. roseba
    Posted 5 years ago #

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

    I need some answers on how to fix this.


  4. roseba
    Posted 5 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Bei Fen - WordPress Backup Plugin
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic