“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.
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.
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
Hey Rahul,
You have to repeat until the line is not taking queries too long.
Thank you so much for this tutorial! You are my hero for today!
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.
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.
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.
Hey Oscar,
I recommend ezine articles, you can find more by doing google researches.
So far, i wrote only to ezine
solved importing it with phpmyadmin (was a 20MB file)