Page 1 of 1

Column count of mysql.proc is wrong

Posted: March 14th, 2019, 7:35 pm
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!

Re: Column count of mysql.proc is wrong

Posted: March 15th, 2019, 10:56 am
by cosmin
Try this from console before:

# mysqlcheck -A --auto-repair

Or try with Repair from phpMyAdmin

Re: Column count of mysql.proc is wrong

Posted: March 17th, 2019, 8:41 am
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.