save maraidb update notes

1 files changed, 53 insertions, 0 deletions

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
+