Title: restoring database using backupwordpress plugin error
Last modified: August 30, 2016

---

# restoring database using backupwordpress plugin error

 *  Resolved [dynamiccomp](https://wordpress.org/support/users/dynamiccomp/)
 * (@dynamiccomp)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/restoring-database-using-backupwordpress-plugin-error/)
 * 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](https://wordpress.org/support/users/dimitris33/)
 * (@dimitris33)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/restoring-database-using-backupwordpress-plugin-error/#post-6283689)
 * you might need to drop all existing tables first and then import
 *  Thread Starter [dynamiccomp](https://wordpress.org/support/users/dynamiccomp/)
 * (@dynamiccomp)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/restoring-database-using-backupwordpress-plugin-error/#post-6283692)
 * 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](https://wordpress.org/support/users/dynamiccomp/)
 * (@dynamiccomp)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/restoring-database-using-backupwordpress-plugin-error/#post-6283710)
 * 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](https://wordpress.org/support/users/dimitris33/)
 * (@dimitris33)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/restoring-database-using-backupwordpress-plugin-error/#post-6283712)
 * sql files are for the database only not the WordPress files, so i am not sure
   what you are doing 🙂
 *  Thread Starter [dynamiccomp](https://wordpress.org/support/users/dynamiccomp/)
 * (@dynamiccomp)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/restoring-database-using-backupwordpress-plugin-error/#post-6283737)
 * 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](https://wordpress.org/support/users/dimitris33/)
 * (@dimitris33)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/restoring-database-using-backupwordpress-plugin-error/#post-6283766)
 * 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.

## Tags

 * [mysql-error](https://wordpress.org/support/topic-tag/mysql-error/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 6 replies
 * 2 participants
 * Last reply from: [dimitris33](https://wordpress.org/support/users/dimitris33/)
 * Last activity: [10 years, 11 months ago](https://wordpress.org/support/topic/restoring-database-using-backupwordpress-plugin-error/#post-6283766)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics