版主.出大事了,,备份的数据恢复不了,怎么办

出大事了,,备份的数据恢复不了,怎么办?????????????????????管理员帮帮忙
我换了空间,在原来的空间时我以备份好了数据库.在新空间上装好了uch后,我在后台恢复数据,但一直恢复不了,
提示:

1. MySQL Error
   
2. Message: MySQL Query Error
   
3. SQL: CREATE TABLE uchome_award_info ( id int(4) unsigned NOT NULL auto_increment, awardno varchar(16) NOT NULL COMMENT '???????', awardname varchar(20) NOT NULL COMMENT '???????', credit int(4) NOT NULL COMMENT '????????', remain smallint(6) unsigned default '0' COMMENT '???????', exchange smallint(6) unsigned default '0' COMMENT '????????', isopen tinyint(1) NOT NULL COMMENT '??????? 1???????? 0????????', awardimg varchar(255) NOT NULL COMMENT '?????', description text NOT NULL COMMENT '???????', orders int(4) default NULL COMMENT '????', PRIMARY KEY (id)) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=gbk COLLATE=gbk_bin COMMENT='??????????? AUTO_INCREMENT=2
   
4. 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 ''??????????? AUTO_INCREMENT=2' at line 1
   
5. Errno.: 1064
   
6. Click here to seek help.

复制代码

这是什么问题??????急,

你原来空间的字符集和现在空间的字符集相同吗

相同的啊.怎么会这样的啊????????????

1. uchome_award_info

复制代码

这个表不是uch默认的吧？

1. `uchome_award_info`

复制代码

这个uchome_award_info 是你安装的插件表吧

玻璃屋女孩 问题还没有解决啊.uchome_award_info 这个我改了,还是不行

1. MySQL Error
   
2. Message: MySQL Query Error
   
3. SQL: CREATE TABLE uchome_award ( id int(4) unsigned NOT NULL auto_increment, awardno varchar(16) NOT NULL COMMENT '???????', awardname varchar(20) NOT NULL COMMENT '???????', credit int(4) NOT NULL COMMENT '????????', remain smallint(6) unsigned default '0' COMMENT '???????', exchange smallint(6) unsigned default '0' COMMENT '????????', isopen tinyint(1) NOT NULL COMMENT '??????? 1???????? 0????????', awardimg varchar(255) NOT NULL COMMENT '?????', description text NOT NULL COMMENT '???????', orders int(4) default NULL COMMENT '????', PRIMARY KEY (id)) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=gbk COLLATE=gbk_bin COMMENT='??????????? AUTO_INCREMENT=2
   
4. 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 ''??????????? AUTO_INCREMENT=2' at line 1
   
5. Errno.: 1064
   
6. Click here to seek help.

复制代码

把里面的 没加

1. ``

复制代码

的数据表名，字段都加上再试试

把里面的 没加的数据表名，字段都加上再试试
云天一 发表于 2009-9-18 10:01

加在那里???????

我的备份时出现这个问题,请问怎么解决呀?  

Warning: mysql_query(): Unable to save result set in d:\usr\www\html\include\db_mysql.class.php on line 58


Discuz! info: MySQL Query Error

User: ******
Time: 2009-9-23 8:20pm
Script: /admincp.php

SQL: SELECT * FROM [Table]statvars LIMIT 636, 300
Error: Got error 127 from table handler
Errno.: 1030

Similar error report has beed dispatched to administrator before.

AUTO_INCREMENT=2 DEFAULT CHARSET=gbk COLLATE=gbk_bin COMMENT='??????????? （这里要加一个[']符号）AUTO_INCREMENT=2