Introduction
A situation may arise in which you need to raise the max_allowed_packet limit for the 'mysqldump' command specifically.
Procedure
The mysqldump client will rely on a section in the /etc/my.cnf with this line:
[mysqldump]
In order to increase the max_allowed_packet limit for mysqldump, a '[mysqldump]' section needs to be created or added in the /etc/my.cnf file. If this section already exists, you can update the file to include the new value under the '[mysqldump]' line.
Here is an example of what it should look like when the edit is complete:
[mysqldump]
max_allowed_packet=268435456
The value '268435456' may vary depending on the situation and database in question.
Comments
0 comments
Article is closed for comments.