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

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

Print



Esto me paso despued de pasar de Mysql a Maria DB, al tratar de crear un procedimiento.
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
' Fuente: http://webcheatsheet.com/sql/Fix_Cannot_load_from_mysql.proc._The_table_is_probably_corrupted.php

Saludos
Adalberto Montanía

Comentarios