Fix: Cannot load from mysql.proc. The table is probably corrupted

Search

or browse popular tags

Subscription

Sign up for the free email newsletter for new tips, tutorials and more. Enter your email address below, and then click the button.

After upgrading MySQL from version 5.0 to 5.5 I started getting the following message trying to edit table structure in Navicat:

Cannot load from mysql.proc. The table is probably corrupted

Luckily there is an easy fix. Run the following command from the command prompt (on Windows you might need to run it from MySQL's bin directory).

mysql_upgrade

In some cases you will need specify mysql root password and --force option (if you run upgrade procedure already).

mysql_upgrade.exe -uroot -p --force

Tags:

Add To: dzone | digg | del.icio.us | stumbleupon