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