更换服务器后,采用数据恢复->> 输入 data/backup_L8rTf1/090411_i5sbZlb4-1.sql
导入开始。后跳出: 无法恢复数据? 是不是因为表名的原因。
MySQL Error
Message: MySQL Query Error
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 DEFAULT CHARSET=gbk COLLATE=gbk_bin COMMENT='??????????? AUTO_INCREMENT=1
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=1' at line 1
Errno.: 1064
Click here to seek help. |