论坛数据恢复时出错了，有文字，帮我看看谢谢了！

备份恢复时候出现了以下错误
Discuz! info: MySQL Query Error

User: dyago
Time: 2006-11-25 10:27am
Script: /DISCUZ/admincp.php

SQL: SET NAMES 'gbk'
Error: Unknown system variable 'NAMES'
Errno.: 1193
要怎么改呢？我看到有帖子说改默认字符集，去哪改？

这个是原来论坛的MySQL和现在要恢复数据进去的论坛使用的MySQL版本不同造成的，在原论坛备份数据的时候要注意，“建表语句格式”这项要选择跟现在的论坛使用的MySQL的版本一致。

你可以将备份数据中的 SET NAMES 'gbk' 删除掉再恢复数据试试。:)

Discuz! info: MySQL Query Error

User: uuloo
Time: 2006-11-26 12:14am
Script: /admincp.php

SQL: CREATE TABLE `cdb_sessions` ( `sid` char(6) character set gbk collate gbk_bin 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`)) ENGINE=HEAP DEFAULT CHARSET=gbk MAX_ROWS=65535
Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate gbk_bin NOT NULL default '', `ip1` tinyint(3) unsigned
Errno.: 1064