Tag: databases

–i-am-a-dummy

Here is a handy command-line option for MySQL client: –i-am-a-dummy, or, if you don’t have a sense of humor, –safe-updates.  When used, this will prevent updating or deleting rows without explicitly specifying a WHERE clause.  It will also limit the number of SELECT and JOIN results.

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.