我使用的是phpMyAdmin 2.6.2
备份时设置按文件大小备份,和按记录数备份,恢复时都出现错误提示:
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 31 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', `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 '', `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` varchar(255) NOT NULL default '', PRIMARY KEY (`aid`) )
ENGINE=MyISAM AUTO_INCREMENT=82 DEFAULT CHARSET=gbk COMMENT='???
|