首页 > computer, study_note > How to Delete WordPress Post Revisions

How to Delete WordPress Post Revisions

2010年1月12日 T 发表评论 阅读评论

Just take a note, maybe I will use it someday. My memeries do not always serve me, tha’s so sad, -_-!!

As we all know WordPress saves your drafts automatically, that leaves a lot of revisions as backups on the server. It’s good, who wouldn’t  piss off if he typed for a long time and encountered some accidents like computer shut down for no reason. But on the other hand, when my articles posted, in most of the cases, I don’t need these revisions any more. Leaves them on the server as redundancy is useless and I guess they are adverse to the server’s performance. O.K., then things get really simple: KILL THEM ALL!

Try to access your WordPress database through some tools like phpMyAdmin(that’s the only tool I familiar with…), follow the steps below:

  1. Your database
  2. SQL
  3. type the following codes
    DELETE FROM wp_posts WHERE post_type = "revision";
  4. then press the button “Go”

Job Done.

分类: computer, study_note 标签: ,
  1. 2010年2月23日18:57 | #1

    为什么不用“Delete Revision plugin”呢?

  2. 2010年2月23日22:20 | #2

    @G字头老大
    插件当然也是个办法~ 不过一般能少用就少用,随便删除点东西,我觉得还是用命令比较好。你说呢?

  1. 本文目前尚无任何 trackbacks 和 pingbacks.
注意: 评论者允许使用'@user空格'的方式将自己的评论通知另外评论者。例如, ABC是本文的评论者之一,则使用'@ABC '(不包括单引号)将会自动将您的评论发送给ABC。使用'@all ',将会将评论发送给之前所有其它评论者。请务必注意user必须和评论者名相匹配(大小写一致)。