restoring database using backupwordpress plugin error

  • Resolved dynamiccomp

    (@dynamiccomp)


    8 years, 10 months ago

    I was trying to import the sql file from the backup zip folder after I extracted it and I am receiving this error in my phpmyadmin panel

    Error

    SQL query:

    /*!40000 ALTER TABLE wp_bwfi_fileaway_metadata DISABLE KEYS */;

    MySQL said: Documentation
    #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 ‘UNLOCK TABLES;

    —
    — Table structure for table wp_bwfi_links
    —

    DROP TABLE I’ at line 2

    does anyone know how I can fix the code so i can import the file to get my site back up asap?

Viewing 6 replies - 1 through 6 (of 6 total)
  • dimitris33

    (@dimitris33)

    8 years, 10 months ago

    you might need to drop all existing tables first and then import

    Thread Starter dynamiccomp

    (@dynamiccomp)

    8 years, 10 months ago

    dim I tried that first. I also tried using a backup from my hosting service of the database. I can access the data from the last 3 days. every single one after I restore gives me that 500 error.

    I looked at the “error log” file in the root directory and it said this

    “test/team/ssv3_payload_extractor-348MGcX3Li.php startup” any idea what that means?

    Thread Starter dynamiccomp

    (@dynamiccomp)

    8 years, 10 months ago

    Looks like some of the wp-content files got corrupted because now it is showing me part of the site since there are 1400 files left to upload.

    dimitris33

    (@dimitris33)

    8 years, 10 months ago

    sql files are for the database only not the WordPress files, so i am not sure what you are doing 🙂

    Thread Starter dynamiccomp

    (@dynamiccomp)

    8 years, 10 months ago

    Yes I know they are. I was trying to follow the restore process, and when I was getting to the restore DB part, I was getting that error from the SQL file that was contained within the zipped backup folder.

    dimitris33

    (@dimitris33)

    8 years, 10 months ago

    the best place to get answers is the forum for the plugin you use to do your restore.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘restoring database using backupwordpress plugin error’ is closed to new replies.