[已解决]3.0备份的SQL数据无法正常恢复
已发现原因了，分享一下。：大概是由于2.5升级到3.0后，表注释全变成问号，导至备份不正常，刚没事把表注释的问题全改为中文后，备份再恢复可以了。这个是最新版的，0906
注：我的网站是从当时的1.0一路升到现在的3.0的数据，使用时都正，但3.0备份就出问题。
备份后，后台一恢复就出错：
MySQL Query:CREATE TABLE `destoon_ad` ( `aid` int(10) unsigned NOT NULL auto_increment, `title` varchar(100) NOT NULL default '', `pid` int(10) unsigned NOT NULL default '0', `typeid` tinyint(1) unsigned NOT NULL default '0', `amount` float NOT NULL default '0', `currency` varchar(20) NOT NULL default '', `url` varchar(255) NOT NULL default '', `introduce` varchar(255) NOT NULL default '', `hits` int(10) unsigned NOT NULL default '0', `username` varchar(30) NOT NULL default '', `addtime` int(10) unsigned NOT NULL default '0', `editor` varchar(30) NOT NULL default '', `edittime` int(10) unsigned NOT NULL default '0', `fromtime` int(10) unsigned NOT NULL default '0', `totime` int(10) unsigned NOT NULL default '0', `stat` tinyint(1) unsigned NOT NULL default '0', `note` mediumtext NOT NULL, `code` mediumtext NOT NULL, `text_name` varchar(100) NOT NULL default '', `text_url` varchar(255) NOT NULL default '', `text_title` varchar(100) NOT NULL default '', `image_src` varchar(255) NOT NULL default '', `image_url` varchar(255) NOT NULL default '', `image_alt` varchar(100) NOT NULL default '', `flash_src` varchar(255) NOT NULL default '', `flash_url` varchar(255) NOT NULL default '', `key_moduleid` smallint(6) unsigned NOT NULL default '0', `key_catid` smallint(6) unsigned NOT NULL default '0', `key_word` varchar(100) NOT NULL default '', `key_id` bigint(20) unsigned NOT NULL default '0', `listorder` smallint(4) unsigned NOT NULL default '0', `status` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`aid`), KEY `pid` (`pid`)) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='???
MySQL 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 ''???' at line 1 MySQL Errno:1064
Message:MySQL Query Error
[ 本帖最后由 枪炮牛仔 于 2010-9-9 20:50 编辑 ]
使用帝国备份王恢复也是出问题。
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 ''???' at line 36
CREATE TABLE `destoon_ad` ( `aid` int(10) unsigned NOT NULL auto_increment, `title` varchar(100) NOT NULL default '', `pid` int(10) unsigned NOT NULL default '0', `typeid` tinyint(1) unsigned NOT NULL default '0', `amount` float NOT NULL default '0', `currency` varchar(20) NOT NULL default '', `url` varchar(255) NOT NULL default '', `introduce` varchar(255) NOT NULL default '', `hits` int(10) unsigned NOT NULL default '0', `username` varchar(30) NOT NULL default '', `addtime` int(10) unsigned NOT NULL default '0', `editor` varchar(30) NOT NULL default '', `edittime` int(10) unsigned NOT NULL default '0', `fromtime` int(10) unsigned NOT NULL default '0', `totime` int(10) unsigned NOT NULL default '0', `stat` tinyint(1) unsigned NOT NULL default '0', `note` mediumtext NOT NULL, `code` mediumtext NOT NULL, `text_name` varchar(100) NOT NULL default '', `text_url` varchar(255) NOT NULL default '', `text_title` varchar(100) NOT NULL default '', `image_src` varchar(255) NOT NULL default '', `image_url` varchar(255) NOT NULL default '', `image_alt` varchar(100) NOT NULL default '', `flash_src` varchar(255) NOT NULL default '', `flash_url` varchar(255) NOT NULL default '', `key_moduleid` smallint(6) unsigned NOT NULL default '0', `key_catid` smallint(6) unsigned NOT NULL default '0', `key_word` varchar(100) NOT NULL default '', `key_id` bigint(20) unsigned NOT NULL default '0', `listorder` smallint(4) unsigned NOT NULL default '0', `status` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`aid`), KEY `pid` (`pid`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='???
这个是 最新的补丁闹的我的夜不行
用软件备份
！！！！
原帖由 hk2009 于 2010-9-9 17:41 发表
用软件备份
！！！！
用帝国备份同样出现问题。
Navicat Premium V9 用这个试试，应该没问题
我是虚拟机，不让远程连接
页:
[1]