本人在本地使用navicat for MySQL可以连接到服务器数据库,但是从服务器数据库用navicate导出的.sql文件后再用navicate导入到本地的数据库中会出现若干条记录的错误:
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to yourmysql server version for the right syntax to use near ****
[Err] /*
一、在网上找了很多方法都无法解决,无意中看到一个mysql数据同步的方法:
1>在本地建一个与数据库同名的数据库
2>选择navicat中连接服务器的数据库,在菜单栏选择工具-->数据传输
![](/wp-content/uploads/2018/08/0f400f79901007f.png)
![](/wp-content/uploads/2018/08/c25a2b02ed25cd5.png)
![](/wp-content/uploads/2018/08/1a7eab7979baff3.png)
![](/wp-content/uploads/2018/08/e19a5dc5b5672f9.png)
二、从备份中导出.sql再导入到本地数据库中
1>在连接服务器中的数据库上新建备份,选中要备份的数据库-->点击菜单栏上的备份-->新建备份
![](/wp-content/uploads/2018/08/93fed4da53a01fc.png)
![](/wp-content/uploads/2018/08/923aced0069c019.png)
![](/wp-content/uploads/2018/08/51f2882124e0027.png)
![](/wp-content/uploads/2018/08/353b564621a51ac.png)
![](/wp-content/uploads/2018/08/1841b83eb3bacad.png)
![](/wp-content/uploads/2018/08/7fac17f6607329e.png)