SQL Error 1064 for wp_options

  • fabiantjoeaon22

    (@fabiantjoeaon22)


    9 years, 11 months ago

    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

    (@abletec)

    9 years, 11 months ago

    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.