MySQL: SHOW FUNCTION STATUS WHERE Db = ‘name’: Cannot load from mysql.proc. The table is probably corrupted

Mattias Geniar, Monday, June 25, 2012

If you recently upgraded from a MySQL 5.0 or 5.1 to the latest MySQL 5.5, you can run into the following error in logs/back-up scripts.

mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db ='something'': Cannot load from mysql.proc. The table is probably corrupted (1548)
mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'somethingelse'': Cannot load from mysql.proc. The table is probably corrupted (1548)
...

The reason why is because MySQL 5.5 provided an update to the schemas, which are not automatically applied to already existing databases. To provide that schema update, it's important to run the MySQL upgrade command, as it also helps with missing tables or prefixed tables.

The command is run as follows.

$ mysql_upgrade

If you're getting an access denied error, pass along the username + password.

$ mysql_upgrade
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
FATAL ERROR: Upgrade failed
$ mysql_upgrade -u root -p

That should solve your problem. If it does not, have a look at your MySQL logfiles for more indications.



Hi! My name is Mattias Geniar. I'm a Support Manager at Nucleus Hosting in Belgium, a general web geek & public speaker. Currently working on DNS Spy & Oh Dear!. Follow me on Twitter as @mattiasgeniar.

Share this post

Did you like this post? Will you help me share it on social media? Thanks!

Comments

Mark Thursday, December 13, 2012 at 08:05 - Reply

Thanks a ton!
My Virtualmin backups weren’t working because of corrupt tables.

But your solution fixed it, thanks again!


Nataraj Thursday, March 21, 2013 at 18:57 - Reply

save my time..thank you ..


Waco Saturday, July 26, 2014 at 17:23 - Reply

Thank you very much. It helps :)


Ninad Chandorkar Wednesday, December 16, 2015 at 14:50 - Reply

Hey man it worked. Hats off to you. Thanks


zBackup.vn Monday, April 18, 2016 at 04:50 - Reply

Great! I help me fix backup of MySQL databases. Tks a lot!


Paul Friday, November 10, 2017 at 08:47 - Reply

I also had problems backing up a server until I found your hint. Thanks


Jerri Adriano Godinho Monday, October 8, 2018 at 18:23 - Reply

Thank you guy!
Solve my problem and save my time.


jay Sunday, November 25, 2018 at 20:50 - Reply

thank you that worked!!!!


Leave a Reply

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