Column count of mysql.proc is wrong

cPanel, Industry leading hosting platform with world-class support.
Post Reply
CaraquetFlyer
Posts: 1
Joined: March 14th, 2019, 7:28 pm

Column count of mysql.proc is wrong

Post by CaraquetFlyer »

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)

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

Re: Column count of mysql.proc is wrong

Post by cosmin »

Try this from console before:

# mysqlcheck -A --auto-repair

Or try with Repair from phpMyAdmin
ofir
Staff Member
Staff Member
Posts: 40
Joined: June 14th, 2018, 10:03 am

Re: Column count of mysql.proc is wrong

Post by ofir »

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