# Upgrade v9.6 to v10.5 and mysqlDB migration failure

**URL:** <https://forum.mattermost.com/t/upgrade-v9-6-to-v10-5-and-mysqldb-migration-failure/22803>\
**Category:** Uncategorized\
**Created:** [March 12, 2025, 6:53pm UTC](https://forum.mattermost.com/t/upgrade-v9-6-to-v10-5-and-mysqldb-migration-failure/22803 "2025-03-12T18:53:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gstlouis](https://avatars.discourse-cdn.com/v4/letter/g/e36b37/32.png) [@Gstlouis](https://forum.mattermost.com/u/Gstlouis)\
**Post date:** [March 12, 2025, 6:53pm UTC](https://forum.mattermost.com/t/upgrade-v9-6-to-v10-5-and-mysqldb-migration-failure/22803/1 "2025-03-12T18:53:53Z")

</div>

I am coming from MM version 9.6 upgrading to 10.5. Last upgrades were a breeze, which I love, but my neglect to upgrade lately and having to jump to 10.5, just doing the simply upgrades failed because there are DB changes. Jumping the gun!

Anyway, after reading the [important-upgrade-notes]. ([Important Upgrade Notes - Mattermost documentation](https://docs.mattermost.com/upgrade/important-upgrade-notes.html))  
I can see there are changes in the DB, and I would like to know if I did this correctly. IT did work, but needed a little extra `mysql_upgrade -root -p` at the end because there was a complaint in the logs when I tried to `systemctl start mattermost`

> Cannot load from mysql.proc. The table is probably corrupted

I took the db commands from v10.6 in the ‘important-upgrade-notes’, vim them in a file.sql and did `mysql -uroopt -p mattermost < file.sql`, which did target the mattermost db and created the new tables with ect.

But once I continued with the upgrade steps, it still crashed with the error above. Only searching online about ‘Cannot load from mysql.proc. The table is probably corrupted’ led me to run `mysql_upgrade -root -p`. All is good.

I can’t be the only one running into this? And what exactly happens here, mysql refreshes its cache of tables so starting mattermost will read them properly? I am curious…

Sucks that V11 you need to use psql cause I was just fine with mysql, even though I’m sure psql will probably introduce performance improvements.

---

<div class="post-metadata">

**Author:** ![john.oliver](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mattermost.com/john.oliver/32/6436_2.png) [@john.oliver](https://forum.mattermost.com/u/john.oliver)\
**Post date:** [March 12, 2025, 9:41pm UTC](https://forum.mattermost.com/t/upgrade-v9-6-to-v10-5-and-mysqldb-migration-failure/22803/2 "2025-03-12T21:41:58Z")

</div>

Our recommended upgrade strategy is to get to the first available ESR (9.11.9) and then go to 10.5.1