错误：1064论坛数据备份SQL4无法导入，一直显示CDB-SESSIONS NOT EXISTS！

问题如题，因为重新搭建论坛，数据备份按照有关教程修改导入后
发现SQL4数据备份一直无法导入！论坛显示错误：1064 请各位前辈紧急提供解决方案！！！
在线等待！！！

视频教程区有答案 :)

已经按照教程恢复了
但是问题在于数据备份SQL4在后台一直无法导入
导入后显示错误~~~

[ 本帖最后由 ilxmy 于 2006-12-21 03:54 编辑 ]

Discuz! info: MySQL Query Error

User: 六月
Time: 2006-12-21 3:50am
Script: /admincp.php

SQL: CREATE TABLE `cdb_sessions` ( `sid` char(6) 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=MEMORY DEFAULT CHARSET=gbk MAX_ROWS=5000
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 'DEFAULT CHARSET=gbk MAX_ROWS=5000' at line 1
Errno.: 1064


前台显示这是什么意思??????
这是我在恢复备份数据的时候出现的!!!
一共4卷,前3卷都恢复了,就最后一卷出问题了~~~
望高手解答!!!!我的QQ:200504209


后台导入第4卷显示如下错误:


Discuz! info: MySQL Query Error

Time: 2006-12-21 3:50am
Script: /index.php

SQL: SELECT s.sid, s.styleid, s.groupid='6' AS ipbanned, s.pageviews AS spageviews, s.lastolupdate, s.seccode, m.uid AS discuz_uid,
m.username AS discuz_user, m.password AS discuz_pw, m.secques AS discuz_secques, m.adminid, m.groupid, m.groupexpiry,
m.extgroupids, m.email, m.timeoffset, m.tpp, m.ppp, m.posts, m.digestposts, m.oltime, m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3,
m.extcredits4, m.extcredits5, m.extcredits6, m.extcredits7, m.extcredits8, m.timeformat, m.dateformat, m.pmsound,
m.sigstatus, m.invisible, m.lastvisit, m.lastactivity, m.lastpost, m.newpm, m.accessmasks,m.xspacestatus, m.editormode, m.customshow
FROM cdb_sessions s, cdb_members m
WHERE m.uid=s.uid AND s.sid='H1t6m5' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='222.186.70.193' AND m.uid='8'
AND m.password='f7ca9d8bd402759c8b95ccb923e5b8a3' AND m.secques=''
Error: Table 'discuz.cdb_sessions' doesn't exist
数据表缺失,请恢复备份数据

把第四卷中关于cdb_seesion的内容都删除掉，然后只恢复第四卷。

然后再手工建立cdb_session表。