- 本机mysql设置的max_allowed_packet是4m;但是新版的sql内有超过4m的字段,所以报错
Got a packet bigger than 'max_allowed_packet' bytes
- 解决方法:
set global max_allowed_packet = 30*1024*1024
执行该命令后,可临时调整max_allowed_packet大小,导入成功.
Got a packet bigger than 'max_allowed_packet' bytes
set global max_allowed_packet = 30*1024*1024
执行该命令后,可临时调整max_allowed_packet大小,导入成功.