Upgrade MariaDB

Lege Backup an (siehe unten)

Entferne mysql-server* und mysql-server-core*

Upgrade Repo with MariaDB-Auto-Skript: https://mariadb.com/kb/en/mariadb-package-repository-setup-and-usage/

Korrigiere Version (aktuell 10.11 LTS) curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version="mariadb-10.11"

Reinstalliere alle nötigen Pakete: apt-get install mariadb-server mariadb-client mariadb-backup

ggf default charset anpassen. (für nextcloud utf8mb4)

Nach Repo Umstellung:

1. Backup everything mysqldump -u root -p --opt --all-databases -r backup.sql
2. Restore: mysql -uroot -p --default-character-set=utf8 mysql> SET names 'utf8'; mysql> SOURCE backup.sql;

Aus: https://stackoverflow.com/questions/9497869/export-and-import-all-mysql-databases-at-once