Skip to main content

How to raise the max_allowed_packet limit for 'mysqldump'.

Violet Browning
  • Updated

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.

Related articles