Error Dumping mysql databse

cPanel, Industry leading hosting platform with world-class support.
Post Reply
ludolugo
Posts: 52
Joined: April 17th, 2020, 10:40 am

Error Dumping mysql databse

Post 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
JetappsCris
Staff Member
Staff Member
Posts: 33
Joined: December 1st, 2021, 2:12 am

Re: Error Dumping mysql databse

Post 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.
Best Regards,
Cristofer, JetApps Team
ludolugo
Posts: 52
Joined: April 17th, 2020, 10:40 am

Re: Error Dumping mysql databse

Post 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
JetappsCris
Staff Member
Staff Member
Posts: 33
Joined: December 1st, 2021, 2:12 am

Re: Error Dumping mysql databse

Post 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]
Best Regards,
Cristofer, JetApps Team
ludolugo
Posts: 52
Joined: April 17th, 2020, 10:40 am

Re: Error Dumping mysql databse

Post by ludolugo »

great, that did it
thanks
Post Reply