Convert a Drupal Site to Wordpress

One of my sites used to be Drupal 5.x. I recently decided that it was time to convert the site to Wordpress 2.5.x. The reason being that I was really using the site more like a blog than anything else, and although Drupal is a great piece of CMS, it is really not that great out of the box as a blog. Wordpress on the other hand….well it is awesome. There are not that many world class bloggers out there that use anything but, and there is a reason for that.

IT WORKS

So I asked the question over at DP and got a couple of good links. However it wasn’t going to be easy since I couldn’t find anyone that converted to the most current Wordpress. This caused me some grief, until I decided to simply use an old version for the conversion and upgrade from there. So I went right to the version that this guy used, 2.2.2

The thing that a lot of people may have an issue with is the fact that there is no easy way to move over the users that you may have registered. Since I didn’t force users to register to comment or do pretty much anything else this turned out not to be an issue. The only people that registered were there to post spam. I guess they thought that if they registered they would bypass the moderation.

The list/order of things that I did. I am assuming that you have a host with cPanel and myphpadmin

1. Complete backup of old site.
2. Another backup, this time the root directories and the db seperately.
3. Install Wordpress 2.2.2
4. Open phpmyadmin, copy over term_data, term_hierarchy, node, node_revisons, term_node, and comments from the Drupal DB to the Wordpress DB. Alternatively you could have installed Wordpress into the same DB as the Drupal install.
5. Run the SQL from the txt file as found on Alex’s Blog on the Wordpress DB from myphpadmin
6. Delete the node_revisions table (It isn’t done in the above SQL)
7. Download and upgrade to the latest Wordpress Build. (you don’t want to get caught with your pants down)
8. Login in to Wordpress and start cleaning.

So that’s it. The one thing that I am going to have to figure out is an easy way to 301 the old URLs to the new. For now I simply logged into my Google Analytics account and manually 301′d the most popular URLs.

If you are having any problems following the step