mysql 导入报错

2023年5月23日15:14:59 发表评论 901 views

报错呢内容:

ERROR 1153 (08S01) at line 3428: Got a packet bigger than 'max_allowed_packet' bytes

设置最大导入限制(我的文件是40G,旧设置成50G)

set global max_allowed_packet = 50*1024*1024*1024;

然后使用命令导入:

mysql -h 192.168.43.199 -P 3306 -u root -p rules < ./law20230508.sql

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: