Home page
 
 Home 
 ASP 
 PHP 
 SQL 
 HTML 
 JavaScript 
 Search 
 Contact 
 
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.

Privacy Policy

RSS Twitter

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

Print

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: Add to dzone dzone | Digg this digg | Add to del.icio.us del.icio.us | Stumble it stumbleupon

  • Comments





Copyright © 2005-2014             www.WebCheatSheet.com All Rights Reserved.