Fixing MySQL error “Cannot load from mysql.proc. The table is probably corrupted”

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.

Leave a Reply