Page 1 of 1

Error Dumping mysql databse

Posted: January 28th, 2022, 1:00 pm
by ludolugo
Hi,
we are having an error when dumping database for backup, the error sais:

Code: Select all

Got packet bigger than 'max_allowed_packet' when dumping table `wp_options` at row 368
We have increased the max_allowed_packet to 2147483648 but keep getting this error, is there another configuration in jetbackup that we have to be aware? the table is 48mb so it's not a big table

Re: Error Dumping mysql databse

Posted: February 1st, 2022, 7:20 am
by JetappsCris
Hi ludolugo,

Thank you for reaching out to us. This error (Got packet bigger than 'max_allowed_packet' bytes when dumping table) usually occurs when taking the backup of the large database. Can I ask where you changed your max allowed packets? Can you check if it was via our UI: Jetbackup >> settings >> Performance >> MySQL Dump max allowed packet

If this is where you made the change, please feel free to open a ticket with our 24/7 support team so our team can further investigate the issue.
We hope to hear from you soon.

Re: Error Dumping mysql databse

Posted: February 7th, 2022, 4:56 pm
by ludolugo
great!, i dind't see that option in jetbackup 5, now it seems to be solved using 1gb.
I see another error in mysql:

Code: Select all

[ERROR] Failed fetching MySQL/PGSQL default user. Error: yaml file not found

Re: Error Dumping mysql databse

Posted: February 8th, 2022, 5:41 am
by JetappsCris
Hi ludolugo,

We are glad to hear your previous issue was resolved.

As for your current error: If you are facing this when trying to make backups, we have had similar tickets with that error.
In most of them, we have found that grants_<username>.yaml file for the problematic account is missing at /var/cpanel/databases/

Can you check in your logs for the failing account and investigate if that specific account is missing the file mentioned above?
If this is not the cause of the issue, please feel free to open a ticket with our 24/7 support team at [email protected]

Re: Error Dumping mysql databse

Posted: February 10th, 2022, 6:00 pm
by ludolugo
great, that did it
thanks