Importing Database erro

  • When importing db, i am getting this error. I have seen this posted but did not see the solution. PLEASE help.

    Script timeout passed, if you want to finish import, please resubmit same file and import will resume.

    Error

    SQL query:

    INSERT INTO wp_posts (ID, post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_content_filtered, post_parent, guid, menu_order, post_type, post_mime_type, comment_count) VALUES
    (616, 1, ‘2016-02-26 17:46:55’, ‘2016-02-27 00:46:55’, ‘[et_pb_section admin_label=”Section” fullwidth=”on” specialty=”off”][et_pb_fullwidth_slider admin_label=”Fullwidth Slider” show_arrows=”on” show_pagination=”on” auto=”on” auto_ignore_hover=”on” parallax=”off” parallax_method=”on” remove_inner_shadow=”on” background_position=”default” background_size=”default” hide_content_on_mobile=”off” hide_cta_on_mobile=”off” show_image_video_mobile=”off” he

    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 ”[et_pb_section admin_label=”Section” fullwidth=”on” specialty=”off”][et_pb_full’ at line 2

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    is your SQL file truncated? If you look at it in an editor, does it seem to end in the middle of something?

    If it’s a time-out, how large is the file? If huge, you may want to break it out into individual tables.

    Thread Starter gmortoza

    (@gmortoza)

    thanks for the reply. I will try the 2nd option and update this post.

    Thread Starter gmortoza

    (@gmortoza)

    INSERT INTO wp_posts (ID, post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_content_filtered, post_parent, guid, menu_order, post_type, post_mime_type, comment_count) VALUES
    (186, 1, ‘2015-12-12 17:58:21’, ‘2015-12-12 22:58:21’, ‘[et_pb_section fullwidth=”on”][et_pb_fullwidth_slider admin_label=”Fullwidth Slider” show_arrows=”on” show_pagination=”on” auto=”off” parallax=”on”][et_pb_slide heading=”Welcome To Our Website” button_text=”Learn More” button_link=”#” background_color=”#ffffff” alignment=”center” background_layout=”dark” video_bg_width=”1920″ video_bg_height=”638″ background_image=”https://elegantthemesimages.com/images/premade/d2-placeholder-1920.jpg”%5DVivamus ipsum velit, ullamcorper quis nibh non, molestie tempus sapien. Mauris ultrices, felis ut eleifend auctor, leo felis vehic[…]

    Can you please see what is wrong syntex wise on this query?

    When i imported the WP_posts, only Columns are created but not indexes.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Importing Database erro’ is closed to new replies.