Title: import database error
Last modified: August 20, 2016

---

# import database error

 *  [murphywordpress](https://wordpress.org/support/users/murphywordpress/)
 * (@murphywordpress)
 * [14 years, 2 months ago](https://wordpress.org/support/topic/import-database-error/)
 * Hi Friends
 * I got a challenge.
 * I want to import my DB to live DB, on selecting the DB and clicking import , 
   then I browse to my saved DB, I clicked GO.
 * Unfortunately, I got the errors pasted below.
 * Error
    SQL query:
 * —
    — Database: `wordpress` — — ——————————————————– — — Table structure for table`
   wp_options` — CREATE TABLE `wp_options` (
 *  `option_id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
    `blog_id` INT( 
   11 ) NOT NULL DEFAULT ‘0’, `option_name` VARCHAR( 64 ) NOT NULL DEFAULT ”, `option_value`
   LONGTEXT NOT NULL , `autoload` VARCHAR( 20 ) NOT NULL DEFAULT ‘yes’, PRIMARY 
   KEY ( `option_id` ) , UNIQUE KEY `option_name` ( `option_name` ) ) ENGINE = INNODB
   DEFAULT CHARSET = utf8 AUTO_INCREMENT =1028;
 * MySQL said:
 * #1050 – Table ‘wp_options’ already exists
 * Please I need help on what to do.
 * Thanks in advance.

The topic ‘import database error’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [murphywordpress](https://wordpress.org/support/users/murphywordpress/)
 * Last activity: [14 years, 2 months ago](https://wordpress.org/support/topic/import-database-error/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics