• 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.