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

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

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

Plesk export feature doesn't use /etc/my.cnf. This issue has been considered as a bug PPPM-10773 that will be fixed in future Plesk updates.

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" > /root/database_name.sql