Plesk Onyx for Linux
kb: fixed
kb: bug
ABT: Group B
Applicable to:
- Plesk Onyx for Linux
Symptoms
- 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
andwait_timeout
were already increased in/etc/my.cnf
# cat /etc/my.cnf
[mysqld]
max_allowed_packet=2048M
wait_timeout = 1200
Cause
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)
Resolution
Please consider updating your server:
Workaround
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
Comments
0 comments
Please sign in to leave a comment.