Archive for June 7th, 2009
-
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
Random Image
Navigation
Other Blogs
Recent Comments
- Burns on CCIE renewed + Beach
- Heather on CCIE renewed + Beach
- the derek on 2010 Kawasaki Concours 14
- Brendan on New Year
- Justin on PS3 – Ratchet and Clank: A Crack in Time
Recent Posts
- CCIE renewed + Beach
- Busy lately – Camping, Jeeping, Motorcycling, Partying
- 2010 Kawasaki Concours 14
- Voracious Reading
- Shooter’s Log – Day 4