随着 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 ;