Discuz can‘t find “pre_forum_rsscache“的解决方案

mysql -e "show databases;" -uroot -p123456| grep -Ev "Database|information_schema|mysql|test" | xargs mysqldump -uroot -p123456 --databases > /home/mysql/mysql.sql

在使用数据库备份的时候提示，can't find "pre_forum_rsscache" 。

先进入数据库，查看dz论坛的数据库表是utf8还是gbk

mysql> show databases;
mysql> use tree;
mysql> show tables;
mysql> show create table pre_forum_thread;

 

把以下代码保存为mysql.sql文件

USE `tree`;
DROP TABLE IF EXISTS pre_forum_rsscache;
CREATE TABLE pre_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)
) TYPE=MyISAM DEFAULT CHARSET=utf8;

mysql -uroot -p123456 tree < mysql.sql

恢复即可。