由于系统问题,需要修复一下数据库,使用的工具是phpmyadmin。
其中有部分表修复出现“The storage engine for the table doesn't support repair”使用google翻译了下,大概意思是:“表的存储引擎不支持修复”
错误的表是:
cdb_sessions
重新建立命令:
DROP TABLE IF EXISTS cdb_sessions;
CREATE TABLE cdb_sessions (
sid char(6) binary NOT NULL default '',
ip1 tinyint(3) unsigned NOT NULL default '0',
ip2 tinyint(3) unsigned NOT NULL default '0',
ip3 tinyint(3) unsigned NOT NULL default '0',
ip4 tinyint(3) unsigned NOT NULL default '0',
uid mediumint(8) unsigned NOT NULL default '0',
username char(15) NOT NULL default '',
groupid smallint(6) unsigned NOT NULL default '0',
styleid smallint(6) unsigned NOT NULL default '0',
invisible tinyint(1) NOT NULL default '0',
`action` tinyint(1) unsigned NOT NULL default '0',
lastactivity int(10) unsigned NOT NULL default '0',
lastolupdate int(10) unsigned NOT NULL default '0',
pageviews smallint(6) unsigned NOT NULL default '0',
seccode smallint(6) unsigned NOT NULL default '0',
fid smallint(6) unsigned NOT NULL default '0',
tid mediumint(8) unsigned NOT NULL default '0',
bloguid mediumint(8) unsigned NOT NULL default '0',
UNIQUE KEY sid (sid),
KEY uid (uid),
KEY bloguid (bloguid)
) TYPE=Heap;
评论