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

I liked a @YouTube video https://t.co/lSFWmpHTX1 Patrick Stewart talks about meeting Sting on the set of DUNE (Funny to the EXTREME)

Shaun Freeman @Zendmaster

I added a video to a @YouTube playlist https://t.co/pmXSmod4ti Anonymous - This will Change Everything You Know... (2018-2019)

Shaun Freeman @Zendmaster

I added a video to a @YouTube playlist https://t.co/GkwTCvBfes Will Artificial Intelligence Take Over The World?

Shaun Freeman @Zendmaster

I liked a @YouTube video https://t.co/Y1ulafmsC6 Frank Abagnale: "Catch Me If You Can" | Talks at Google

Shaun Freeman @Zendmaster

I liked a @YouTube video https://t.co/NBdW2xFnqD ETS2: Special Transport DLC Trailer