写在前面
写在前面,方法来自网络搜集,自己也亲自测试过,感觉不错省去了使用插件袋来的烦恼。word press在使用过程中会产生很多不需要的内容,通过管理mysql数据库删除,减轻你的数据库负担!下面开始操作,操作前记得备份数据库,避免出错!
wp_posts表
删除文章表中的修订内容:
[demo]DELETE FROM wp_posts WHERE post_type = 'revision';[/demo]
wp_postmeta表
你可以直接复制下面的代码使用
[demo]DELETE FROM wp_postmeta WHERE meta_key = '_edit_lock';
DELETE FROM wp_postmeta WHERE meta_key = '_edit_last';
DELETE FROM wp_postmeta WHERE meta_key = '_revision-control';
DELETE FROM wp_postmeta WHERE post_id NOT IN (SELECT post_id FROM wp_posts);
DELETE FROM wp_postmeta WHERE meta_key = '_wp_old_slug';
DELETE FROM wp_postmeta WHERE meta_key = '_revision-control';
DELETE FROM wp_postmeta WHERE meta_value = '{{unknown}}';[/demo]
wp_comments表
删除垃圾和待审核评论
[demo]DELETE FROM wp_comments WHERE comment_type = 'trash';[/demo]
[demo]DELETE FROM wp_comments WHERE comment_approved = '0';[/demo]
wp_commentmeta表
这个我没用到,不知道干什么用,网上搜索来的清理代码如下:
[demo]TRUNCATE TABLE `wp_commentmeta`[/demo]
清理数据库的插件没用过,不好说了,这些是我网络上找来的,感谢网络上的高人,亲测好用!
评论0