We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on Vesta 2.0 and expect to release it by the end of 2024. Read more about it: https://vestacp.com/docs/vesta-2-development
Upgrade MariaDB
Upgrade MariaDB
I saw on this forum that i can use this guide to upgrade MariaDB
http://www.liquidweb.com/kb/how-to-upgr ... -centos-7/
Is this OK, or will the upgrade of vesta "break" my server?
Will this install in the same location as mariadb is now?
I am asking before i do this to be shure not to break the server.
http://www.liquidweb.com/kb/how-to-upgr ... -centos-7/
Is this OK, or will the upgrade of vesta "break" my server?
Will this install in the same location as mariadb is now?
I am asking before i do this to be shure not to break the server.
-
mehargags
- Support team
- Posts: 1096
- Joined: Sat Sep 06, 2014 9:58 pm
- Contact:
- Os: Debian 8x
- Web: apache + nginx
Re: Upgrade MariaDB
if you are on CentOS 7, you are already on MariaDB.
to check results
Code: Select all
mysql -VRe: Upgrade MariaDB
I am on version 5.5.44-MariaDB
But I want to upgrade it to 5.6 or 10. Is that easy?
But I want to upgrade it to 5.6 or 10. Is that easy?
-
mehargags
- Support team
- Posts: 1096
- Joined: Sat Sep 06, 2014 9:58 pm
- Contact:
- Os: Debian 8x
- Web: apache + nginx
Re: Upgrade MariaDB
absolutely... peace of cake - just head to official repo and follow the instructions. While installing, DO NOT change your mysql pass, just press enter to skip it and you will be all good !
-
RevengeFNF
- Posts: 92
- Joined: Sat Aug 02, 2014 6:50 pm
- Os: CentOS 6x
- Web: nginx + php-fpm
Re: Upgrade MariaDB
Just make this steps:
nano /etc/yum.repos.d/MariaDB10.repo
yum remove mariadb-server mariadb mariadb-libs
yum install MariaDB-server MariaDB-client
systemctl start mariadb
systemctl enable mariadb
mysql_upgrade
nano /etc/yum.repos.d/MariaDB10.repo
systemctl stop mariadb# MariaDB 10.1 CentOS repository list
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
yum remove mariadb-server mariadb mariadb-libs
yum install MariaDB-server MariaDB-client
systemctl start mariadb
systemctl enable mariadb
mysql_upgrade
Re: Upgrade MariaDB
When doing that phpMyAdmin is uninstalled.
when trying to install with yum install phpmyadmin i get this:
Code: Select all
Apr 07 08:34:05 Erased: 1:mariadb-server-5.5.44-2.el7.centos.x86_64
Apr 07 08:34:07 Erased: phpMyAdmin-4.4.15.5-1.el7.noarch
Apr 07 08:34:07 Erased: php-mysql-5.4.45-4.el7.remi.x86_64
Apr 07 08:34:07 Erased: 1:mariadb-5.5.44-2.el7.centos.x86_64
Apr 07 08:34:07 Erased: perl-DBD-MySQL-4.023-5.el7.x86_64
Apr 07 08:34:07 Erased: 1:net-snmp-5.7.2-24.el7.x86_64
Apr 07 08:34:08 Erased: 1:mariadb-libs-5.5.44-2.el7.centos.x86_64
Apr 07 08:44:04 Installed: MariaDB-common-10.1.13-1.el7.centos.x86_64
Apr 07 08:44:14 Installed: MariaDB-client-10.1.13-1.el7.centos.x86_64
Apr 07 08:44:14 Installed: jemalloc-3.6.0-1.el7.x86_64
Apr 07 08:44:14 Installed: boost-program-options-1.53.0-25.el7.x86_64
Apr 07 08:44:16 Installed: galera-25.3.15-1.rhel7.el7.centos.x86_64
Apr 07 08:44:43 Installed: MariaDB-server-10.1.13-1.el7.centos.x86_64
Code: Select all
yum install phpmyadmin
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.nl.leaseweb.net
* epel: ftp.nluug.nl
* extras: ftp.nluug.nl
* remi-safe: remi.mirrors.cu.be
* updates: ftp.nluug.nl
* webtatic: uk.repo.webtatic.com
Resolving Dependencies
--> Running transaction check
---> Package phpMyAdmin.noarch 0:4.4.15.5-1.el7 will be installed
--> Processing Dependency: php-mysqli >= 5.3.7 for package: phpMyAdmin-4.4.15.5-1.el7.noarch
--> Running transaction check
---> Package php-mysqlnd.x86_64 0:5.4.16-36.el7_1 will be installed
--> Processing Dependency: php-pdo(x86-64) = 5.4.16-36.el7_1 for package: php-mysqlnd-5.4.16-36.el7_1.x86_64
--> Finished Dependency Resolution
Error: Package: php-mysqlnd-5.4.16-36.el7_1.x86_64 (base)
Requires: php-pdo(x86-64) = 5.4.16-36.el7_1
Installed: php-pdo-5.4.45-4.el7.remi.x86_64 (@remi)
php-pdo(x86-64) = 5.4.45-4.el7.remi
Available: php-pdo-5.4.16-36.el7_1.x86_64 (base)
php-pdo(x86-64) = 5.4.16-36.el7_1
Available: php54w-pdo-5.4.45-2.w7.x86_64 (webtatic)
php-pdo(x86-64) = 5.4.45-2.w7
Available: php55w-pdo-5.5.32-1.w7.x86_64 (webtatic)
php-pdo(x86-64) = 5.5.32-1.w7
Available: php55w-pdo-5.5.33-1.w7.x86_64 (webtatic)
php-pdo(x86-64) = 5.5.33-1.w7
Available: php56w-pdo-5.6.18-1.w7.x86_64 (webtatic)
php-pdo(x86-64) = 5.6.18-1.w7
Available: php56w-pdo-5.6.19-1.w7.x86_64 (webtatic)
php-pdo(x86-64) = 5.6.19-1.w7
Available: php70w-pdo-7.0.3-1.w7.x86_64 (webtatic)
php-pdo(x86-64) = 7.0.3-1.w7
Available: php70w-pdo-7.0.4-1.w7.x86_64 (webtatic)
php-pdo(x86-64) = 7.0.4-1.w7
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest-
andrewkoski
- Posts: 2
- Joined: Wed Sep 30, 2015 4:42 pm
- Contact:
Re: Upgrade MariaDB
To get your phpmyadmin back, just do this;
yum install phpmyadmin --enablerepo=remi
yum install phpmyadmin --enablerepo=remi
-
saam albert
- Posts: 2
- Joined: Tue Oct 04, 2016 10:55 pm
Re: Upgrade MariaDB
I mess up with this script. Is there any other route ?[color=#000000]leisegang[/color] wrote:When doing that phpMyAdmin is uninstalled.
when trying to install with yum install phpmyadmin i get this:Code: Select all
Apr 07 08:34:05 Erased: 1:mariadb-server-5.5.44-2.el7.centos.x86_64 Apr 07 08:34:07 Erased: phpMyAdmin-4.4.15.5-1.el7.noarch Apr 07 08:34:07 Erased: php-mysql-5.4.45-4.el7.remi.x86_64 Apr 07 08:34:07 Erased: 1:mariadb-5.5.44-2.el7.centos.x86_64 Apr 07 08:34:07 Erased: perl-DBD-MySQL-4.023-5.el7.x86_64 Apr 07 08:34:07 Erased: 1:net-snmp-5.7.2-24.el7.x86_64 Apr 07 08:34:08 Erased: 1:mariadb-libs-5.5.44-2.el7.centos.x86_64 Apr 07 08:44:04 Installed: MariaDB-common-10.1.13-1.el7.centos.x86_64 Apr 07 08:44:14 Installed: MariaDB-client-10.1.13-1.el7.centos.x86_64 Apr 07 08:44:14 Installed: jemalloc-3.6.0-1.el7.x86_64 Apr 07 08:44:14 Installed: boost-program-options-1.53.0-25.el7.x86_64 Apr 07 08:44:16 Installed: galera-25.3.15-1.rhel7.el7.centos.x86_64 Apr 07 08:44:43 Installed: MariaDB-server-10.1.13-1.el7.centos.x86_64
Code: Select all
yum install phpmyadmin Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * base: mirror.nl.leaseweb.net * epel: ftp.nluug.nl * extras: ftp.nluug.nl * remi-safe: remi.mirrors.cu.be * updates: ftp.nluug.nl * webtatic: uk.repo.webtatic.com Resolving Dependencies --> Running transaction check ---> Package phpMyAdmin.noarch 0:4.4.15.5-1.el7 will be installed --> Processing Dependency: php-mysqli >= 5.3.7 for package: phpMyAdmin-4.4.15.5-1.el7.noarch --> Running transaction check ---> Package php-mysqlnd.x86_64 0:5.4.16-36.el7_1 will be installed --> Processing Dependency: php-pdo(x86-64) = 5.4.16-36.el7_1 for package: php-mysqlnd-5.4.16-36.el7_1.x86_64 --> Finished Dependency Resolution Error: Package: php-mysqlnd-5.4.16-36.el7_1.x86_64 (base) Requires: php-pdo(x86-64) = 5.4.16-36.el7_1 Installed: php-pdo-5.4.45-4.el7.remi.x86_64 (@remi) php-pdo(x86-64) = 5.4.45-4.el7.remi Available: php-pdo-5.4.16-36.el7_1.x86_64 (base) php-pdo(x86-64) = 5.4.16-36.el7_1 Available: php54w-pdo-5.4.45-2.w7.x86_64 (webtatic) php-pdo(x86-64) = 5.4.45-2.w7 Available: php55w-pdo-5.5.32-1.w7.x86_64 (webtatic) php-pdo(x86-64) = 5.5.32-1.w7 Available: php55w-pdo-5.5.33-1.w7.x86_64 (webtatic) php-pdo(x86-64) = 5.5.33-1.w7 Available: php56w-pdo-5.6.18-1.w7.x86_64 (webtatic) php-pdo(x86-64) = 5.6.18-1.w7 Available: php56w-pdo-5.6.19-1.w7.x86_64 (webtatic) php-pdo(x86-64) = 5.6.19-1.w7 Available: php70w-pdo-7.0.3-1.w7.x86_64 (webtatic) php-pdo(x86-64) = 7.0.3-1.w7 Available: php70w-pdo-7.0.4-1.w7.x86_64 (webtatic) php-pdo(x86-64) = 7.0.4-1.w7 You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest
Last edited by saam albert on Thu Oct 06, 2016 4:41 am, edited 1 time in total.
Re: Upgrade MariaDB
For Centos
1. Remove webtatic repo, add remi repo
2. Create file /etc/yum.repos.d/mariadb.repo
3. service mariadb stop
4. yum update
5. service mysql start
6. mysql_upgrade
Profit
1. Remove webtatic repo, add remi repo
2. Create file /etc/yum.repos.d/mariadb.repo
Code: Select all
# MariaDB 10.1 CentOS repository list - created 2016-01-25 00:03 UTC
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=14. yum update
5. service mysql start
6. mysql_upgrade
Profit