drupal转worldpress

    用Drupal太灵活了，灵活的我都搞不定了。所以我投向了worldpress.对比了一下表结构。参考网上的说明搞出了：

    use support;

    delete from wp_posts;

    delete from wp_comments;

    # 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 drupal_bak.node n, drupal_bak.node_revisions r

    WHERE n.vid = r.vid;

    # 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 drupal_bak.comments ;

    # update comments count on wp_posts table

    UPDATE `wp_posts` SET `comment_count` = (SELECT COUNT(`comment_post_id`) FROM `wp_comments` WHERE `wp_posts`.`id` = `wp_comments`.`comment_post_id`);

    # fix post slugs. first we have to remove the duplicate _____ chars, then replace that with a single - char

    UPDATE wp_posts set post_name = REPLACE(post_name, ‘__’, ‘_’);

    UPDATE wp_posts set post_name = REPLACE(post_name, ‘__’, ‘_’);

    UPDATE wp_posts set post_name = REPLACE(post_name, ‘__’, ‘_’);

    UPDATE wp_posts set post_name = REPLACE(post_name, ‘__’, ‘_’);

    UPDATE wp_posts set post_name = REPLACE(post_name, ‘_’, ‘-’);

    然后就可以看到worldpress工作了。