The table mysql.proc is missing, corrupt, or contains bad data
After my latest upgrade of MySQL on my Fedora 11 install, I started getting errors like this every time my database tried to run a stored procedure or function:
As it turns out, the latest upgrade required that the database schema by updated afterwards and I hadn't done this. So if you're getting these errors, here are the commands I ran to fix the problem:
1) Run mysql_upgrade (this will upgrade your tables and data)
2) Run mysqlcheck --check-upgrade --all-databases --auto-repair (this will repair things broken during the upgrade).
3) Run service mysqld restart (this will restart the database).
After I ran these commands my database was working again and running stored procedures and functions with the "The table mysql.proc is missing, corrupt, or contains bad data" error.
The table mysql.proc is missing, corrupt, or contains bad data
As it turns out, the latest upgrade required that the database schema by updated afterwards and I hadn't done this. So if you're getting these errors, here are the commands I ran to fix the problem:
1) Run mysql_upgrade (this will upgrade your tables and data)
2) Run mysqlcheck --check-upgrade --all-databases --auto-repair (this will repair things broken during the upgrade).
3) Run service mysqld restart (this will restart the database).
After I ran these commands my database was working again and running stored procedures and functions with the "The table mysql.proc is missing, corrupt, or contains bad data" error.
| Rating: | 100% positive, 1 Vote |
| Categories: | MySQL repair database |
| Added: | on Oct 01, 2009 at 10:07 pm |
| Added By: | an anonymous user |
| Searches: | database mysql repair run data |
