We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
How to upgrade MySQL to 5.6
How to upgrade MySQL to 5.6
Hi,
What is the best way to upgrade MySQL 5.5 to 5.6 on CentOS? I've been searching online but couldn't find a proper solution. Based on "mysql -v", it's 5.5.42 MySQL Community Server (GPL) by Remi . Hope someone can some help, thanks.
What is the best way to upgrade MySQL 5.5 to 5.6 on CentOS? I've been searching online but couldn't find a proper solution. Based on "mysql -v", it's 5.5.42 MySQL Community Server (GPL) by Remi . Hope someone can some help, thanks.
Re: How to upgrade MySQL to 5.6
CentOS 6 guide look so.
Stop MySQL:
Make backup copy of bases MySQL:
Disable Atomic repo, if enabled
Add MySQL-community repo:
Disable update to 5.7, enable 5.6 version:
Install MySQL:
Start MySQL service:
Update databases:
Stop MySQL:
Code: Select all
# service mysqld stop
Code: Select all
# mkdir /var/lib/mysqlcopy
# cp -aR /var/lib/mysql/* /var/lib/mysqlcopy
Code: Select all
# vi atomic.repo
enabled = 0
Code: Select all
# yum install http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm
Code: Select all
# vi /etc/yum.repos.d/mysql-community.repo
[mysql56-community]
enabled=1
[mysql57-community]
enabled=0
Code: Select all
# yum install mysql
Code: Select all
# service mysqld start
Code: Select all
# mysql_upgrade -uroot
Re: How to upgrade MySQL to 5.6
Thank you very much. I will try this.
update: It's working fine, issue resolved (Server must be restarted). Thanks.
update: It's working fine, issue resolved (Server must be restarted). Thanks.
-
- Posts: 2
- Joined: Thu Jan 05, 2017 4:14 pm
Re: How to upgrade MySQL to 5.6
I've been looking for a similar solution for CentOS 7. I've once broken the whole server trying to upgrade which cost me 2 hours of extra time to rebuild, upload and setup the websites back.
Is there anyone who has successfully upgraded to Mysql 5.6 successfully?
This is my database version info
Is there anyone who has successfully upgraded to Mysql 5.6 successfully?
This is my database version info
* Server is running latest version of Vestacp.Server version: 5.5.52-MariaDB MariaDB Server
Re: How to upgrade MySQL to 5.6
Here is the complete tutorial
viewtopic.php?f=14&t=13617
viewtopic.php?f=14&t=13617
Re: How to upgrade MySQL to 5.6
Problem in your case is than centos 7 not run mysql, centos 7 come whit mariadb so you need upgrade mariadb to mariadb 10 or remove mariadb, and install mysql server, not is good idea, so is better upgrade to mariadb10 whit mariadb repos, is same procedure has upgrade mysql but whit mariadb repos.ddeveloper wrote:I've been looking for a similar solution for CentOS 7. I've once broken the whole server trying to upgrade which cost me 2 hours of extra time to rebuild, upload and setup the websites back.
Is there anyone who has successfully upgraded to Mysql 5.6 successfully?
This is my database version info
* Server is running latest version of Vestacp.Server version: 5.5.52-MariaDB MariaDB Server
-
- Posts: 8
- Joined: Thu Jan 24, 2019 5:14 pm
- Contact:
- Os: CentOS 7x
- Web: apache + nginx
Re: How to upgrade MySQL to 5.6
I need help, I'm using the same tutorial for upgrading to 8.0, but I'm stuck on one thing, the Transaction check throws this error:
Please help.Resolving Dependencies
--> Running transaction check
---> Package mysql.x86_64 0:5.5.62-1.el6.remi will be obsoleted
---> Package mysql-community-client.x86_64 0:8.0.21-1.el6 will be obsoleting
---> Package mysql-community-libs.x86_64 0:8.0.21-1.el6 will be obsoleting
--> Processing Dependency: mysql-community-common(x86-64) >= 8.0.11 for package: mysql-community-libs-8.0.21-1.el6.x86_64
---> Package mysql-community-libs-compat.x86_64 0:8.0.21-1.el6 will be obsoleting
---> Package mysql-community-server.x86_64 0:8.0.21-1.el6 will be obsoleting
---> Package mysql-libs.x86_64 0:5.5.62-1.el6.remi will be obsoleted
---> Package mysql-server.x86_64 0:5.5.62-1.el6.remi will be obsoleted
---> Package mysql80-community-release.noarch 0:el6-1 will be updated
---> Package mysql80-community-release.noarch 0:el6-3 will be an update
--> Running transaction check
---> Package mysql-community-common.x86_64 0:8.0.21-1.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
===================================================================================================================================================================================================================
Package Arch Version Repository Size
===================================================================================================================================================================================================================
Installing:
mysql-community-client x86_64 8.0.21-1.el6 mysql80-community 49 M
replacing mysql.x86_64 5.5.62-1.el6.remi
mysql-community-libs x86_64 8.0.21-1.el6 mysql80-community 4.7 M
replacing mysql-libs.x86_64 5.5.62-1.el6.remi
mysql-community-libs-compat x86_64 8.0.21-1.el6 mysql80-community 1.7 M
replacing mysql-libs.x86_64 5.5.62-1.el6.remi
mysql-community-server x86_64 8.0.21-1.el6 mysql80-community 539 M
replacing mysql-server.x86_64 5.5.62-1.el6.remi
Updating:
mysql80-community-release noarch el6-3 mysql80-community 25 k
Installing for dependencies:
mysql-community-common x86_64 8.0.21-1.el6 mysql80-community 738 k
Transaction Summary
===================================================================================================================================================================================================================
Install 5 Package(s)
Upgrade 1 Package(s)
Total size: 595 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Check Error:
file /usr/lib64/mysql/libmysqlclient.so.16.0.0 from install of mysql-community-libs-compat-8.0.21-1.el6.x86_64 conflicts with file from package compat-mysql51-5.1.73-1.el6.remi.x86_64
file /usr/lib64/mysql/libmysqlclient_r.so.16.0.0 from install of mysql-community-libs-compat-8.0.21-1.el6.x86_64 conflicts with file from package compat-mysql51-5.1.73-1.el6.remi.x86_64