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
