Need Help?

Support Team

24/7 Helpdesk:

24/7 Support Email:

Sales Team

Sales Email:

Billing Team

24/7 Client Area:

Billing Email:

Column count of mysql.proc is wrong

Advanced Backup Manager for cPanel - More Information
Post Reply
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 '----_wordpress' (Engine: MySQL)...FAILED
[13 March 2019 11:44:08 PM -0300] [ERROR] mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = '----_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)


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

Staff Member
Staff Member
Posts: 41
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`)


Post Reply