I just updated from b2 to WordPress to get rid of the comment spam (thbbbt!).
I tried the script to migrate everything over, but it didn’t work, so here are the database statements I executed in MySql to get this done:
Move categories:
insert into (cat_ID, cat_name) select * from b2categories where cat_ID != 1;
Move posts:
insert into wp_posts (ID, post_author, post_date, post_content, post_title, post_category) select ID, post_author, post_date, post_content, post_title, post_category FROM b2posts;
Update wp_posts with correct information:
update wp_posts set post_status = ‘publish’, comment_status = ‘open’, ping_status = ‘open’;
Move post2cat:
insert into wp_post2cat (post_id, category_id) select ID, post_category FROM wp_posts;
Comments (after deleting the spam jerks):
insert into wp_comments (comment_ID, comment_post_ID, comment_author, comment_author_email, comment_author_IP, comment_date, comment_content, comment_karma) select comment_ID, comment_post_ID, comment_author, comment_author_email, comment_author_IP, comment_date, comment_content, comment_karma from b2comments;
update wp_comments set comment_approved=’1′;
Seems to work OK for now.