Add --max-allow-packet to backup script

[nelblack]

Hi all,

Does anyone knows how to add the parameter ''--max_allowed_packet=512M'' into the daily backup script? our database is too large and getting fail by daily backup, we used mysqldump with ''--max_allowed_packet'' and get backup successful in shell command. so we expect to add the parameter to resolve our problem.

[skamasle]

Why not add it directly to your my.cnf in /etc/mysql ?

This will solve issue, because not is a mysqldump problem, is a mysql limit