Seesmic made me move from BlogCFC to Wordpress
Ok, well they didn’t really make me move, but they did make me want to move. We (Seesmic) finally made public our plugin for Wordpress blogs, which allows for including video in blog posts and video commenting (seriously… how cool is that?).
A quick search on Google turned up this post by Sean Tierney, but his migration script doesn’t work for the newer versions of Wordpress. I attempted to muck around with the queries, but quickly grew tired of it.
A bit more searching and I came upon this post by James Netherton. The post mentions that it only works with MYSQL databases and that it has only been tested with Wordpress v2.3. I run my BlogCFC on MSSQL and the version of Wordpress that I have is 2.5, but I figured I could get the queries working.
I set everything up as instructed, but threw errors as soon as I attempted to execute the script. I mucked around with the queries for a while, but gave up and figured it would be quicker (read: easier) to migrate my data over to a MYSQL database. I downloaded the MYSQL Migration Tool and ported my blogCFC database from MSSQL to MYSQL quickly and painlessly. Once my database was moved over to MYSQL, I was able to run James Netherton’s script with no errors… and voila! My personal blog was ported over to Wordpress.
Posted under Seesmic, Social Media, Stuff