Got a packet bigger than ‘max_allowed_packet’ bytes

今天把mysql数据库重新初始化后,用phpMyAdmin导入之前备份的数据库遇到错误:
Got a packet bigger than ‘max_allowed_packet’ bytes

修改/etc/my.cnf max_allowed_packet = 16M
一般情况下,服务器默认max-allowed-packet为1MB

重启,重新导入即可

未经允许不得转载:ganlei的个人博客 » Got a packet bigger than ‘max_allowed_packet’ bytes

赞 (0)
分享到:更多 ()