删除WordPress文章修订记录

刚刚进了下服务器后台,天啊,数据库怎么突然变得这么大了???居然20多M!前几天还是十几M呢,仔细检查一下,原来是wp_posts这个变大了,再进入此表看了下,post_type里的revision突然又有了接近2000行数据!
哦,原来前天我进行永久链接更换的时候,WP自动保存了所有修订记录,应该是这样,要不然不会突然之间变大这么多。
运行下面这段代码:DELETE FROM wp_posts WHERE post_type=revision;
DELETE FROM wp_postmeta WHERE post_id IN (SELECT id FROM wp_posts WHERE post_type = revision);
DELETE FROM wp_term_relationships WHERE object_id IN (SELECT id FROM wp_posts WHERE post_type=revision);
DELETE FROM wp_posts WHERE post_type=revision;

Leave a Reply

:wink: :-| :-x :twisted: :) 8-O :( :roll: :-P :oops: :-o :mrgreen: :lol: :idea: :-D :evil: :cry: 8) :arrow: :-? :?: :!:


正在读取数据……