从已有论坛恢复数据库到新论坛出现这几行字，有详细的安装过程,麻烦高手看一下

我在试用别处空间，想导入已有论坛的数据，从已有论坛备份后恢复到现试用的论坛出现上述几行
已有论坛地址:http://www.ga0795.com/index.php
以前装过银行,现已删除

Discuz! info: MySQL Query Error

User: bol_sun
Time: 2006-10-21 3:24pm
Script: /bbs/admincp.php

SQL: SET NAMES 'gbk'
Error: Unknown system variable 'NAMES'
Errno.: 1193

我用文本工具打开备份数据文件,即 .sql的那些文件,

找到并删除 SET NAMES 'gbk'

后来出现

Discuz! info: MySQL Query Error

User: bol_sun
Time: 2006-10-21 5:28pm
Script: /bbs/admincp.php

SQL: CREATE TABLE `cdb_bsaccess` ( `uid` mediumint(8) unsigned NOT NULL default '0', `fid` smallint(6) unsigned NOT NULL default '0', `allowview` tinyint(1) NOT NULL default '0', `allowpost` tinyint(1) NOT NULL default '0', `allowreply` tinyint(1) NOT NULL default '0', `allowgetattach` tinyint(1) NOT NULL default '0', `allowpostattach` tinyint(1) NOT NULL default '0', PRIMARY KEY (`uid`,`fid`)) ENGINE=MyISAM DEFAULT CHARSET=gbk
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' at line 1
Errno.: 1064


出现以上字符……

我查找 ENGINE=MyISAM DEFAULT CHARSET=gbk
并替换成  TYPE=MyISAM

现在出现下面这个不知道怎么弄了

Discuz! info: MySQL Query Error

Time: 2006-10-26 11:41am
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='BdBBhT' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='59.52.112.111' AND m.uid='1'
AND m.password='c5dad163d1205800077461644788389a' AND m.secques=''
Error: Table 'db_scgood.cdb_sessions' doesn't exist
Errno.: 1146

Similar error report has beed dispatched to administrator before.

CHARSET=gbk'

。。。。。

确定旧论坛和新论坛的数据库版本是否一致。。

找我
QQ147487354
13997587725

原帖由 Flash菲 于 2006-10-26 12:12 发表
确定旧论坛和新论坛的数据库版本是否一致。。

数据库版本是不是一样就不清楚了