[MARIADB] upgrade mariadb from 5.6 to 10.6 - fourslickz/notes GitHub Wiki

mysqldump -u root -p --all-databases > ./all-database-backup-2023-08-28.sql

cp -a /var/lib/mysql /var/lib/mysql.backup

cp -a /etc/my.cnf /etc/my.cnf_bk

systemctl stop mariadb

systemctl status mariadb

mv /etc/yum.repos.d/mariadb.repo /etc/yum.repos.d/mariadb_bk

nano /etc/yum.repos.d/MariaDB.repo

[mariadb] 
name = MariaDB
baseurl = http://yum.mariadb.org/10.6/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

yum remove mariadb-server

yum clean all

yum install MariaDB-server

systemctl start mariadb

systemctl enable mariadb

mysql_upgrade -u root -p