技术头条 - 一个快速在微博传播文章的方式     搜索本站
您现在的位置首页 --> MySQL --> drupal转worldpress

drupal转worldpress

浏览:1316次  出处信息

    用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工作了。

QQ技术交流群:445447336,欢迎加入!
扫一扫订阅我的微信号:IT技术博客大学习
© 2009 - 2024 by blogread.cn 微博:@IT技术博客大学习

京ICP备15002552号-1