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.