From 962bceb37b2fe609fd64aa36685dfd462152e6af Mon Sep 17 00:00:00 2001
From: Remi Collet <remi@remirepo.net>
Date: Mon, 27 Aug 2018 15:13:14 +0200
Subject: save maraidb update notes

---
 glpi-93-c7.md | 53 +++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 53 insertions(+)

(limited to 'glpi-93-c7.md')

diff --git a/glpi-93-c7.md b/glpi-93-c7.md
index b2bfd75..d117cbc 100644
--- a/glpi-93-c7.md
+++ b/glpi-93-c7.md
@@ -75,3 +75,56 @@ GLPI requires PHP >= 5.6, so default version 5.4 in base repository is not compa
 ## Done
 
     Browse http://servername/glpi/ (login=glpi, password=glpi)
+
+
+---------------
+
+## Mariadb upgrade from 5.5 to 10.2
+
+If you have some DB, created with default mariadb 5.5
+
+### Install
+
+    # yum install rh-mariadb102-mariadb-server
+
+If needed, create a new FS for /var/opt/rh/rh-mariadb102/lib/mysql
+
+
+### Lazy way
+
+    # systemctl stop mariadb
+    # systemctl disable mariadb
+
+    # rsync -av /var/lib/mysql/ /var/opt/rh/rh-mariadb102/lib/mysql/
+
+    # systemctl start rh-mariadb102-mariadb
+    # systemctl enable rh-mariadb102-mariadb
+
+    # mysql_upgrade -pxxx
+
+### Long way  dump
+
+Change /etc/opt/rh/rh-mariadb102/my.cnf.d/mariadb-server.cnf to use a different port
+
+    [server]
+    socket=/var/lib/mysql/mysql2.sock
+    port=3307
+
+    # systemctl start rh-mariadb102-mariadb
+
+    # scl enable rh-mariadb102 bash
+    # mysqldump -h127.0.0.1 -pxxx --all-databases | mysql -h127.0.0.1 -P3307
+
+    # systemctl stop mariadb
+    # systemctl disable mariadb
+    # systemctl stop rh-mariadb102-mariadb
+
+Restore /etc/opt/rh/rh-mariadb102/my.cnf.d/mariadb-server.cnf
+
+    [server]
+    socket=/var/lib/mysql/mysql.sock
+    port=3306
+
+    # systemctl start rh-mariadb102-mariadb
+    # systemctl enable rh-mariadb102-mariadb
+
-- 
cgit