Migrating to WordPress 1.5

So I’ve had WordPress installed for all of a week & then they go and release a new version on me. Sigh.

Anyway, I figure if I intend to keep up my web-nerd cred I’d better install it. So I’ve done that & I now need a way to import all my messages from this site to the new site. I’m not game enough to do the direct upgrade thing that’s descibed, I wanted a parrallel cut-over. That’s when I discovered one thing really lacking in WordPress: There is no export function.

WordPress has plenty of good scripts for importing posts & comments from other platforms, but nothing to go from one copy of wordpress to another, specifically from one version of wordpress to another. The upgrade instructions show you how to change your current blog from 1.x to 1.5, but not what to do if you want to have them both running at the same time.

In the end I had to do it by doing a DB dump and running the SQL script on the new DB, but I still needed to hack that slightly to get it to work. There are 4 tables that contain the information about the posts & comments: wp_categories, wp_comments, wp_post2cat, wp_postmeta & wp_posts. The only structural change as far as I can see is the removal of the ICBM data (i.e. the post_lat & post_lon fields) from the wp_post table. As it was far easier to modify the 1.5 database than to get the export script to exclude those fields, I just added those two fields to the wp_post table, ran the script then dropped the fields. See, easy!

This was way to fiddly for your average joe-user, there really needs to be a way to export all your posts & comments in a standard format that can be imported into other WordPress blogs and also into other platforms. If you do need to do this, here’s the code:

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;

###INSERT STATEMENTS HERE####

alter table wp_posts drop column post_lat;
alter table wp_posts drop column post_lon;

Just replace ###INSERT STATEMENTS HERE#### with the insert statements from the database backup (procedure is shown here) for the tables mentioned above.

So anyway, the long and the short of it is that we’re now running on 1.5, and I haven’t changed anything yet. Time to start on a whole new template!. I’ve installed the very nice Greentrack theme and over the next few days/weeks I’m going to try and hack it into exactly what I want. Props to Sadish for his top work on wpthemes.

21 thoughts on “Migrating to WordPress 1.5

  1. Bravo on the upgrade. The lack of a decent export plugin/feature was one of the first things I noticed about WordPress. When I first switched to WP from MT 2.6X I was terrified, as I knew very little about MySQL/PHP. At one point, I even tried to go back to MT — but I’m sold now, and I’m in this thing for the long haul now.

    I look forward to watching for your changes.

    Peace,
    Andy

    P.S. — How do did you get the ESV RSS feed onto your blog? I once had a plugin to parse the RSS but can’t remember how I did it.

  2. Bravo on the upgrade. The lack of a decent export plugin/feature was one of the first things I noticed about WordPress. When I first switched to WP from MT 2.6X I was terrified, as I knew very little about MySQL/PHP. At one point, I even tried to go back to MT — but I’m sold now, and I’m in this thing for the long haul now.I look forward to watching for your changes.Peace,AndyP.S. — How do did you get the ESV RSS feed onto your blog? I once had a plugin to parse the RSS but can’t remember how I did it.

  3. The plug-ins I use:
    Hello Prufie – An edited version of “Hello Dolly” that displays a random quote from “The Love Song of J. Alfred Prufrock”
    My MooMus – a custom field handler for “Now Listening” and “My mood” (and whatever else you want to list)
    WP-HTMLArea – for my less html savvy posters

    I’ve tried using a few of the different gallery plugins for image handling but they all seem too buggy to be very useful. If anyone has any that work reliably I’d love to hear about them…

  4. Here are some of the plug-ins I use:

    WP Amazon for linking to media off Amazon in posts
    Dustan’s Time of Day – For nicer post times
    Staticize ReloadedMakes certain areas of your page static… I play around with this one but dont have it on since I moved to 1.5
    Post Count – duh
    Gravatar – displays the avatar of the poster
    Customizable Post Listings I use this for thumbnails in the extended entry field on my photoblog… not working quite right in 1.5 though.
    CG-Feedread – A simple RSS/RDF feed aggregator for displaying feeds.

    well, there’s no way this comment is getting through without moderation!

  5. WP Amazon for linking to media off Amazon in postsDustan’s Time of Day – For nicer post timesStaticize ReloadedMakes certain areas of your page static… I play around with this one but dont have it on since I moved to 1.5Post Count – duhGravatar – displays the avatar of the posterCustomizable Post Listings I use this for thumbnails in the extended entry field on my photoblog… not working quite right in 1.5 though.CG-Feedread – A simple RSS/RDF feed aggregator for displaying feeds.well, there’s no way this comment is getting through without moderation!

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>