mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' when dumping table xxx

[pczartoryski]

I got error while taking backup of db:

mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' when dumping table xxx

I have configured mysql like this :

[mysqld]
max_allowed_packet = 1073741824

[mysqldump]
max_allowed_packet = 1073741824

and restarted , but no effect.

When I check in mysql max_allowed_packet value - it is correct - as described above.

There is also no problem with making dump of this mysql database (enginge=InnoDb in case it matters) by software like Adminer .

Am I doing something wrong or library is not using this mysql configuration while taking backups ?

[pczartoryski]

Yes, it looks like DbDumper is creating own mysql config so max_allowed_packet is ignored from global MySQL configuration.

It would be nice if we could pass this option through config/databases.php like the other options.

It also works fine when we use mysqldump CLI command with added --max_allowed_packet=1073741824

[pczartoryski]

As a quick workaround I found it possible by setting config/databases.php like this :

'mysql' => [
  dump' => [
    'addExtraOption' => '--max_allowed_packet=1073741824',
  ]
]