随着 Discuz 论坛架设运行时间的延迟，数据库也越来越庞大。那么给数据库瘦身是一个必要的过程。短消息是一个很好的入手点。基本上很多时候短消息看一下就不管了，用户基本不删除。所以大多是无用的信息。所以今天 Forece 教大家如何利用 phpmyadmin 操作 Mysql 数据来清空 Discuz 的短信息。
代码如下:
1 2 3 4 5 6 7 8 9 10 11 12 13 | DELETE FROM `pre_ucenter_pm_lists` WHERE 1 ; DELETE FROM `pre_ucenter_pm_members` WHERE 1 ; DELETE FROM `pre_ucenter_pm_members` WHERE 1 ; DELETE FROM `pre_ucenter_pm_messages_0` WHERE 1 ; DELETE FROM `pre_ucenter_pm_messages_1` WHERE 1 ; DELETE FROM `pre_ucenter_pm_messages_2` WHERE 1 ; DELETE FROM `pre_ucenter_pm_messages_3` WHERE 1 ; DELETE FROM `pre_ucenter_pm_messages_4` WHERE 1 ; DELETE FROM `pre_ucenter_pm_messages_5` WHERE 1 ; DELETE FROM `pre_ucenter_pm_messages_6` WHERE 1 ; DELETE FROM `pre_ucenter_pm_messages_7` WHERE 1 ; DELETE FROM `pre_ucenter_pm_messages_8` WHERE 1 ; DELETE FROM `pre_ucenter_pm_messages_9` WHERE 1 ; |