数据库错误! 错误 1064 《《求助》》》

2016-07-20 16:24 来源:www.chinab4c.com 作者:ecshop专家

从phpmyadmin备份数据库,步骤:全部备份-MYSQL5.X版本-其他都为默认-然后点击备份 备份完毕后,下载到本地。然后通过phpmyadmin上传进行恢复数据库,共88个数据库备份文件,恢复到第72个的时候,出现下列错误页面,经过反复测试恢复依然如此。






错误

SQL 查询:

INSERT INTO `ecs_stats` (`access_time`, `ip_address`, `visit_times`, `browser`, `system`, `language`, `area`, `referer_domain`, `referer_path`, `access_url`) VALUES (1399464586, '124.205.64.242', 1, 'Internet Explorer 10.0', 'Windows NT', 'zh-CN', '', 'http://www.baidu.com', '/s?ie=utf-8&bs=%E5%8F%A4%E4%BB%A3%E5%BC%93%E7%AE%AD&f=3&rsv_bp=1&rsv_spt=3&wd=%E5%BC%93%E7%AE%AD&rsv_sug3=3&rsv_sug4=60&rsv_sug1=3&rsp=0&inputT=2000', '/index.php'), (1399464730, '111.123.80.72', 1, 'Internet Explorer 7.0', 'Windows NT', 'zh-CN', 'IANA', 'http://www.bow360.com', '/', '/index.php'), (1399464730, '111.123.80.72', 1, 'Internet Explorer 7.0', 'Windows NT', 'zh-CN', 'IANA', 'http://www.baidu.com', '/s?word=%E5%8F%8D%E6%9B%B2%E5%BC%93&tn=95460174_hao_pg&ie=utf-8', '/index.php'), (1399464743, '119.188.14.5', 1, 'Internet Explorer 6.0', 'Windows XP', '', 'APNIC', '', '', '/index.php'), (1399464895, '61.135.190.223', 1, 'FireFox 3.6.15', 'Windows XP', 'en-us,en', '', 'http://www.baidu.com', '/s?wd=%BB%F0%[...]

MySQL 返回:

#1064 - 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 ''/s?wd=%B9%AD%BC%FD%2C%B9%AD%BC%FD%D7%A8%C2

回答:
坐等回复

打开72个,可以把相关的ecs_stats插入语句去掉,ecs_stats不是很重要