drupal向wp的移植过程
终于下了决心把drupal整个换为wp了。
1、wp的表结构比drupal简单很多，要移植的主要就是四张表，
分类表wp_categories：
insert into wp_categories (cat_id, cat_name, category_nicename, category_description, category_parent) select term_data.tid, name, name, description, parent from term_data, term_hierarchy where term_data.tid=term_hierarchy.tid;
update wp_categories set category_count = (select count(post_id) from wp_post2cat where wp_categories.cat_id = wp_post2cat.category_id);
文章表wp_posts：
insert into wp_posts (id, post_date, post_content, post_title, post_excerpt, post_name, post_modified) select distinct n.nid, from_unixtime(created), body, n.title, teaser, replace(replace(replace(replace(lower(n.title),' ', '_'),'.', '_'),',', '_'),'+', '_'), from_unixtime(changed) from node n, node_revisions r where n.vid = r.vid;
update wp_posts set post_name = replace(post_name, '_', '-');
文章分类关系表wp_post2cat：
insert into wp_post2cat (post_id,category_id) select nid,tid
from term_node ;
评论表wp_comments：
insert into wp_comments(comment_post_id, comment_date, comment_content, comment_parent, comment_author, comment_author_email, comment_author_url) select nid, from_unixtime(timestamp), comment, thread, name, mail, homepage from comments ;
update wp_posts set comment_count = (select count(comment_post_id) from wp_comments where wp_posts.id = wp_comments.comment_post_id);
2、移植过程中一些问题的修正，
分类表中文章数：
update wp_categories set category_count =84 where cat_id=1;
update wp_categories set category_count =205 where cat_id=5;
update wp_categories set category_count =142 where cat_id=6;
update wp_categories set category_count =274 where cat_id=11;
参数表：
update wp_options set option_value='http://www.robertbao.com' where option_id=40 or option_id=1;
3、三个post转为page，并将post调整从1149开始继续计数，
alter table wp_posts auto_increment = 1149;
delete from wp_post_counter_time where post_id>='9527';
delete from wp_post_counter where post_id>='9527';
delete from wp_postmeta where post_id>='9527';
delete from wp_posts where id='1';
delete from wp_posts where id='2';
delete from wp_posts where id='3';
update wp_posts set id='1',guid ='http://www.robertbao.com/?page_id=1' where id='1151';
update wp_posts set id='2',guid ='http://www.robertbao.com/?page_id=2' where id='1150';
update wp_posts set id='3',guid ='http://www.robertbao.com/?page_id=3' where id='1149';
最新评论