wpvidZ

Learn WordPress With Video Tutorials

  • Blog
  • Browse
    • Backup & Restore
    • WordPress Localhost
    • WordPress Hosting
    • WordPress themes
    • Version Updates
    • Plugin Tips
    • Security
    • Tutorials
    • WordPress SEO
    • WP Miscellaneous
    • Sitemap
  • WP 5+ Tutorial
  • Search
wpvidZ Blog Backup & Restore At This Place The Current Query Includes More Than 300 Dump Lines

Backup Restore WordPress Step By Step

At This Place The Current Query Includes More Than 300 Dump Lines

Last updated on February 18, 2017
Posted on October 21, 2010

“Stopped at the line 919.
At this place the current query includes more than 300 dump lines. That can happen if your dump file was created by some tool which doesn’t place a semicolon followed by a linebreak at the end of each query, or if your dump contains extended inserts. Please read the BigDump FAQs for more infos.”

You will possibly get  if we try to import large database with BigDump.


It is basically because your SQl file backup is taking too long queries for BigDump.

Eventhough i have copied my wordpress blog to my PC using BigDump using this method, see this copy online blog to pc post, i never encounter this problem.

If you have this problem, it is usually because the line is too long, so we need to start another statement with the line: insert into ‘wp_table’ (‘object id’, ‘example_field’) Values

The line will be similar to example line above.

The message will look like.

Steps:

1. Open the backup sql file, with a notepad or any HTML editor, and find that line which is almost similar above, which starts with ‘INSERT INTO’

2. Highlight that line until the “VALUES” text to copy.

3. Count the followed 300 lines, then you can put a ; (semicolon) to the end of the line, and paste the line with “INSERT INTO bla-bla VALUES” in step 1.

Repeat it again if it needs to, and then you can try to import again.

backup current database restore this

Latest Posts

  • Twenty Nineteen Theme Full Tutorial – Creating a Website
  • Uninstall W3 Total Cache Plugin – Incredibly Easy!
  • Create WordPress Website 2018 on SiteGround Genesis
  • WordPress Noopener Noreferrer Rel Attribute Quick Fix
  • WordPress CDN Setup with MaxCDN and W3 Total Cache Plugin
  • Twenty Seventeen One Page Parallax Scrolling Website Style
  • How To Add Google Map in WordPress Contact Page
  • WordPress 4.7 Justify Text and Underline
  • Twenty Seventeen Footer “Proudly Powered By WordPress” Text
  • How To Add YouTube Subscribe Button To WordPress Website
→ BigDump Alternative – When BigDump Failed Importing Large WP Database

Comments

  1. Rahul @ MazaKaro says

    October 21, 2010 at 10:43 pm

    Very nice tutorial I’ve met this problem before . it’s so annoying
    but i have a question
    you think how many times i have to repeat the step
    “Count the followed 300 lines, then you can put a ; (semicolon) to the end of the line, and paste the line with “INSERT INTO bla-bla VALUES” in step 1.”

    thank you

    • Kimi says

      October 22, 2010 at 1:51 pm

      Hey Rahul,

      You have to repeat until the line is not taking queries too long.

    • L. Nicklaus says

      March 9, 2011 at 1:53 pm

      Thank you so much for this tutorial! You are my hero for today!

  2. Oscar says

    October 22, 2010 at 7:30 am

    Hello
    I have a quick question, do you know of a good Pluggin that can submit you articles for you to different article directories like ezine and alott others? Do you know or have heard of a popular one, or which one do you use. Please help.

    • Kimi says

      October 22, 2010 at 1:54 pm

      Hey Oscar,

      I have never heard about that kind of plugin, but there are lots of paid softwares for that.

      Those stuff is not effective, because when you submit your articles, those articles should not be the exact same to each other, otherwise, it will be ignored by search engines.

      I usually submit manually.

  3. Oscar says

    October 22, 2010 at 4:34 pm

    Which ones do you submit to? or could you give me a link to a good article that lists the best ones.!

    I would hate to post to spam article directories.

    • Kimi says

      October 22, 2010 at 10:51 pm

      Hey Oscar,

      I recommend ezine articles, you can find more by doing google researches.

      So far, i wrote only to ezine

  4. Kintaro says

    December 19, 2011 at 11:02 pm

    solved importing it with phpmyadmin (was a 20MB file)

Comment form on this post is closed after 60 days.

Search

Worth Reading

  • Backup WordPress Without a Plugin or FTP
  • Export WordPress Database using phpMyAdmin
  • BigDump Alternative - When BigDump Failed Importing Large WP Database

Backup & Restore

Backup WordPress Without a Plugin or FTP

Export WordPress Database using phpMyAdmin

BigDump Alternative – When BigDump Failed Importing Large WP Database

At This Place The Current Query Includes More Than 300 Dump Lines

View All..

Live Online Website

View All..

Offline Installation

How to Upload WordPress localhost to live server manually

Steps to Install WordPress on Windows 8 and WAMP 2.4

Install WordPress on Mavericks OS X 2014

Maximum upload file size in WAMP WordPress

View All..


WPvidz Hosting Image

  • About Me
  • Contact
  • Affiliate Disclosure
  • Privacy Policy
  • Term of Use

Copyright© 2023 wpvidz.com SG2021 | sitemap.xml


WPvidz.com is independent from WordPress.org but is proudly powered by WordPress & its block-based editor (Gutenberg)

WpvidZ.com uses cookies" to give you the best browsing experience possible. If you click "I Accept" below then you are consenting to this. For more information about your privacy settings on this website, please visit the Privacy Policy page. I Accept