SOLVED: issue with zmupdate.pl mysql.proc. The table is probably corrupted

Forum for questions and support relating to the 1.34.x releases only.
Post Reply
Daylights
Posts: 13
Joined: Tue Oct 02, 2018 11:24 am

SOLVED: issue with zmupdate.pl mysql.proc. The table is probably corrupted

Post by Daylights »

I just wanted to post this so it may save others a lot of time in the future.

I'm using Zoneminder in a docker image, with MariaDb in another docker image. All working fine, but when I tried to upgrade the image to 1.34, there was an issue with running zmupdate.pl inside the image:

ERROR 1728 (HY000) at line 117: Cannot load from mysql.proc. The table is probably corrupted
Output:
Command 'mysql -h192.168.1.100 -uzmuser -p"<password>" zm < /usr/share/zoneminder/db/zm_update-1.33.7.sql' exited with status: 1

Eventually I stumbled upon this article for the Windows MySQL version:

https://www.myguysolutions.com/2013/10/ ... corrupted/

So after running the following from the MariaDB container:
mysqlcheck --databases zm -u root -p --check-upgrade --auto-repair
mysql_upgrade -u root -p

All databases were upgraded and I could upgrade to 1.34 using the zmupdate.pl script :D
Post Reply