sqlyog导入数据文件时，弹框报错：
There was an error while executing a query.
The query and the error message has been logged at:
C:\Users\liang\AppData\Roaming\SQLyog\sqlyog.err.
Please click on “Open Error File…” to open the error file.
解决方法如下：
找到/etc/my.cof文件，修改参数配置
max_allowed_packet=1M 改为 max_allowed_packet=700M 大小自定，够用就行
修改完毕后重启mysql服务
service mysql restart
进入mysql查看是否成功
show variables like ‘%max_allowed_packet%’;
再进行导入，OK