How make to work mysqldump variable.
Posted: Thu Mar 29, 2018 6:14 pm
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