Title: SQL Error 1064 for wp_options
Last modified: September 1, 2016

---

# SQL Error 1064 for wp_options

 *  [fabiantjoeaon22](https://wordpress.org/support/users/fabiantjoeaon22/)
 * (@fabiantjoeaon22)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/sql-error-1064-for-wp_options/)
 * Can someone please help me out? This problem is keeping me from deployment..
 * I have a Woocommerce Database that I exported to a generated SQL using PhpMyAdmin.
 * Whenever I try to export it to a new database on another server I get this error:
 *     ```
       #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 'INSERT INTO <code>gt_options</code>
       (<code>option_id</code>, <code>option_name</code>, <code>option_value</code>, <code>autoload</code>' at line 32
       ```
   
 * However importing in my localhost works like a charm.. I tried several settings,
   even compatibility mode, but nothing seems to help.
 * DB that needs to exported: **name:** chu_on_com_gatewp **on sql version: **5.5.49-
   log
 * DB that needs to be imported (already exists): **name:** rachimn30_gatewp **on
   sql version:**
    5.5.34
 * I’m pretty sure it has something to do with the server.. I hope someone if familiar
   with this problem
 * TIA

Viewing 1 replies (of 1 total)

 *  [abletec](https://wordpress.org/support/users/abletec/)
 * (@abletec)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/sql-error-1064-for-wp_options/#post-7463040)
 * Hi, fabiantjoeaon22, & welcome to the WordPress support forum. Have you tried
   importing the database file into a *blank* database? You may have to do some 
   search-&-replace on it in order to replace old url’s w/new ones, but I think 
   that really might be the way to go in a case like this. Unfortunately, I’m not
   exactly clear on the steps you took. If you did indeed import this to a blank
   database, could you please detail the steps you took precisely so we have a better
   idea of what occurred?

Viewing 1 replies (of 1 total)

The topic ‘SQL Error 1064 for wp_options’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [abletec](https://wordpress.org/support/users/abletec/)
 * Last activity: [9 years, 11 months ago](https://wordpress.org/support/topic/sql-error-1064-for-wp_options/#post-7463040)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics