diff options
| -rw-r--r-- | glpi-93-c7.md | 53 |
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 + |