Add --max-allow-packet to backup script
Posted: Tue Aug 08, 2017 12:59 pm
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.
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.