mysqldump的坑mysqldump报错Error 2020: Got packet bigger than ‘max_allowed_packet‘ bytes

MySQL版本5.5.47
mysqldump 导出命令 :

mysqldump -u${u}  -p${p} -h${h}  -R -E your_db_name > db_name.sql;

直接报错
mysqldump: Error 2020: Got packet bigger than ‘max_allowed_packet’ bytes when dumping table at row: 22
看配置文件my.cnf ， 登录mysql , show variables like ‘%max_allow%’;命令看到的也是1G

max_allowed_packet=1073741824

想把max_allowed_packet的值改大，看官方文档，max_allowed_packet的最大值就是1G，不能再大了

You must increa