Cannot load from mysql.proc. The table is probably corrupted
Posted February 22nd, 2012 in MySql
I mistyped the name of an internal MySQL function in some code this morning and got back the error message "Cannot load from mysql.proc. The table is probably corrupted" which appeared to have no bearing on the actual error. The simple fix to this problem is to run the mysql_upgrade command.
From the command line (you won't be able to do this from a tool like phpMyAdmin) run the command line tool mysql_upgrade passing like so:
mysql_upgrade -u root -p
Then enter the root's password and it will check all the databases and tables and fix them where appropriate. You may need to specify the full path to the above command if it's not in the shell's search path.
On Debian 6 it's at /usr/bin/mysql_upgrade
On Mac MAMP /Applications/MAMP/Library/bin/mysql_upgrade
On Windows it'll be where-ever MySQL is installed in the bin subdirectory. You'll need to open up the command prompt, change to that directory and then run mysql_upgrade.exe -u root -p
Now that I'd upgraded the databases I got a much better error message which was related to the error I'd created: "FUNCTION [dbname].[function name] does not exist"
Before running a command like this on a production server, it's always a good idea to take a full backup of all databases first, just in case something goes wrong.
- MySQL error can't open file - errno: 24 (Tuesday, March 3rd 2015)
- MySQL "Incorrect key file for table /tmp/#sql_xxx_x.MYI" error (Friday, June 1st 2012)
- MySQL table is marked as crashed and should be repaired (Tuesday, August 2nd 2011)
- MySQL utility commands (Wednesday, December 30th 2009)
- MySQL "Incorrect key file for table" error (Wednesday, June 24th 2009)