请问mysql4.1能不能备份为4.0 帝国cms - 安全、强大、稳定、灵活

帝国论坛 → 帝国软件产品与服务 → 帝国备份王 → 请问mysql4.1能不能备份为4.0

【本版专题贴子】

枕云
用户头衔：书生

精华贴   ：0
发贴数   ：1
经验值   ：7
注册时间：2007-10-02

信息

搜索

好友

发送悄悄话

【精益求精－帝国网站管理系统7.5正式版开源发布】 [第 1 楼]

请问mysql4.1能不能备份为4.0

4.1备份的数据导入4.0.26如下错误.

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 'collate gbk_bin NOT NULL default '', `keywords` varchar(50) N
CREATE TABLE `jieqi_article_article` ( `articleid` int(11) unsigned NOT NULL auto_increment, `siteid` smallint(6) unsigned NOT NULL default '0', `postdate` int(11) unsigned NOT NULL default '0', `lastupdate` int(11) unsigned NOT NULL default '0', `articlename` varchar(50) character set gbk collate gbk_bin NOT NULL default '', `keywords` varchar(50) NOT NULL default '', `initial` char(1) NOT NULL default '', `authorid` int(11) unsigned NOT NULL default '0', `author` varchar(30) character set gbk collate gbk_bin NOT NULL default '', `posterid` int(11) unsigned NOT NULL default '0', `poster` varchar(30) character set gbk collate gbk_bin NOT NULL default '', `agentid` int(11) unsigned NOT NULL default '0', `agent` varchar(30) character set gbk collate gbk_bin NOT NULL default '', `sortid` smallint(3) unsigned NOT NULL default '0', `typeid` smallint(3) unsigned NOT NULL default '0', `intro` text NOT NULL, `notice` text NOT NULL, `setting` text NOT NULL, `lastvolumeid` int(11) unsigned NOT NULL default '0', `lastvolume` varchar(100) NOT NULL default '', `lastchapterid` int(11) unsigned NOT NULL default '0', `lastchapter` varchar(100) NOT NULL default '', `chapters` smallint(6) unsigned NOT NULL default '0', `size` int(11) unsigned NOT NULL default '0', `lastvisit` int(11) unsigned NOT NULL default '0', `dayvisit` int(11) unsigned NOT NULL default '0', `weekvisit` int(11) unsigned NOT NULL default '0', `monthvisit` int(11) unsigned NOT NULL default '0', `allvisit` int(11) unsigned NOT NULL default '0', `lastvote` int(11) unsigned NOT NULL default '0', `dayvote` int(11) unsigned NOT NULL default '0', `weekvote` int(11) unsigned NOT NULL default '0', `monthvote` int(11) unsigned NOT NULL default '0', `allvote` int(11) unsigned NOT NULL default '0', `goodnum` int(11) unsigned NOT NULL default '0', `badnum` int(11) unsigned NOT NULL default '0', `toptime` int(11) unsigned NOT NULL default '0', `saleprice` int(11) unsigned NOT NULL default '0', `salenum` int(11) unsigned NOT NULL default '0', `totalcost` int(11) unsigned NOT NULL default '0', `articletype` tinyint(1) unsigned NOT NULL default '0', `permission` tinyint(1) unsigned NOT NULL default '0', `firstflag` tinyint(1) unsigned NOT NULL default '0', `fullflag` tinyint(1) unsigned NOT NULL default '0', `imgflag` tinyint(1) unsigned NOT NULL default '0', `power` tinyint(1) unsigned NOT NULL default '0', `display` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`articleid`), KEY `articlename` (`articlename`), KEY `posterid` (`posterid`), KEY `authorid` (`authorid`), KEY `agentid` (`agentid`), KEY `initial` (`initial`), KEY `sortid` (`sortid`,`typeid`), KEY `display` (`display`), KEY `size` (`size`), KEY `lastupdate` (`lastupdate`), KEY `author` (`author`) ) TYPE=MyISAM