How to increase max_allowed_packet in mysqldump?

kumkumsharma

Administrator
Staff member
You can increase the max_allowed_packet in my.cnf file. You have to edit my.cnf file and add below line in my.cnf file.

First you have to find [mysqldump] section in /etc/my.cnf file and then add below code :

Code:
[mysqldump]
max_allowed_packet=268435456
You can add value according to your choice.
 
Top