Fixing: Cannot load from mysql.proc

After updating my MySQL a little bit to 5.5.27, I got a problem after running mysqldump:

mysqldump: Couldn’t execute ‘SELECT /*!40001 SQL_NO_CACHE */ * FROM `PARAMETERS`’: Cannot load from mysql.proc. The table is probably corrupted (1548)

To fix this, simply run mysql_upgrade:

mysql_upgrade -u root -pPASSWORD

Then restart Mysql:

service mysqld restart

If you happen to get following error, you forgot to restart MySQL:

mysqldump: Error 1682: Native table ‘performance_schema’.’performance_timers’ has the wrong structure when dumping table `performance_timers` at row: 0

Menu