关于数据恢复时出现“SQL: SET NAMES 'gbk'。。。1193”错误的解释

http://bbs.solong.uni.cc/index.php

原帖由 askcad 于 2006-5-11 10:33 AM 发表
在你导出来的sql文件中改

可是我是从新安装 4.1.0
哪里来的sql文件？？？

大大，救我。当我改完后，出现这个问题

Discuz! info: MySQL Query Error

User: pah8000
Time: 2006-5-12 11:01am
Script: /forum/admincp.php

SQL: CREATE TABLE `cdb_adminnotes` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `admin` varchar(15) NOT NULL default '', `access` tinyint(3) NOT NULL default '0', `adminid` tinyint(3) NOT NULL default '0', `dateline` int(10) unsigned NOT NULL default '0', `expiration` int(10) unsigned NOT NULL default '0', `message` text NOT NULL, PRIMARY KEY (`id`)) TPYE=MyISAM AUTO_INCREMENT=1
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 'TPYE=MyISAM AUTO_INCREMENT=1' at line 1
Errno.: 1064

An error report has been dispatched to our administrator.

ENGINE=HEAP DEFAULT CHARSET=gbk这个我根本查不到

Discuz! info: MySQL Query Error

User: liucd
Time: 2006-6-25 11:11am
Script: /admincp.php

SQL: CREATE TABLE `cdb_access` ( `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=HEAP DEFAULT CHARSET=latin1
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=latin1' at line 1
Errno.: 1064

Similar error report has beed dispatched to administrator before.
我的也是不行啊？

顶。。。。。。。。。怎么回事情啊？

先顶起来再说,感谢 试试去

成功了，不过你后来说的几个字符都没找到，不过这次恢复成功了HOH

数据恢复到最后3卷出问题了！
Discuz! info: MySQL Query Error

Time: 2006-7-2 10:16am
Script: /dz/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
FROM cdb_sessions s, cdb_members m
WHERE m.uid=s.uid AND s.sid='RuSQrn' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='218.13.162.19' AND m.uid='6'
AND m.password='01edce0961bf7409ae1f2dd92ce1ded2' AND m.secques=''
Error: Table 'sq_fwy798.cdb_sessions' doesn't exist
数据表缺失,请恢复备份数据

An error report has been dispatched to our administrator.

[ 本帖最后由 善瑜 于 2006-7-2 10:30 编辑 ]

数据表缺失,请恢复备份数据