45,000 Wordpress posts converted to Drupal

Submitted by Steve on Tue, 29 Jul, 2008 - 23:47

Okay, the title said 45,000 posts but in reality how does converting or transferring, call it what you want, 45,936 posts from Wordpress 2.5 to Drupal 5.8 sound. I helped out a registered user HitBoy with the conversion, that is, I did it on my machine locally for him. Before I go any further here's a screen-shot of the Analyse Wordpress section.

Screen shot - Analyse Wordpress

I didn't specifically time the process but I reckon it was closer to the two hour mark than it was to the one hour mark, so transferring 45,000 posts is not a 5 minute process. Obviously, if done using remote databases it would take a little longer. How much longer, well I don't know and I'd only be guessing.

HitBoy's going to make a follow-up entry in Check My Site thread and there he'll promote his site, so at least you can see that it is possible to convert massive amounts of data.

During this process I was chatting to HitBoy about other things, as you do, and found out that he's starting a new venture, a hosting business. If you're after some free (or paid) web-hosting why not check him out at OpenSourceSetup. His site went live yesterday (Monday 29 July, 2008).

The link I provided IS NOT an affiliate link and I do not benefit in any way.

Sat, 9 Aug, 2008 - 06:24
#1
intoxination
Joined: 17 May 2008
User offline. Last seen 7 weeks 1 day ago.
Great App!

I am getting ready to convert a WP 2.3 blog over to Drupal 6. It has 30,000+ comments and over 800,000 comments. I have been testing your converter to make sure it works out fine and haven't had a problem at all!. I am converting the DB over to Wp2.5 before doing the conversion. I also have a lot of changes going in for custom WP plugins before the conversion, including changing the more slug to a break slug.

Keep up the awesome work - you're a lifesaver!

(Update - I am doing the conversion on a dual core Ubuntu and running the actual program on my quad core Vista machine. The part of the conversion running your script takes about 30 minutes).

Sat, 9 Aug, 2008 - 19:27
#2
Steve
Joined: 27 Mar 2008
User is online
Appreciated

Thanks for your supportive comments. You'll have to let me (all) know how it goes and link to your site(s). 30 mins for 800,000 comments, that's quick, very quick.

In relation to the <!--more--> tag, that is converted automatically to the <!--break--> tag, as of version 1.03. I made mention of it here. I'll have to put that particular post into the manual under Versions. My intent was to have a running list of the various improvements.

Steve
My running website

Sat, 9 Aug, 2008 - 23:54
#3
intoxination
Joined: 17 May 2008
User offline. Last seen 7 weeks 1 day ago.
Awesome

When I first started this project a few months ago, I was using 1.02, and just upgraded to 1.04 yesterday and didn't know about the more change. That's sweet. Before I ran a script after the import that loaded the node, ran node->teaser through the node_teaser function then resaved it. This will take out that whole step.

We are hoping to do the move in the next week. Being a political blog and with the conventions coming up, things are hectic right now. We were planning on doing it tonight, but had a database server crash, so we are waiting to make sure the fixes hold before switching.

free hit counter