Linux备份的数据导入win 后出现的错误

Discuz! info: MySQL Query Error

Time: 2007-3-19 4:07am
Script: /bbs/restore.php

SQL: CREATE TABLE [Table]medals ( medalid smallint(6) unsigned NOT NULL auto_increment, name varchar(50) NOT NULL default '', available tinyint(1) NOT NULL default '0', image varchar(30) NOT NULL default '', use tinyint(1) NOT NULL default '0', rest mediumint(8) NOT NULL default '0', lastuser varchar(32) default '', s1 mediumint(8) NOT NULL default '0', r1 mediumint(8) NOT NULL default '0', s2 mediumint(8) NOT NULL default '0', r2 mediumint(8) NOT NULL default '0', s3 mediumint(8) NOT NULL default '0', r3 mediumint(8) NOT NULL default '0', s4 mediumint(8) NOT NULL default '0', r4 mediumint(8) NOT NULL default '0', s5 mediumint(8) NOT NULL default '0', r5 mediumint(8) NOT NULL default '0', s6 mediumint(8) NOT NULL default '0', r6 mediumint(8) NOT NULL default '0', s7 mediumint(8) NOT NULL default '0', r7 mediumint(8) NOT NULL default '0', s8 mediumint(8) NOT NULL default '0', r8 mediumint(8) NOT NULL default '0', post mediumint(8) NOT NULL default '0', credit mediumint(8) NOT NULL default '0', regday mediumint(8) NOT NULL default '0', digest mediumint(8) NOT NULL default '0', pageview mediumint(8) NOT NULL default '0', online mediumint(8) NOT NULL default '0', admin mediumint(8) NOT NULL default '0', thread mediumint(8) NOT NULL default '0', reply mediumint(8) NOT NULL default '0', PRIMARY KEY (medalid)) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=36
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 'use tinyint(1) NOT NULL default '0', rest mediumint(8) NOT NULL default '0', l' at line 1
Errno.: 1064

Similar error report has beed dispatched to administrator before

sql版本号也没备份错..备份的字符集也没错. 选择的完全备份. 还是没法导入..
求助啊...........

[ 本帖最后由 tygcs 于 2007-3-19 12:33 编辑 ]

这个是什么错误啊? 老大们!

Discuz! info: MySQL Query Error

User: admin
Time: 2007-3-19 3:17pm
Script: /bbs/admincp.php

SQL: SELECT medalid, name, image FROM [Table]medals WHERE available='1'
Error: Table 'sq_bbb.[Table]medals' doesn't exist
数据表缺失,请恢复备份数据

这个是后台更新时的错误...