Menu
I am starting to use MySQL Workbench tool especially for data modeling. So, the first I would like to do is reverse engineering of my existing database on web server. But I not able to finish the process, because I alway get this strange error message:
Error: Cannot load from mysql.proc. The table is probably corrupted I tried to repair this table but it not help me. So, do you have any experience with this problem and know how to solve it?
855
I mistyped the name of an internal MySQL function in some code this morning and got back the error message "Cannot load from mysql. proc. The table is probably corrupted" which appeared to have no bearing on the actual error. The simple fix to this problem is to run the mysql_upgrade command.
The mysql. proc table contains information about stored procedures and stored functions. It contains similar information to that stored in the INFORMATION SCHEMA.
mysql_upgrade saves the MySQL version number in a file named mysql_upgrade_info in the data directory. This is used to quickly check whether all tables have been checked for this release so that table-checking can be skipped. To ignore this file and perform the check regardless, use the --force option.
I'm using MySQL version 5.5.9 on MAC. I fixed this problem by running:
mysql_upgrade -uroot -p I'm using MySQL trough MAMP Pro, and Kevin's answer didn't work for me. Yes, I had to do a mysql upgrade BUT I had to use the following commands on the Terminal:
/Applications/MAMP/bin/repairMysql.sh /Applications/MAMP/bin/upgradeMysql.sh This worked for me. Hope this can be helpful to somebody else..
29
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
