Title: SQL error importing databse
Last modified: August 30, 2016

---

# SQL error importing databse

 *  [fishrgreat](https://wordpress.org/support/users/fishrgreat/)
 * (@fishrgreat)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/sql-error-importing-databse/)
 * I am moving a site created locally onto private hosting to share with a client.
   I have exported the database from phpMyAdmin however when I try to import the
   database into the new site I get the following error. I can’t spot the error,
   but SQL is not my strong suit. Any help appreciated
 * SQL query:
 * INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`)
   VALUES
    (564, ‘howes’, ‘a:181:{s:8:”last_tab”;s:0:””;s:6:”layout”;s:7:”rounded”;
   s:18:”full_wide_elements”;a:3:{s:6:”header”;s:1:”1″;s:7:”content”;s:1:”1″;s:6:”
   footer”;s:1:”1″;}s:10:”responsive”;s:1:”1″;s:9:”skincolor”;s:7:”#722b5d”;s:10:”
   link-color”;a:2:{s:7:”regular”;s:0:””;s:5:”hover”;s:7:”#3980b2″;}s:17:”global_background”;
   a:7:{s:16:”background-color”;s:7:”#ffffff”;s:17:”background-repeat”;s:0:””;s:
   15:”background-size”;s:0:””;s:21:”background-attachment”;s:0:””;s:19:”background-
   position”;s:0:””;s:16:”background-image”;s:0:””;s:5:”media”;a:4:{s:2:”id”;s:0:””;
   s:6:”height”;s:0:””;s:5:”width”;s:0:””;s:9:”thumbnail”;s:0:””;}}s:16:”inner_background”;
   a:7:{s:16:”background-color”;s:7:”#ffffff”;s:17:”background-repeat”;s:0:””;s:
   15:”background-size”;s:0:””;s:21:”background-attachment”;s:0:””;s:19:”background-
   position”;s:0:””;s:16:”background-image”;s:0:””;s:5:”media”;a:4:{s:2:”id”;s:0:””;
   s:6:”height”;s:0:””;s:5:[…] 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 ‘?’ at line 2

The topic ‘SQL error importing databse’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [fishrgreat](https://wordpress.org/support/users/fishrgreat/)
 * Last activity: [10 years, 6 months ago](https://wordpress.org/support/topic/sql-error-importing-databse/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics