summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorRemi Collet <remi@remirepo.net>2018-08-27 15:13:14 +0200
committerRemi Collet <remi@remirepo.net>2018-08-27 15:13:14 +0200
commit962bceb37b2fe609fd64aa36685dfd462152e6af (patch)
treed46c7fac14bebf8e51d7e15b8b8fd22d82f130ab
parent873689ddfea9effc31bc650a50e913f592123e59 (diff)
save maraidb update notes
-rw-r--r--glpi-93-c7.md53
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
+