Dritsu/ November 13, 2018/ Linux/ 0 comments

Backup All MariaDB Databases
# mysqldump -u root -ppassword --all-databases > /tmp/all-database.sql
# systemctl stop mysql
# cp -a /var/lib/mysql/ /var/lib/mysql.bak
# vim /etc/yum.repos.d/MariaDB10.repo

DI isi dengan :
# MariaDB 10.1 CentOS repository list - created 2016-01-18 09:58 UTC
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Keluar vim :
esc:q! (Keluar dan tidak di save)
exc:wq(keluar dan save)
# yum remove mariadb-server mariadb mariadb-libs
clean the repository
# yum clean all
# yum -y install MariaDB-server MariaDB-client
# systemctl start mariadb
# systemctl enable mariadb
# mysql_upgrade
# mysql -V

Share this Post

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*