Moved to WordPress 2.0 from Drupal 4.6

Drupal is a nice system if you need an advanced CMS-like environment. Which I didn’t.

Hence I moved to WordPress, since I need a well-maintained piece of weblog software. The only downside at the moment is that it is written in PHP.

Conversion was not too hard. I followed directions as posted on http://spindrop.us/2006/05/19/migrating-from-drupal-47-to-wordpress and only had to change some things.

I want to keep the category ‘Uncategorized’ in order to have a sane default. So you can perhaps just leave out the ‘delete from wp_categories;’ step. Furthermore I had to use this SQL statement in order to move the posts over, since I was running Drupal 4.6:
[sql]INSERT INTO wp_posts (id, post_date, post_content, post_title, post_excerpt, post_name, post_modified)
SELECT DISTINCT n.nid FROM_UNIXTIME(created), body, n.title, teaser, REPLACE(REPLACE(REPLACE(REPLACE(LOWER(n.title), ‘ ‘, ‘-‘), ‘.’, ‘_’), ‘,’, ‘_’), ‘+’, ‘_’), FROM_UNIXTIME(changed)
FROM drupal.node n
WHERE type=’blog’ OR type=’page’;
[/sql]

Leave a Reply

Your email address will not be published. Required fields are marked *