MySQL will sometimes return the error message “Cannot load from mysql.proc. The table is probably corrupted”. This happens due to schema changes required for different MySQL server versions. The simple fix to this problem is to run the mysql_upgrade command from the command line.
About mysql_upgrade
mysql_upgrade examines all tables across all databases for incompatibilities with the current version of MySQL Server. mysql_upgrade also upgrades the system tables so that you can take advantage of new privileges or capabilities that might have been added.
mysql_upgrade should be executed each time you upgrade MySQL. It supersedes the older mysql_fix_privilege_tables script, which should no longer be used.
mysql_upgrade executes the following commands to check and repair tables and to upgrade the system tables:
mysqlcheck --all-databases --check-upgrade --auto-repair
mysql < fix_priv_tables
Run mysql_upgrade From Command Line
To use mysql_upgrade, make sure your MySQL server is running and then invoke mysql_upgrade from the command line tool:
mysql_upgrade -uroot -p --force
You should then be prompted to enter the MySQL root's password and mysql_upgrade will check all the databases and tables and fix them where appropriate. You may need to specify the full path to the above command if it's not in the shell's search path.
On Debian 6 it should be loacted at:
/usr/bin/mysql_upgrade -uroot -p --force
On Mac's MAMP the default path is:
/Applications/MAMP/Library/bin/mysql_upgrade -uroot -p --force
On Windows it'll be where MySQL is installed and contained in the bin subdirectory. By default it should be located at:
"C:\Program Files\MySQL\MySQL Server\[*CHANGE TO MySQL SERVER*]\bin\mysqladmin" -u root shutdown
VICTORY!
After running mysql_upgrade, stop the server and restart it so that any changes made to the system tables are ensured to take effect.
All checked and repaired tables are marked with the current MySQL version number. This ensures that next time you run mysql_upgrade with the same version of the server, it can tell whether there is any need to check or repair the table again.
Pingback: » MySQL 5.1.x升级到MySQL 5.5.x [Java堂]
Hi,
I have same problem but my mysql tables are working properly . but in database stored procedures are showing this type of problem.
And Other thing is my server is shared server on internet how can i use its command line .
Pingback: nothingOS » MySQL : Cannot load from mysql.proc. The table is probably corrupted
I’m getting this error in MySQL Workbench, however there does not appear to be any errors in phpmyadmin. Also, I do have a functional instance of wordpress installed here. I ran the terminal commanded suggested above and I got an error “-bash: mysql_upgrade: command not found”.
Any ideas?
Wow ! Generally great Article … Thank you for the information
Pingback: How To Fix Error In Uploading Cannot Load Library Errors - Windows Vista, Windows 7 & 8
Hi,
Thanks for the post.
I would like to add one small note.
You may not require to restart MySQL server after upgrade.
Regards,
Viswa.
Hi,
I have run mysql_upgrade -uroot -p –force but phpmyadmin still show that mysql.proc error.
I upgraded mysql(from 5.1 to 5.6) and I would like to import an export sql file back. But in export file is some function which makes me this. Can you help me?
Thanks!!!
It’s really helpful, thanks!!!
Saved my day. Well written. Thanks!!
Worked like a charm, thanks!
Thanks Bro ,,, Saved my day
Wow really nice thank you for posting related with the Mysql. And please keep update like this
Most of the time mysql gives this error.
please help, ERROR 1805 (HY000): Column count of mysql.user is wrong. Expected 45, found 46. The table is probably corrupted
after use mysql> ALTER USER USER() IDENTIFIED BY ‘password’;
mysql_upgrade: Got error: 1862: Your password has expired. To log in you must change it using a client that supports expired passwords. while connecting to the MySQL server
Upgrade process encountered error and will not continue.
i can’t fix tables because show this error again and again, please any idea i have a broken mysql in ubuntu and i need all the database on the server 🙁 i don’t have a backup of this, help me
I using navicat and get this error :
[DTF] Getting functions
[ERR] 1548 – Cannot load from mysql.proc. The table is probably corrupted
[DTF] Finished unsuccessfully
How to resolve it?
WOWW!!! It works! Thanks for this post, it really helped me!
my mysql version on server 1 is 5.6 and on server 2 also 5.6. but on server 1 there is an error “Cannot load from mysql.proc. The table is probably corrupted” where on server 2 there is no error like that.
why?
i have updated MariaBD, and i cannot revert myDB. Thank for your post.
best article thanks
Get all seo top submission sites. Her all top sites provide the on-page or offpage activities list and also discrible the seo tools which make your seo easier
very good content. Thank you
MeluhaTN provides online coaching for competitive exams. Our success rate is far ahead of Tamil Nadu’s student performance at JEE and NEET, which is at 13% for JEE and 39% in NEET. Our success is result of many factors: We provide NEET COACHING ONLINE & JEE COACHING ONLINE. Get Free Trial ACCESS NOW
visit https://Meluhatn.com
Pingback: Slurm 18.08 with QOS mariadb problems on CentOS 7 | Bits and Dragons
Thank you for sharing your article its really informative.
Pingback: Como revolver problemas de base de dados corrompida no MySQL/Maria DB | Mastigado