• fishrgreat

    (@fishrgreat)


    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.