Hi, > I upgraded mysql from 8.0.46-1 to 9.7.2-1 on an Unstable server running > Mediawiki. This installation dates back to 2007. > > I can confirm I ran into the "no upgrade path" issue reported in this > bug. Five hours later (following any number of unsound decisions on my > part, including installing the mysql-community-8.0 packages from the > MySQL upstream), I was able to get my database running again by building > the 8.0 packages from source, installing them, and restoring a backup of > my /var/lib/mysql taken before the update. This was obviously > undesirable.
Just checking that you are aware that on a Debian/Ubuntu system (still) running MySQL 8.0 you can simply run `apt install mariadb-server` and the upgrade will work? You might have specific reasons to stay on MySQL of course but just wanted to mention here that the option to migrate to MariaDB exists, and most of Debian users did that years ago. Also wikipedia.org itself has been running MariaDB for 10+ years.
