Archive for June 7th, 2009

• WordPress on a new server!

  Date: 2009.06.07 | Category: Projects | Response: 0

  So I’ve switched to WordPress on a newfangled server (ok just a newer old server, my old 2.4GHz P4 “Quagmire”).

  Migrating all of my Serendipity posts out was sort of a bitch. I lost all my comments, and am thinking of adding them back.

  Here’s what I had to do to get my Serendipity info into WordPress:

  insert into burns_wp.wp_posts (
  post_author,
  post_title,
  post_content,
  post_date,
  post_date_gmt,
  post_modified,
  post_modified_gmt)

  select
  serendipity.serendipity_entries.authorid,
  serendipity.serendipity_entries.title,
  serendipity.serendipity_entries.body,
  FROM_UNIXTIME(serendipity.serendipity_entries.timestamp),
  TIMESTAMPADD(HOUR,4,FROM_UNIXTIME(serendipity.serendipity_entries.timestamp)),
  FROM_UNIXTIME(serendipity.serendipity_entries.last_modified),
  TIMESTAMPADD(HOUR,4,FROM_UNIXTIME(serendipity.serendipity_entries.last_modified))

  from serendipity.serendipity_entries order by serendipity.serendipity_entries.timestamp