Kurt McKee

lessons learned in production


Hey there! This article was written in 2010.

It might not have aged well for any number of reasons, so keep that in mind when reading (or clicking outgoing links!).

Migrating back to Wordpress

Posted 14 February 2010 in technology and website

I've started working to migrate my online presence back to kurtmckee.org; it's been two-and-a-half years since I self-hosted my blog, and in that time I've fragmented my identity across LiveJournal, Blogger, Tumblr, and a smattering of other services including YouTube and Flickr.

Thus far I've upgraded my Wordpress install, dropped a number of unused database tables, and cleaned up some inconsistencies in the comments metadata. I still need to convert the crufty latin1 database encoding to utf8, import all of my LiveJournal and Blogger entries and comments, and configure pretty URLs. I've yet to decide how I want to handle photos and tumblelog entries; for now I expect that I'll continue using Flickr and Tumblr (unless someone endorses an outstanding Wordpress plugin).

The best outcome so far has been the rapid increase of my knowledge of SQL (and, as a direct result of my experimentation, the discovery that I have good database backups). I can construct a select or update statement fairly competently now. Oh, and drop table, if I forswear tab completion!

Stupid tab completion...