Fixing MySQL error “Cannot load from mysql.proc. The table is probably corrupted”
After a recent upgrade of some of my CentOS 6.3 servers to MySQL 5.5 from the Remi repository, I started noticing errors like this one in the logs, especially during backups:
MySQL: SHOW FUNCTION STATUS WHERE Db = ‘name’: Cannot load from mysql.proc. The table is probably corrupted
A quick search revealed that this is do to ‘mysqld_upgrade’ script not being run automatically against the existing database. A quick and simple solution is to just run the script manually. Of course, a full database backup is recommended before doing so. Mine worked just fine though.