How to solve MySQL Error: Cannot load from mysql.proc

How to solve MySQL Error: Cannot load from mysql.proc

I recently updated my MySQL server to MariaDB without removing the original databases and got this error 'Cannot load from mysql.proc. The table is probably corrupted'. It wasn't stopping me do anything but was very annoying.

So to fix it you need to do a check on all tables with:

mysqlcheck --all-databases --check-upgrade --auto-repair

Then force an mysql upgrade command with:

mysql_upgrade -uroot -p --force

Stop and restart the server and that's it, it should now be fixed.

I got this great info from My Guy Solutions where you will find more info on the problem.


17/01/2016 22:26:00 Shaun Freeman Filed Under: MySQL Linux, MySQL

Twitter Feed
Shaun Freeman @Zendmaster

Shaun Freeman @Zendmaster

Banished LP #1 - Humble Beginnings: https://t.co/5riUkijyLq via @YouTube

Shaun Freeman @Zendmaster

Installing Banished on Ubuntu 18.04: https://t.co/5judq1fMSc via @YouTube

Shaun Freeman @Zendmaster

Setting Up A Test Environment For PHP In VirtualBox - Part 4 Installing PHP: https://t.co/UDRLhjiJFb via @YouTube

Shaun Freeman @Zendmaster

Setting Up A Testing Environment For PHP Using VirtualBox - Part 4 Installing MySQL https://t.co/huVfEcr6jS

Shaun Freeman @Zendmaster

I liked a @YouTube video https://t.co/n8zIhpTH3I Windows Games on Linux with Valve's Proton - with The Linux Gamer