当从mysql数据导出数据文件 .sql文件后,再导入时出现错误
There was error(s) while executing the queries .
The query and the error message has been logged at:C:\Users\Administrator\AppData\Roaming\SQLyog\sqlyog.err.
Please click on "Open Error File..." to open the error file.
解决方法:
打开my.ini文件 在[mysqld]下面写上如下配置:
max_allowed_packet=1024M:查询最大缓存
wait_timeout=288000:决定的是非交互连接的时间长短
interactive_timeout = 288000:决定的是交互连接的时间长短