MySQL: Cannot load from mysql.proc. The table is probably corrupted

If you have upgrade the MySQL 5 to a later minor version say 5.1 to 5.5 then you can usually end up getting below error in the logs, or your backup system fails to take database backup giving below error
[plain]
SHOW FUNCTION STATUS WHERE Db = ‘servertechsupport’: Cannot load from mysql.proc. The table is probably corrupted
[/plain]

Solution:
It’ because MySQL upgrade didn’t updated the schemas. You can simply run the mysql_upgrade command to fix it.
[bash]
mysql_upgrade
[/bash]

If it’s giving access denied error then run the below command and enter the MySQL root password when asked.
[bash]
mysql_upgrade -u root -p
[/bash]


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *


one × 4 =