发新话题
打印

紧急求助啊!!!数据无法恢复!!

紧急求助啊!!!数据无法恢复!!

昨天我的数据库因为一次意外被清空了,幸好我前几天有备份,我先把install.php和install传上去,安装了一下,然后进入后台想来恢复数据,但是又遇上一麻烦事,我想把数据文件传到forumdata/backup_****文件夹下,但是却传不上去,然后把这个文件夹删除了再建一个就可以传了,传上去后我到后台来恢复,但是却出现了错误,错误提示如下


Discuz! info: MySQL Query Error

User: admin
Time: 2007-5-15 5:52am
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=11
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

An error report has been dispatched to our administrator.

TOP

http://www.discuz.net/viewthread ... page%3D1#pid5050503

我在DZ也有提问,但是我小白,不知道怎么做,有人指点吗?

TOP

'use tinyint(1) NOT NULL default '0', rest mediumint(8) NOT NUL


似乎是数据被截断了
用restore.php来恢复试试
这家伙很懒,什么也没留下.

TOP

发新话题