Need Help?

Support Team


24/7 Helpdesk:
helpdesk.jetapps.com


24/7 Support Email:
support@jetapps.com



Sales Team


Sales Email:
sales@jetapps.com



Billing Team


24/7 Client Area:
billing.jetapps.com


Billing Email:
billing@jetapps.com


Column count of mysql.proc is wrong

Advanced Backup Manager for cPanel - More Information
Post Reply
CaraquetFlyer
Posts: 1
Joined: March 14th, 2019, 7:28 pm

Column count of mysql.proc is wrong

Post by CaraquetFlyer » March 14th, 2019, 7:35 pm

I have installed and tried my first manual backup but none of the MySQL databases are being backup because of an error. Can someone help me out on how to fix the issue?

Code: Select all

[13 March 2019 11:44:06 PM -0300] Grabbing...
[13 March 2019 11:44:06 PM -0300] Dumping Database 'xxxxxx_wordpress' (Engine: MySQL)...FAILED
[13 March 2019 11:44:08 PM -0300] [ERROR] mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'xxxxxx_wordpress'': Column count of mysql.proc is wrong. Expected 21, found 20. The table is probably corrupted (1805)
Using WHM/cPanel 78.0.17 and MariaDB 10.3 (10.3.13-MariaDB)

Thanks!

cosmin
Posts: 1
Joined: March 15th, 2019, 10:55 am

Re: Column count of mysql.proc is wrong

Post by cosmin » March 15th, 2019, 10:56 am

Try this from console before:

# mysqlcheck -A --auto-repair

Or try with Repair from phpMyAdmin

ofir
Staff Member
Staff Member
Posts: 36
Joined: June 14th, 2018, 10:03 am

Re: Column count of mysql.proc is wrong

Post by ofir » March 17th, 2019, 8:41 am

Hi Cosmin,

Thank you for sharing your issue with us.

Can you please try to execute a regular bash dump to the database and share the screen with us?
(The DB can be dump by: `mysqldump DB_NAME > DB_NAME.sql`)

Regards.

Post Reply