描述:本地电脑win7系统用齐博套件搭建的环境,用的织梦系统并添加了一些模块。在备份的时候没问题,但是将整站备份上传到虚拟空间后,用帝国恢复数据库却总错。
报错内容如下:(注:MYSQL支持查询方式的选项小勾已经去掉!!!) 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 'USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=gbk' at line 7 CREATE TABLE `dede_purview` ( `mid` mediumint(8) DEFAULT '0', `typeid` smallint(5) DEFAULT '0', `rank` smallint(6) DEFAULT NULL, `pkey` varchar(30) CHARACTER SET latin1 NOT NULL, `pvalue` text NOT NULL, KEY `pkey` (`pkey`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=gbk
|