#1064 Error importing mysql DB to localhost
-
Hi,
I’m a total noob, and trying to import my sites sql database to edit locally but receiving an error #1064. I’m using the Woocommerce plugin(not sure if it matters).Error
SQL query:INSERT INTO
wp_usermeta(umeta_id,user_id,meta_key,meta_value) VALUES (1,1,’first_name’,’name’),(2,1,’last_name’,’name’),(3,1,’nickname’,’admin’),(4,1,’description’,”),(5,1,’rich_editing’,’true’),(6,1,’comment_shortcuts’,’false’),(7,1,’admin_color’,’fresh’),(8,1,’use_ssl’,’0′),(9,1,’show_admin_bar_front’,’true’),(10,1,’wp_capabilities’,’a:1:{s:13:\”administrator\”;s:1:\”1\”;}’),(11,1,’wp_user_level’,’10’),(12,1,’dismissed_wp_pointers’,’wp330_toolbar,wp330_media_uploader,wp330_saving_widgets’),(13,1,’show_welcome_panel’,’1′),(14,1,’wp_dashboard_quick_press_last_post_id’,’1321′),(15,1,’nav_menu_recently_edited’,’26’),(16,1,’managenav-menuscolumnshidden’,’a:4:{i:0;s:11:\”link-target\”;i:1;s:11:\”css-classes\”;i:2;s:3:\”xfn\”;i:3;s:11:\”description\”;}’),(17,1,’metaboxhidden_nav-menus’,’a:6:{i:0;s:8:\”add-post\”;i:1;s:11:\”add-product\”;i:2;s:13:\”add-promotion\”;i:3;s:11:\”add-infobox\”;i:4;s:12:\”add-post_tag\”;i:5;s:15:\”add-product_tag\”;}’),(18,1,’wp_user-settings’,'[…]MySQL said:
#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 ”a:1:{s:4:\”cart\”;a:1:{s:32:\”298f95e1bf9136124592c8d4825a06fc\”;a:8:{s:10:\”pr’ at line 1
Please help.
The topic ‘#1064 Error importing mysql DB to localhost’ is closed to new replies.