Title: Problem uploading backup .sql ?
Last modified: August 21, 2016

---

# Problem uploading backup .sql ?

 *  [Thermoses](https://wordpress.org/support/users/thermoses/)
 * (@thermoses)
 * [12 years, 11 months ago](https://wordpress.org/support/topic/problem-uploading-backup-sql/)
 * I am getting this error and am stumped. I tried emptying my tables before import
   but still can not get it to work. Any ideas? Should I delete all tables then 
   upload?
 * ERROR
 * SQL query:
 * CREATE TABLE `wp_commentmeta` (
 *  `meta_id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
    `comment_id` BIGINT(
   20 ) UNSIGNED NOT NULL DEFAULT ‘0’, `meta_key` VARCHAR( 255 ) DEFAULT NULL , `
   meta_value` LONGTEXT, PRIMARY KEY ( `meta_id` ) , KEY `comment_id` ( `comment_id`),
   KEY `meta_key` ( `meta_key` ) ) ENGINE = MYISAM AUTO_INCREMENT =211 DEFAULT CHARSET
   = utf8;
 * MySQL said:
 * #1050 – Table ‘wp_commentmeta’ already exists

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [essaysnark](https://wordpress.org/support/users/essaysnark/)
 * (@essaysnark)
 * [12 years, 11 months ago](https://wordpress.org/support/topic/problem-uploading-backup-sql/#post-3805496)
 * I am no DB expert but whenever I’ve tried restoring from a backup, I’ve always
   dropped all the tables and then done the import. I think it might depend on how
   the SQL import file was constructed though doesn’t it? I get scared with this
   stuff… 🙂 but FWIW the process I did previously was drop all tables and then 
   import the file.
 * My host has an excellent tutorial on this stuff: [http://support.wpengine.com/importing-your-database/](http://support.wpengine.com/importing-your-database/)
 *  Thread Starter [Thermoses](https://wordpress.org/support/users/thermoses/)
 * (@thermoses)
 * [12 years, 11 months ago](https://wordpress.org/support/topic/problem-uploading-backup-sql/#post-3805639)
 * THx…worked great!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Problem uploading backup .sql ?’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [Thermoses](https://wordpress.org/support/users/thermoses/)
 * Last activity: [12 years, 11 months ago](https://wordpress.org/support/topic/problem-uploading-backup-sql/#post-3805639)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics