February 9, 2009删除WordPress多余Reversions

Author : Kunn | Views : 1,069 | Comments : 4

Category: 网络相关 | Tages: ,

Plugin : Disable Revisions

删除数据库多余的Revisons脚本:

DELETE a,b,c FROM wp_posts a LEFT JOIN wp_term_relationships b ON (a.ID=b.object_id) LEFT JOIN wp_postmeta c ON (a.ID=c.post_id) WHERE a.post_type='revision';

另:禁止生产Revisions,在wp-config.php 增加 define(’WP_POST_REVISIONS’, false);

4 Comments »

  • 大猫 said:

    可以直接在wp-config里禁用掉哈

  • Kunn said:

    是吗,俺比较懒的说,不让用插件来得方便…
    我再gg看,呵呵

  • 小鑫 said:

    执行完后,发现部分友链变成无分类了……

  • Kunn said:

    不是吧, 我用的好好的啊….

Leave your response!

Add your comment below, or trackback from your own site. You can also subscribe to these comments via RSS.

Be nice. Keep it clean. Stay on topic. No spam.

You can use these tags:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

This is a Gravatar-enabled weblog. To get your own globally-recognized-avatar, please register at Gravatar.