DirectAdmin backup: Got packet bigger than 'max_allowed_packet'

Hosting Kernel

Verified User
Joined
Sep 30, 2015
Messages
126
Hi,

I config my server to run daily backup, recently I get this error:
mysqldump error output: mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table...
I increased "max_allowed_packet" even to 1G but does not work.

Any help ?
 

Richard G

Verified User
Joined
Jul 6, 2008
Messages
4,267
Location
Maastricht
I Googled it for you and found a similar issue on another site, also with increasing the packet size without solution.
Maybe it can be of help to you:

I had a similar error and would fail with packet size 512M on row 0. It was an innodb table that was apparently damaged (mysqlcheck showed OK). I ended up re-creating the table and then it worked fine with a small packet size of just 128M.
Where or how did you increase the size to 1G?
 

Richard G

Verified User
Joined
Jul 6, 2008
Messages
4,267
Location
Maastricht
Ah oke, you probably don't have Centos 6 then.
Looks good.
Maybe recreating the table like the post said can fix it then?
Can't imagine a table being that big.
 

Hosting Kernel

Verified User
Joined
Sep 30, 2015
Messages
126
Hi,

Finally I know what the problem is. I set max_allowed_packet in [mysqldump] section, not in [mysqld] and now it works fine.
 

Richard G

Verified User
Joined
Jul 6, 2008
Messages
4,267
Location
Maastricht
Ah I thought you had that in /etc/my.cnf.d/server.cnf set under mysqld.

Anyway, good you've fixed it!
 
Top