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/8nGfvmdsI2 From Carnivore Diet to Near-Death: Lessons Learned From Today's Most Popular Fad Diet

Shaun Freeman @Zendmaster

I liked a @YouTube video https://t.co/EFLh2y3I24 Carnivore Diet – Myths about Meat – Phil Escott – WHIS 2018

Shaun Freeman @Zendmaster

I liked a @YouTube video https://t.co/dTcBFM4q5A WHY I STOPPED BEING VEGAN | MY STORY

Shaun Freeman @Zendmaster

I liked a @YouTube video https://t.co/RVuVCieSsD Dr. Paul Mason - 'Low Carb from a Doctor's perspective'

Shaun Freeman @Zendmaster

I added a video to a @YouTube playlist https://t.co/MFRRuBG23F It's Already Too Late - Elon Musk