[已解决]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='???

suifeng

这个是 最新的补丁闹的  我的夜不行

hk2009

用软件备份
！！！！

枪炮牛仔

原帖由 hk2009 于 2010-9-9 17:41 发表
用软件备份
！！！！

用帝国备份同样出现问题。

hk2009

Navicat Premium V9 用这个试试，应该没问题

枪炮牛仔

我是虚拟机，不让远程连接