首页建站经验备份恢复错误提示：You have an error in your SQL syntax. Chec

备份恢复错误提示：You have an error in your SQL syntax. Chec

admin 2019-11-02 15:21:38 阅读() 评论()

问题：备份恢复错误提示：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 'DEFAU…

问题：备份恢复错误提示：

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 'DEFAULT CHARSET=gbk' at line 51

解答：你新服务器上使用的是mysql4.0，而你原服务器使用的是4.1以上版本的原故。

解决方法：备份时选择备份为4.0格式