Diferencias
Muestra las diferencias entre dos versiones de la página.
| Ambos lados, revisión anterior Revisión previa | |||
|
actualizar_mysql_-mariadb [2017/05/08 13:55] 10.12.12.129 |
actualizar_mysql_-mariadb [2017/05/08 13:55] (actual) 10.12.12.129 |
||
|---|---|---|---|
| Línea 4: | Línea 4: | ||
| - | For CentOS 7: | ||
| - | CentOS 7 basically shipped with MariaDB. MariaDB 10.x version is a drop-in replacement for MySQL 5.5-5.7. | ||
| - | |||
| - | Backup all databases with the following command: | ||
| - | # mysqldump -uadmin -P3306 -p"`cat /etc/psa/.psa.shadow`" --all-databases > /tmp/all-database.sql | ||
| - | Copy the databases directory in a separate folder like this (for backup purposes also): | ||
| - | # cp -a /var/lib/mysql/ /var/lib/mysql.bak | ||
| - | Stop MariaDB service: | ||
| - | # service mariadb stop | ||
| - | Add MariaDB repository: | ||
| - | # vi /etc/yum.repos.d/MariaDB10.repo | ||
| - | # MariaDB 10.1 CentOS repository list - created 2016-01-18 09:58 UTC | ||
| - | # http://mariadb.org/mariadb/repositories/ | ||
| - | [mariadb10.2] | ||
| - | name = MariaDB | ||
| - | baseurl = http://yum.mariadb.org/10.2/centos7-amd64 | ||
| - | gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB | ||
| - | gpgcheck=1 | ||
| - | enabled=1 | ||
| - | |||
| - | [mariadb10.1] | ||
| - | name = MariaDB | ||
| - | baseurl = http://yum.mariadb.org/10.2/centos7-amd64 | ||
| - | gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB | ||
| - | gpgcheck=1 | ||
| - | enabled=0 | ||
| - | Perform an upgrade with | ||
| - | # yum install mariadb | ||
| - | Start MariaDB service: | ||
| - | # service mysql start | ||
| - | Then execute this command to update package version inside Plesk: | ||
| - | |||
| - | # plesk sbin packagemng -sdf | ||
| - | Note: After upgrade to 10.2 version, there may appear 'mysql' init script. We recommend removing it: | ||
| - | # rm -f /etc/init.d/mysql | ||
| - | # systemctl daemon-reload | ||