紧急求助，恢复数据出错！

Discuz! info: MySQL Query Error

Time: 2009-6-7 1:29pm
Script:

SQL: CREATE TABLE uchome_doing ( doid mediumint(8) unsigned NOT NULL auto_increment, uid mediumint(8) unsigned NOT NULL default '0', username varchar(15) NOT NULL default '', from varchar(20) NOT NULL default '', dateline int(10) unsigned NOT NULL default '0', message text NOT NULL, ip varchar(20) NOT NULL default '', replynum int(10) unsigned NOT NULL default '0', mood smallint(6) NOT NULL default '0', PRIMARY KEY (doid), KEY uid (uid,dateline), KEY dateline (dateline)) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=45
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 'from varchar(20) NOT NULL default '', dateline int(10) unsigned NOT NULL defaul' at line 1
Errno.: 1064


HOME恢复数据出这个错误！！请问啥办？？
我是用toops.php工具恢复的！！！论他和UC恢复好，就HOME不行！

uchome_doing出现问题

重新创建下这个表

可以执行以下语句后再进行恢复试下（操作前请备份好数据）

1. 
   
2. CREATE TABLE uchome_doing (
   
3.   doid mediumint(8) unsigned NOT NULL auto_increment,
   
4.   uid mediumint(8) unsigned NOT NULL default '0',
   
5.   username varchar(15) NOT NULL default '',
   
6.   `from` varchar(20) NOT NULL default '',
   
7.   dateline int(10) unsigned NOT NULL default '0',
   
8.   message text NOT NULL,
   
9.   ip varchar(20) NOT NULL default '',
   
10.   replynum int(10) unsigned NOT NULL default '0',
    
11.   mood smallint(6) NOT NULL default '0',
    
12.   PRIMARY KEY  (doid),
    
13.   KEY uid (uid,dateline),
    
14.   KEY dateline (dateline)
    
15. ) ENGINE=MyISAM;
    
16. 
    

复制代码