mysqldump: Error 2020: Got packet bigger than ‘max_allowed_packet’ bytes when dumping table `PLUGINDATA` at row: 5
在使用mysqldump备份数据时报出:
mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `PLUGINDATA` at row: 5
解决办法:
在/etc/my.cnf 配置文件中,将max_allowed_packet的值加大,然后重启mysql服务。
[mysqldump]
quick
max_allowed_packet = 100M
共有 0 条评论