pre_ucenter_pm_members'如何数据表恢复？

因为从PW转换时据短息的的数据表删除了，现在要恢复请问下如何操作？不恢复的话会员无法读职短信息，点击时出现如下提示：UCenter info: MySQL Query Error
SQL:SELECT COUNT(*) FROM [Table]pm_members m WHERE m.uid='4'
Error:Table 'liangzhi.pre_ucenter_pm_members' doesn't exist
Errno:1146

重建一下该表

1. DROP TABLE IF EXISTS uc_pm_members;
   
2. CREATE TABLE uc_pm_members (
   
3.   plid mediumint(8) unsigned NOT NULL default '0',
   
4.   uid mediumint(8) unsigned NOT NULL default '0',
   
5.   isnew tinyint(1) unsigned NOT NULL default '0',
   
6.   pmnum int(10) unsigned NOT NULL default '0',
   
7.   lastupdate int(10) unsigned NOT NULL default '0',
   
8.   lastdateline int(10) unsigned NOT NULL default '0',
   
9.   PRIMARY KEY  (plid,uid),
   
10.   KEY isnew (isnew),
    
11.   KEY lastdateline (uid,lastdateline),
    
12.   KEY lastupdate (uid,lastupdate)
    
13. ) TYPE=MyISAM;
    

复制代码

baxter 发表于 2011-6-11 01:01
重建一下该表

建这个表有没有图文教程呢，本人草根站长一名，不会重建

执行了又出现一个 uc_pm_lists' doesn't exist
烦死