MySQL 5.5.39 SQL Errors 1547 & 1577

[expired user #8438]'s profile image [expired user #8438] posted 10 years ago in General Permalink
MySQL Version: 5.5.39

I got the following SQL errors 1547 and 1577.
Is it normal?

/* Delimiter changed to ; */
/* Connecting to **** via MySQL (TCP/IP), username ****, using password: Yes ... */
/* Connected. Thread-ID: 3 */
/* Characterset: utf8mb4 */
SHOW STATUS;
SHOW VARIABLES;
SHOW DATABASES;
USE `test`;
/* Entering session "****" */
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='test';
SHOW TABLE STATUS FROM `test`;
SHOW FUNCTION STATUS WHERE `Db`='test';
/* SQL Error (1547): Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted */
SHOW PROCEDURE STATUS WHERE `Db`='test';
/* SQL Error (1547): Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted */
SHOW TRIGGERS FROM `test`;
SHOW EVENTS FROM `test`;
/* SQL Error (1577): Cannot proceed because system tables used by Event Scheduler were found damaged at server start */


Thanks.
ansgar's profile image ansgar posted 10 years ago Permalink
You should repair your system tables:
REPAIR TABLE `mysql`.`event`;
REPAIR TABLE `mysql`.`proc`;

Please login to leave a reply, or register at first.