WordPress on a new server!

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


Posted

in

by

Tags: