Unable to export mysql database in Plesk GUI: mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table

Robert Asilbekov

Updated January 25, 2021 12:57

Plesk Onyx for Linux kb: fixed kb: bug ABT: Group B

Applicable to:

Unable to export mysql database in Subscriptions > example.com > Databases > Export Dump

PLESK_ERROR: Unable to export a dump of database_name:
mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `table` at row: 13458
max_allowed_packet and wait_timeout were already increased in /etc/my.cnf in both [mysqld] and [mysqldump] sections

# cat /etc/my.cnf
[mysqld]
max_allowed_packet=1024M
wait_timeout = 1200
[mysqldump]
max_allowed_packet=1024M

Product issue:

#PPPM-10773 "It’s possible to customize MySQL variables used by database export and import via the server-wide my.cnf."
Fixed in:
- Plesk Obsidian 04 August 2020 (Linux)

Please consider updating your server:

There are three workarounds.

Workaround 1

Login to the server via SSH.
Create backup of /usr/local/psa/lib/modules/python/dbbackup/dbbackup.py

# cp -a /usr/local/psa/lib/modules/python/dbbackup/dbbackup.py /usr/local/psa/lib/modules/python/dbbackup/dbbackup.orig
Modify /usr/local/psa/lib/modules/python/dbbackup/dbbackup.py:

# sed -i "s/'mysqldump', '--no-defaults',/'mysqldump', '--no-defaults', '--max_allowed_packet=1GB',/g" /usr/local/psa/lib/modules/python/dbbackup/dbbackup.py

Click on a section to expand

Workaround 2

Login to Plesk.
Export database using phpMyAdmin: Subscriptions > example.com >Databases > phpMyAdmin for "database_name" > Export > GO

Click on a section to expand

Workaround 3

Login to the server via SSH.
Backup database manually:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -uadmin "database_name" --max_allowed_packet=1024M > /root/database_name.sql