Migrate your Typo blog to Wordpress

January 11, 2007 Link to post  Permalink

There are some scripts available, but I never found a step-by-step set of instructions for how to migrate my Typo 4.0 blog to Wordpress 2.0. This post documents what I did to transfer my blog from one platform to the other.

Install Wordpress

I am now running my Wordpress blog on Dreamhost. I used my own instructions on how to set this up with Capistrano

I took this opportunity to switch themes too!

Add the Ultimate Tag Warrior plugin

To get tag functionality in Wordpress, I added the Ultimate Tag Warrior plugin I still need to add code to show the tags in posts, but the underlying data is there.

Save the Typo database

On my Typo server dumped the MySQL database using mysqldump.

Import the Typo database into Wordpress database

On my Dreamhost account, this is as simple as running mysql -u [user] -p < typo-dump-file

Run the migration script

Stuart Johnson has a Typo to Wordpress migration script that almost worked for me. I had a problem with the post content not showing up. I simplified the SQL for this step, as I didn’t have the pre-generated HTML or the extended pieces. I just copied the existing content field directly over to Wordpress.

This script sets up the permalinks for the posts in the database.

In Admin, save the permalink configuration

To activate the permalink structure, you need to go to the Wordpress options > permalinks and just click Save. This updates the .htaccess file with the redirects.

Approve all the comments

All the comments seem to come into Wordpress needing moderation. In lieu of changing the migration script, I just approved them all and dealt with an email for each going to my mailbox!

Note: It looks like the Typo 2.6 comment text isn’t being imported correctly.

Install Textile wrapper plugin

I use Textile for my Typo posts, so I needed this Wordpress plugin

Install GeSHi wrapper plugin

From the same place as the textile plugin, I installed the GeSHi wrapper to do my code tags. Note that, as of this writing, I still need to go through the DB and change my typo:code tags to the appropriate code tag.

Add the /articles/tags/foo rewrite to .htaccess

I’m trying to setup the rewrite rules to allow the /articles/tags/foo urls to work, but this has been problematic so far!

Update DNS or switch out the directories

Since I switched servers, I updated my DNS to point at the new location and waited until my site was switched.

Update Feedburner

I use Steve Smith’s Feedburner plugin. Feedburner will fail to change its configuration if the new url doesn’t exist, so you have to wait for the DNS changes to propogate before you can update your Feedburner configuration.

Cleanup the database

The Wordpress database is left with a bunch of unused Typo tables that need to be deleted. Dreamhost has phpMyAdmin that helps with this. Anything without a wp_ prefix should be removable.

Update!

Forgot to mention this, but I changed the upload directory for Wordpress from wp-content/uploads to files to match Typo and moved the files over from the Typo server.