CODEWITHSUNDEEP
mysql
sumit
sumit

Reputation: 112

Error occur after upgrading MySql from 5.1 to 5.6.10 while restore the dump file

Error 1728 at line 3 :cannot load from mysql.proc the table is corrupted

That Error appears after upgrading the MySql version. I am upgrading From 5.1 to 5.6.10. The error appears when I try to restore the dump file.

Upvotes: 1

Views: 2252

Answers (1)

kristinalim
kristinalim

Reputation: 3459

Run mysql_upgrade. AFAIK, this is a standard MySQL upgrade step.

From MySQL 5.6 upgrade instructions:

After upgrading to a new version of MySQL, run mysql_upgrade (see Section 4.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”). This program checks your tables, and attempts to repair them if necessary. It also updates your grant tables to make sure that they have the current structure so that you can take advantage of any new capabilities. (Some releases of MySQL introduce changes to the structure of the grant tables to add new privileges or features.)

Upvotes: 4

Related Questions