Created
August 29, 2019 18:42
-
-
Save katalystsol/93eee5cce7e767c9f9613d782de4482a to your computer and use it in GitHub Desktop.
Upgrade MariaDB 10.3 to 10.4 on Ubuntu 18
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# https://mariadb.com/kb/en/library/upgrading-from-mariadb-103-to-mariadb-104/ | |
# Add MariaDB APT repo | |
sudo apt-get update | |
sudo apt-get install software-properties-common | |
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8 | |
sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://sfo1.mirrors.digitalocean.com/mariadb/repo/10.4/ubuntu bionic main' | |
sudo apt-get update | |
# Stop MariaDB | |
sudo systemctl stop mysql | |
# Uninstall old version of MariaDB | |
sudo apt-get remove mariadb-server | |
# Install new version of MariaDB | |
sudo apt-get update | |
sudo apt-get install mariadb-server galera-4 mariadb-client libmariadb3 mariadb-backup mariadb-common | |
# check the my.cnf for any configuration changes to options & remove any options no longer supported (see website above) | |
sudo vi /etc/mysql/my.cnf | |
# Start MariaDB | |
sudo systemctl start mysql | |
# Run upgrade to upgrade the database, tables, etc | |
sudo mysql_upgrade --verbose --verbose other-options --force |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment