Upgrading from WordPress 1.5 to WordPress 2

Last night I decided to upgrade and move this blog to WordPress 2 from WordPress 1.5. I’ve had a Dreamhost account for several months and used their one click installer to get the code on my shared hosting space. That was the easy part.

The more difficult part was migrating my content from the old database to the new database.

Here’s what I had to do:

On WP 1.5:

1) Execute the following SQL statements:

alter table wp_posts ADD COLUMN post_lat FLOAT(12,31) after post_excerpt;
alter table wp_posts ADD COLUMN post_lon FLOAT(12,31) after post_lat;
alter table wp_categories ADD COLUMN category_count bigint(20) default NULL;

2) Install  http://technosailor.com/downloads/wp-xmlmigrate2.zip per the instructions

3) Activate the plug-in

4) Export the  contents from WordPress 1.5

5) Import the contents into WordPress 2

I hope that helps and if anyone reads this and I missed a step please let me know.