求救！备份的sql缺少表cdb_medals 导入不了论坛！

求救：

我论坛什么数据都没了，导入以前备份的sql数据.提示缺少表cdb_medals 导入不了论坛。有什么办法可以解决啊？？？

导入时提示的错误提示如下：
Discuz! info: MySQL Query Error

User: admin
Time: 2007-11-11 4:46pm
Script: /admincp.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)) TYPE=MyISAM AUTO_INCREMENT=43
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 NUL
Errno.: 1064

用记事本打开出错的这卷备份

查找

use tinyint(1) NOT NULL default '0'

修改为

usemark tinyint(1) NOT NULL default '0'

保存后再恢复。

谢谢。我先试试。

修改后第一卷成功导入了。第三卷不能导入。其它的20多卷都可以成功导入数据了。

在导入第三卷时提示错误如下。请帮我解决下好吗? 十万分感谢啊！！！

Discuz! info: MySQL Query Error

User: 与你同行
Time: 2007-11-11 11:30pm
Script: /admincp.php

SQL: CREATE TABLE [Table]payset ( groupid int(5) unsigned NOT NULL default '0', type tinyint(1) NOT NULL default '1', enable tinyint(1) NOT NULL default '0', allowrank tinyint(1) NOT NULL default '0', allowcheck tinyint(1) NOT NULL default '0', allowview tinyint(1) NOT NULL default '0', allowforum tinyint(1) NOT NULL default '0', forum varchar(255) NOT NULL default '0,0,0,0,0,0,0,0', leaveday mediumint(8) NOT NULL default '0', group mediumint(8) NOT NULL default '0', getprice mediumint(8) NOT NULL default '0', tax mediumint(8) NOT NULL default '0', up mediumint(8) NOT NULL default '0', down mediumint(8) NOT NULL default '0', rank varchar(255) NOT NULL default '0,0,0,0,0', check varchar(255) NOT NULL default '0,0,0,0,0', well varchar(255) NOT NULL default '0,0,0,0,0', top varchar(255) NOT NULL default '0,0,0,0,0', admin varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', post varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', digest varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', online varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', pageview varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', KEY groupid (groupid)) TYPE=MyISAM
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 'group mediumint(8) NOT NULL default '0', getprice mediumint(8)
Errno.: 1064

Similar error report has beed dispatched to administrator before.

用记事本打开出错的这卷备份

查找

group mediumint(8) NOT NULL default '0'

修改为

groupmark mediumint(8) NOT NULL default '0'

保存后再恢复。

修改后的这卷还是不能导入成功。
错误提示：

Discuz! info: MySQL Query Error

User: 与你同行
Time: 2007-11-12 12:19am
Script: /admincp.php

SQL: CREATE TABLE [Table]payset ( groupid int(5) unsigned NOT NULL default '0', type tinyint(1) NOT NULL default '1', enable tinyint(1) NOT NULL default '0', allowrank tinyint(1) NOT NULL default '0', allowcheck tinyint(1) NOT NULL default '0', allowview tinyint(1) NOT NULL default '0', allowforum tinyint(1) NOT NULL default '0', forum varchar(255) NOT NULL default '0,0,0,0,0,0,0,0', leaveday mediumint(8) NOT NULL default '0', groupmark mediumint(8) NOT NULL default '0', getprice mediumint(8) NOT NULL default '0', tax mediumint(8) NOT NULL default '0', up mediumint(8) NOT NULL default '0', down mediumint(8) NOT NULL default '0', rank varchar(255) NOT NULL default '0,0,0,0,0', check varchar(255) NOT NULL default '0,0,0,0,0', well varchar(255) NOT NULL default '0,0,0,0,0', top varchar(255) NOT NULL default '0,0,0,0,0', admin varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', post varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', digest varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', online varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', pageview varchar(255) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0', KEY groupid (groupid)) TYPE=MyISAM
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 'varchar(255) NOT NULL default '0,0,0,0,0', well varchar(255) N
Errno.: 1064

Similar error report has beed dispatched to administrator before.

用记事本打开出错的这卷备份

查找

check varchar(255) NOT NULL default '0,0,0,0,0'

修改为

checkmark varchar(255) NOT NULL default '0,0,0,0,0'

保存后再恢复。

多谢啊。以后不敢乱装了。写个教程吧。我第一个来学习。
我先修改再导入试试。再次谢谢。

谢谢了。终于成功导入了。
你真是我的救命恩人啊。使论坛起死会生了。

出错的这卷备份
是什么文件？