Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - ahmedsaoud31

Pages: [1]
1
Updates / Re: Update MariaDB >= 10.2
« on: December 28, 2019, 11:49:52 AM »
You can find all available versions here
http://yum.mariadb.org

Edit MariaDB version you want in this file
 
Quote
/etc/yum.repos.d/MariaDB.repo

run this commands
Quote
mysql
Quote
set global innodb_fast_shutdown = 0;

Back by press Ctrl+c and run this commands
Quote
systemctl stop mysql
Quote
systemctl status mysql

Back up your DB
Quote
cp -r /var/lib/mysql /var/lib/bk

Remove MariaDB
Quote
yum remove mariadb-server

Remove Galera
Quote
yum remove galera*

Install MaraiaDB
Quote
yum --disablerepo=* --enablerepo=MariaDB install mariadb-server

Reboot your system
Quote
reboot

login to your centos web-panel control dashboard

finally, run this command
Quote
mysql_upgrade

Login to your PhpMyAdmin to check MariaDB new version


Pages: [1]