ERROR 1548 (HY000): Cannot load from mysql.proc. The table is probably corrupted

mysql> SHOW FUNCTION STATUS ;

ERROR 1548 (HY000): Cannot load from mysql.proc. The table is probably corrupted

mysql> check table mysql.proc;

+------------+-------+----------+----------+

| Table      | Op    | Msg_type | Msg_text |

+------------+-------+----------+----------+

| mysql.proc | check | status   | OK       |

+------------+-------+----------+----------+

1 row in set (0.01 sec)

日誌檔案中：

150820 18:00:57 [ERROR] Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64).

CREATE TABLE `proc` (

  `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',

  `name` char(64) NOT NULL DEFAULT '',

  `type` enum('FUNCTION','PROCEDURE') NOT NULL,

  `specific_name` char(64) NOT NULL DEFAULT '',

  `language` enum('SQL') NOT NULL DEFAULT 'SQL',

  `sql_data_access` enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL DEFAULT 'CONTAINS_SQL',

  `is_deterministic` enum('YES','NO') NOT NULL DEFAULT 'NO',

  `security_type` enum('INVOKER','DEFINER') NOT NULL DEFAULT 'DEFINER',

  `param_list` blob NOT NULL,

  `returns` longblob NOT NULL,

  `body` longblob NOT NULL,

  `definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',

  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',

  `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') NOT NULL DEFAULT '',

  `comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',

  `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,

  `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,

  `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,

  `body_utf8` longblob,

  PRIMARY KEY (`db`,`name`,`type`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures' |

這是當前庫的。

找一個正常的庫

 `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

 

 

 看來是需要 mysql_upgrade