We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
How make to work mysqldump variable.
How make to work mysqldump variable.
I want to know how i can use [mysqldump].
The problem i have is i'm getting "mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet'"
I'm trying to put in my.cnf but not work
When i try to run cli mysqldump always give me same error.
But when i try to run works
Any ideas what is going on?
The problem i have is i'm getting "mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet'"
I'm trying to put in my.cnf but not work
Code: Select all
[mysqldump]
max_allowed_packet=64M
Code: Select all
mysqldump --defaults-file=/usr/local/vesta/conf/.mysql.localhost --single-transaction USER_db1 > db.sql
mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `wp_postmeta` at row: 870
Code: Select all
mysqldump --defaults-file=/usr/local/vesta/conf/.mysql.localhost --max_allowed_packet=64M --single-transaction USER_db1 > db.sql
Re: How make to work mysqldump variable.
Add to comand --max_allowed_packet=512M or needle size.
Example
Example
Code: Select all
mysqldump --defaults-file=$mycnf --max_allowed_packet=512M --single-transaction -r $1 $2 2> $err