Discuz备份数据的时候会提示

Couldn't execute 'show create table `pre_forum_rsscache`': 
Can't find file: 'pre_forum_rsscache' (errno: 2 - No such file or directory) (1017)

网上很多代码最后一行有问题,其实应该在phpmyadmin里运行

DROP TABLE IF EXISTS pre_forum_rsscache;
CREATE TABLE cwh_forum_rsscache ( 
lastupdate int(10) unsigned NOT NULL DEFAULT '0', 
fid mediumint(8) unsigned NOT NULL DEFAULT '0', 
tid mediumint(8) unsigned NOT NULL DEFAULT '0', 
dateline int(10) unsigned NOT NULL DEFAULT '0', 
forum char(50) NOT NULL DEFAULT '', 
author char(15) NOT NULL DEFAULT '', 
`subject` char(80) NOT NULL DEFAULT '', 
description char(255) NOT NULL DEFAULT '', 
guidetype char(10) NOT NULL DEFAULT '', 
UNIQUE KEY tid (tid), 
KEY fid (fid,dateline) 
) ENGINE=MYISAM DEFAULT CHARSET=gbk

以上是基于MYSQL5.6+的方法,其他版本请自行测试。

« 返回