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
in both[mysqld]
and[mysqldump]
sections
# cat /etc/my.cnf
[mysqld]
max_allowed_packet=1024M
wait_timeout = 1200
[mysqldump]
max_allowed_packet=1024M
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
Workaround
There are three workarounds.
- 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
- Login to Plesk.
- Export database using phpMyAdmin: Subscriptions > example.com >Databases > phpMyAdmin for "database_name" > Export > GO
Click on a section to expand
- 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
Comments
0 comments
Please sign in to leave a comment.