zoneminder upgrade from 1.34.26 to 1.35.11 (mysql db) stuck

For diagnostic purposes please provide the output that you receive for the commands

uname -a
lsb_release -crid
apt-cache policy zoneminder

Please see the following. Thanks

uname -a
Linux Xanadu-Server 5.4.0-100-generic #113-Ubuntu SMP Thu Feb 3 18:43:29 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux

lsb_release -crid
Distributor ID: Linuxmint
Description: Linux Mint 20
Release: 20
Codename: ulyana

apt-cache policy zoneminder
zoneminder:
  Installed: 1.37.11~20220218174430-focal
  Candidate: 1.37.11~20220218174430-focal
  Version table:
 *** 1.37.11~20220218174430-focal 500
        500 http://ppa.launchpad.net/iconnor/zoneminder-master/ubuntu focal/main amd64 Packages
        100 /var/lib/dpkg/status
     1.34.26-focal2 500
        500 http://ppa.launchpad.net/iconnor/zoneminder-1.34/ubuntu focal/main amd64 Packages
     1.32.3-2ubuntu2 500
        500 http://archive.ubuntu.com/ubuntu focal/universe amd64 Packages

You are wrong here for two reasons:

1.
This is support for Ubuntu only, and not for operating systems that are "based on Ubuntu" like Linux Mint.

Support for Linux Mint can be found at https://www.linuxmint.com/contactus.php and https://forums.linuxmint.com/

2.
The software that you are using is from a PPA.
For software in PPAs the full responsibility lies in the hands of the person or group providing that PPA.
In you case see the text in https://launchpad.net/~iconnor/+archive/ubuntu/zoneminder-master

"For questions and bugs with software in this PPA please contact Isaac Connor."

That's how I got here in the first place. I did what you are suggesting.

For those that may have stumbled in here like I did. The simple answer seems to have been to just move the problematic sql update file out of the way and the rest seems to have gone along without a hitch and zoneminder is back up and running quite well. Here is what I did.

