robertbao.com

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′;

数据库升级为mysql 5.0，重新导入表的时候出现如下错误：

#
# table structure for table ‘locales_source’
#
create table /*!32300 if not exists*/locales_source(
lid int( 11 ) not null auto_increment ,
location varchar( 255 ) not null default ”,
source blob not null default ”,
primary key ( lid ) ,
index source( source )
);


MySQL answer : #1170 - BLOB/TEXT column ’source’ used in key specification without a key length

在mysql官方网站上找到了解决办法：http://forums.mysql.com/read.php?10,113556,113556#msg-113556

mysql5.0以后text/blob index需要指定长度，改为下面的写法就通过了，

#
# table structure for table ‘locales_source’
#
create table /*!32300 if not exists*/locales_source(
lid int( 11 ) not null auto_increment ,
location varchar( 255 ) not null default ”,
source blob not null default ”,
primary key ( lid ) ,
index source( source( 30 ) )
);