How to Import a Large WordPress Database — An Alternative to phpMyAdmin
IMPORTANT MESSAGE: If you use the Bigdump script I illustrate below, after you are done importing your database, be sure to delete the Bigdump directory. If you leave it in place, then anyone who stumbles across it could destroy your database. So, once you are done, remove it from your server and then if you need to use it again in the future, just upload it when you need it…removing it when you are done with it.
——————————————–
How to Import a Large WordPress Database — An Alternative to phpMyAdmin — Part 1 of 2
How to Import a Large WordPress Database — An Alternative to phpMyAdmin — Part 2 of 2
Related posts:
- Outline & Tools Used in Louisville WordCamp Presentation Tweet Outline of my presentations at WordCamp Louisville: WP Basic...
- “Error Establishing a Database Connection” — How to Fix This WordPress Error Tweet “Error Establishing a Database Connection” — How to Fix...
- How to Mass Delete Unapproved WordPress Comments Tweet How to Mass Delete Unapproved Comments from Your WordPress...
good job, thank for this one
ich nutze http://www.mysqldumper.de für solche sachen. kann ich nur empfehlen.
Ok i managed to bring most of my blog back but i still get an error message while using big dump
Stopped at the line 5313.
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.
and when i go to the website i can’t log in with my username and password anymore
didnt watch the whole video haha you explain this nevermind ima keep watching
I finished watching it and it worked thanks man i was panicking
You did a great job on the video ..congrats…what if I want to import content not all the tables i.e. wordpress post that I want to add to my blog… I tried using the rss importer but it can only do a few hundred post at a time ..any suggestions ..thanks in advance
@alex: I’m not sure what you are asking…need to be a little more specific.
Thanks for the quick response…I want to import posts into my wordpress blog, I have the posts in files formated ala RSS. I can import the files now via the rss importer built into wordpress, but only about 300 at time before getting errors… I can email you a sample file. Perhaps you can suggest a different way to achieve this ..thanks again Alex
@alex: Can’t you just break that file up into groups of around 300 and do multiple imports?
Thanks again, I presently doing multiple imports but it takes time and I wanted something more automated. When I saw your video on importing the entire wordpress blog, I thought you perhaps you knew how to import large anounts of content into the blog..thanks Alex
That worked out nicely, thanks.
I have the same problem with the more than 300 dump lines, but my database is from a phpbb2 forum, and i can’t insert manually the “INSERT – VALUE” line, because it will take me years to do that, because i have more than 3,200,000 lines, and the error begins in the 700th line. Is there a way of doing that automatically? I have Edit Plus, but i’m using it for a first time.
@NoLable: Open the bigdump.php file and find the following variable:
define (‘MAX_QUERY_LINES’,300);
Change 300 to 900, save and give that a try.
Thank You! It worked, but now i have other error messages like:
Error at the line 200332: (‘something’, 3375, 0);
…
…
MySQL: Duplicate entry ‘???�????’ for key ‘PRIMARY’
@NoLabel: With a db that large you may run into all kinds of errors before getting it successfully imported. You may want to just open the sql file and delete that line.
i have problem :
Stopped at the line 1747.
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.
What should i do T.T
@Ringtone: Someone already posted about that and I’ve responded here…read the comments.
This is the first time I am perform this operation.I do no what to do.
Stopped at the line 881.
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.It is a 100mb database file.
Hello it was quit helpful but i have 2 question
Like you stop at the specific line and insert the line after 100..
Mostly this error comes or it will be different some times?
2nd.. i have very large database 1.5g will big dump support this?
Hello Figaro,
Thank you for this, great help! And also for your other instructions, I am really greatful that you are doing this.
I do have a question about importing my large database. I have a different error and I don’t know how to solve it. Maybe you can help me out?
I use the bigdump thing to upload my database but I receive the following error:
Error at the line 44: (1, ’2009-11-25 00:09:54′, ’2009-11-25 00:14:54′, ‘The Scheduler Calendar was installed!’, ”, 0, 0);
There is more text, but somehow I can’t sent the whole error message to my comment.
I don’t know exactly what this means and what I have to do to upload it without the error. I hope you can help me out, because I am not so happy that I can’t do this by myself. Thanks for your time.
Friendly greetings,
Archana
@Archana: Mod security on my server may be causing this…it just helps prevent the posting of things that could be harmful code. I can’t really help without seeing the entire error…maybe you could post the error to pastebin and link to it.
Ok, that could be it then. I have post the error to pastebin: http://pastebin.com/d3764d173
I don’t know what to do anymore, in fact, I can’t do a thing now with my website. I made backups from all the files and also made a backup from my database. The plan was to move my site from animal-crossing.nl/wp to animal-crossing.nl
@Archana: A couple of things to try. 1) just open the sql file in an editor and delete the line. This is a duplicate record in the table for the scheduler calendar you have installed. If you get another similiar error, then I would suggest just going to your original db and dump all tables except for the “events_rec” table and see if that works.
Hello Figaro, i deleted the line and then tried to upload it again. But still got errors. What do you mean with go to your original database? You mean my phpmyadmin?
@Archana: Yes, phpmyadmin…just dump the db again but without that table.
U r using wordpress right?
Then there is another way to get all ur post and other things.Just instead of downloading the database and solving these kind of errors u can Download the xml file from u wordpress admin menu and upload it and get all ur post.
I don’t know exactly what to do now. I can’t do a thing through my phpadmin except for dumping all my tables. If I want to import the database I get an error. If I upload the file through bigdump I get a few errors. I removed the line 44 but I still get errors.
At this point I can’t get to my orignial adminpanel since there aren’t any complete tables online. Is there another way to fix what I have done?
I hope I can upload it again because it took me months to (almost) finish my website…
Thank for your help.
@Archana: Can’t really help more than I have…you should be able to dump the db without that table.
I am having trouble with my posts linking to the same category (in every one of my categories) when you hit “read more” or try to add another comment from the site side. I want the comments in each category to stay on that category post (category page the main commment is listed on, not take the reader to another page (category). Can you help me?
To see what I am talking about my web site is http://www.heretowellness.com
Thank you.
My email address is Janice@austinrain.com
@Janice Welch: Categorie just provides a way to group (filter) your posts…when you click on a post or comment link in a post, then you are taken to that post. It sounds like you want your categories to be separate mini-blogs all showing on a homepage. I’m sure this could be done, but it would take some significant coding. I don’t have time for something that involved, but you may want to post to the WordPress Pro mailing list and see what kind of response you get–I don’t know of a plugin that will do this, so it will cost to have this coded by someone.
Finally I managed to import my wordpress database and my phpbb forum. I used the programm SQLyog. It works just like a ftp-programm and this way I could import my database again. I am so glad it worked! I thought I can never get my site back on. It’s in Dutch, but if you want to check it out: http://www.animal-crossing.nl
An another alternative is wordpress database backup plugin.
I’m not aware of any backup plugin that will import a database…not to mention a large database.
Very interesting and informative video. I wonder if there is any similar tool available to import large XML files back into the WordPress database?