duziyu 发表于 2012-6-18 11:13:09

数据恢复的时候提示。

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', `areaid` int(10) unsigned NOT NULL, `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` text NOT NULL, `code` text NOT NULL, `text_name` varchar(100) NOT NULL DEFAULT '', `text_url` varchar(255) NOT NULL DEFAULT '', `text_title` varchar(100) NOT NULL DEFAULT '', `text_style` varchar(50) NOT NULL, `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 '', `flash_loop` tinyint(1) unsigned NOT NULL DEFAULT '1', `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 AUTO_INCREMENT=34 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:0
Message:MySQL Query Error

七月 发表于 2012-6-18 11:48:34


网站后台数据库修复后,再备再恢复。

duziyu 发表于 2012-6-18 15:26:51


还是不行哎。

duziyu 发表于 2012-6-18 15:27:04


还是不行。。咋办

amanysky 发表于 2013-6-19 11:08:39


COMMENT='???   这个地方出出乱码,导致恢复报错,是由于编码引起的,可以把所有的这个地方手动修复下
页: [1]
查看完整版本: 数据恢复的时候提示。