}

MySQL: Error in query (1548): Cannot load from mysql.proc. The table is probably corrupted

Created:

The Error

Error in query (1548): Cannot load from mysql.proc. The table is probably corrupted

MySQL usually returns the error code 1548 when the database has incompatibility with the current version. The error is common after upgrade MySQL version (or trying to use older version with new database)

The Solution

You can execute mysqlcheck which will repair MySQL database:

mysqlcheck -r mysql proc -u root -p

If everythign is ok MySQL should output:

mysql.proc                                         OK

If the previous command fails you can try to execute mysql_upgrade:

mysql_upgrade -u root -p