FX: Stands up amid very large pile of yak hair
Right. If you're ever in the unfortunate space of needing to upgrade MySQL 5.7 to MariaDB 10 on Ubuntu 18.04 LTS, here's what to do and what not to do.
1) next time, upgrade to 20.04.5 LTS first, and most/all of this will go away :D
2) do NOT install the default mariadb-server-10.1 package, as its mysql_upgrade script does not know how to convert from mysql-5.7 tables.
3) Go here and select your Ubuntu version and a suitable MariaDB version.
4) Cut and paste the appropriate repo lines, and do what it says.
5) if it doesn't run mysql_upgrade for you, run it as root.
6) You may find that it hangs on starting the MariaDB server. This is an issue with apparmor, and can be fixed by following these instructions (reproduced here just in case of link rot).
sudo systemctl stop mariadb
echo "/usr/sbin/mysqld { }" | sudo tee /etc/apparmor.d/usr.sbin.mysqld
sudo apparmor_parser -v -R /etc/apparmor.d/usr.sbin.mysqld
The above should display Removal succeeded for "/usr/sbin/mysqld"
And then, to stop it reappearing on reboot:
sudo ln -s /etc/apparmor.d/usr.sbin.mysqld /etc/apparmor.d/disable/usr.sbin.mysqld
Finally:
sudo systemctl start mariadb
Top comments (1)
Hello ! Don't hesitate to put colors on your
codeblocklike this example for have to have a better understanding of your code 😎