Dritsu/ November 13, 2018/ Komputer/ 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/
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64

Keluar vim :
(Keluar dan tidak di save)
(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 *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>