/usr/share/zoneminder/db$ ls
manufacturers.sql zm_update-1.22.1.sql zm_update-1.29.0.sql zm_update-1.31.33.sql zm_update-1.33.15.sql zm_update-1.35.20.sql
models.sql zm_update-1.22.2.sql zm_update-1.30.0.sql zm_update-1.31.34.sql zm_update-1.33.16.sql zm_update-1.35.21.sql
triggers.sql zm_update-1.22.3.sql zm_update-1.30.1.sql zm_update-1.31.35.sql zm_update-1.33.1.sql zm_update-1.35.22.sql
zm_create.sql zm_update-1.23.0.sql zm_update-1.30.2.sql zm_update-1.31.36.sql zm_update-1.33.2.sql zm_update-1.35.23.sql
zm_update-0.0.1.sql zm_update-1.23.1.sql zm_update-1.30.3.sql zm_update-1.31.37.sql zm_update-1.33.3.sql zm_update-1.35.24.sql
zm_update-0.9.10.sql zm_update-1.23.2.sql zm_update-1.30.4.sql zm_update-1.31.38.sql zm_update-1.33.4.sql zm_update-1.35.25.sql
zm_update-0.9.11.sql zm_update-1.23.3.sql zm_update-1.31.0.sql zm_update-1.31.39.sql zm_update-1.33.5.sql zm_update-1.35.26.sql
zm_update-0.9.12.sql zm_update-1.24.0.sql zm_update-1.31.10.sql zm_update-1.31.3.sql zm_update-1.33.6.sql zm_update-1.35.27.sql
zm_update-0.9.13.sql zm_update-1.24.1.sql zm_update-1.31.11.sql zm_update-1.31.40.sql zm_update-1.33.7.sql zm_update-1.35.28.sql
zm_update-0.9.15.sql zm_update-1.24.2.sql zm_update-1.31.12.sql zm_update-1.31.41.sql zm_update-1.33.8.sql zm_update-1.35.29.sql
zm_update-0.9.16.sql zm_update-1.24.3.sql zm_update-1.31.13.sql zm_update-1.31.42.sql zm_update-1.33.9.sql zm_update-1.35.2.sql
zm_update-0.9.7.sql zm_update-1.24.4.sql zm_update-1.31.14.sql zm_update-1.31.43.sql zm_update-1.34.0.sql zm_update-1.35.3.sql
zm_update-0.9.8.sql zm_update-1.26.0.sql zm_update-1.31.15.sql zm_update-1.31.44.sql zm_update-1.34.1.sql zm_update-1.35.4.sql
zm_update-0.9.9.sql zm_update-1.26.1.sql zm_update-1.31.16.sql zm_update-1.31.45.sql zm_update-1.34.20.sql zm_update-1.35.5.sql
zm_update-1.17.1.sql zm_update-1.26.2.sql zm_update-1.31.17.sql zm_update-1.31.46.sql zm_update-1.34.2.sql zm_update-1.35.6.sql
zm_update-1.17.2.sql zm_update-1.26.3.sql zm_update-1.31.18.sql zm_update-1.31.47.sql zm_update-1.34.3.sql zm_update-1.35.7.sql
zm_update-1.18.0.sql zm_update-1.26.5.sql zm_update-1.31.19.sql zm_update-1.31.4.sql zm_update-1.34.4.sql zm_update-1.35.8.sql
zm_update-1.18.1.sql zm_update-1.27.0.sql zm_update-1.31.1.sql zm_update-1.31.5.sql zm_update-1.34.5.sql zm_update-1.35.9.sql
zm_update-1.19.0.sql zm_update-1.28.0.sql zm_update-1.31.20.sql zm_update-1.31.6.sql zm_update-1.34.6.sql zm_update-1.36.6.sql
zm_update-1.19.1.sql zm_update-1.28.100.sql zm_update-1.31.21.sql zm_update-1.31.7.sql zm_update-1.34.7.sql zm_update-1.37.10.sql
zm_update-1.19.2.sql zm_update-1.28.101.sql zm_update-1.31.22.sql zm_update-1.31.8.sql zm_update-1.35.0.sql zm_update-1.37.11.sql
zm_update-1.19.3.sql zm_update-1.28.102.sql zm_update-1.31.23.sql zm_update-1.31.9.sql zm_update-1.35.10.sql zm_update-1.37.1.sql
zm_update-1.19.4.sql zm_update-1.28.103.sql zm_update-1.31.24.sql zm_update-1.32.0.sql zm_update-1.35.11.sql.bak zm_update-1.37.2.sql
zm_update-1.19.5.sql zm_update-1.28.104.sql zm_update-1.31.25.sql zm_update-1.32.1.sql zm_update-1.35.12.sql zm_update-1.37.3.sql
zm_update-1.20.0.sql zm_update-1.28.105.sql zm_update-1.31.26.sql zm_update-1.32.2.sql zm_update-1.35.13.sql zm_update-1.37.4.sql
zm_update-1.20.1.sql zm_update-1.28.106.sql zm_update-1.31.27.sql zm_update-1.32.3.sql zm_update-1.35.14.sql zm_update-1.37.5.sql
zm_update-1.21.0.sql zm_update-1.28.107.sql zm_update-1.31.28.sql zm_update-1.33.0.sql zm_update-1.35.15.sql zm_update-1.37.6.sql
zm_update-1.21.1.sql zm_update-1.28.108.sql zm_update-1.31.29.sql zm_update-1.33.10.sql zm_update-1.35.16.sql zm_update-1.37.7.sql
zm_update-1.21.2.sql zm_update-1.28.109.sql zm_update-1.31.2.sql zm_update-1.33.11.sql zm_update-1.35.17.sql zm_update-1.37.8.sql
zm_update-1.21.3.sql zm_update-1.28.110.sql zm_update-1.31.30.sql zm_update-1.33.12.sql zm_update-1.35.18.sql zm_update-1.37.9.sql
zm_update-1.21.4.sql zm_update-1.28.1.sql zm_update-1.31.31.sql zm-update-1.33.13.sql zm_update-1.35.19.sql
zm_update-1.22.0.sql zm_update-1.28.99.sql zm_update-1.31.32.sql zm_update-1.33.14.sql zm_update-1.35.1.sql

It kept hanging and failing on the file zm_update-1.35.10.sql so I moved that to zm_update-1.35.10.sql.bak and then ran apt -f install and it all finished nicely. I'm now running zoneminder 1.37.11 and all seems well.