출처 : http://webcheatsheet.com/sql/Fix_Cannot_load_from_mysql.proc._The_table_is_probably_corrupted.php



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


'Development > DataBase' 카테고리의 다른 글

MySQL Slow Query Log 설정  (0) 2015.01.14
MySQL & MariaDB 이벤트 스케쥴러 사용  (0) 2014.08.21
MySQL & MariaDB Procedure 생성 및 권한  (0) 2014.07.10
MySQL character set (한글 깨짐)  (0) 2014.06.03
MySQL SQLSTATE Error Codes  (0) 2014.05.14
안정적인 DNS서비스 DNSEver DNS server, DNS service
Posted by 키르히아이스

댓글을 달아 주세요