在用Navicat导入SQL文件时报错：MySql 错误 Err [Imp] 1153 - Got a packet bigger than 'max_allowed_packet' bytes
查了一下，原来是MySQL默认读取执行的SQL文件最大为16M，我这个SQL文件260M，所以执行不过去
解决方法：
在MySQL安装目录下找到文件my.ini，搜索[mysqld]，在其下面添加一句话
max_allowed_packet=800M
重启MySQL服务
相关文章
- 【Mysql】[Err] 1153 - Got a packet bigger than 'max_allowed_packet' bytes
- Navicat 导入数据报错 --- 1153 - Got a packet bigger than 'max_allowed_packet' bytes
- Got a packet bigger than 'max_allowed_packet' bytes With statement Mysql终端数据同步不成功解决办法
- mysql:1153 Got a packet bigger than ‘max_allowed_packet’ bytes的解决方法
- mysql数据库导入sql文件时提示“Error Code: 1153 - Got a packet bigger than 'max_allowed_packet' bytes”解决办法
- MySql 错误 Err [Imp] 1153 - Got a packet bigger than 'max_allowed_packet' bytes
- 数据库执行sql报错Got a packet bigger than 'max_allowed_packet' bytes及重启mysql
- MySQL 导入外部数据时报错：1153: Got a packet bigger than 'max_allowed_packet' 解决方案
- ERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet' bytes怎么处理
- 运行SQL文件报错：Got a packet bigger than 'max_allowed_packet' bytes With statement: