How to update mysql from 5.1 to 5.6

[EmRa228]

How to update mysql from 5.1 to 5.6 ?

[Dave]

Yes, this would be a good instruction to have. I've tried updating it manually twice. The first time, phpMyAdmin stopped working correctly (couldn't create any tables). The second time, it phpMyAdmin worked fine and a half dozen other things broke.

[Administrator]

what kind of instructions have you used ?

also keep in the mind that you always need to make a backup before proceeding with any updates especially like in this case when you are upgrading mysql server.

[PsyberTech]

Read 423 times, replied to by an Admin and still not one single helpful reply.

So, Admins, how do you upgrade CWP to run MySQL 5.6 from the very old version 5.1 that is installed with the latest version of CWP. 

Please do not respond with a non-answer asking me what I have tried because this forum would be full of the dozens of useless pages found in Google about how to do it and none of them work.  Most are full of dead links to files which are no longer available due to the age of the posts. 

Can we get an informative answer that works with the latest CWP install that we can follow?  I will even donate another $20.00 so the information can be shared with the rest of the community here.

Many thanks,

PsyberTech

[Administrator]

in the google search you have an option to search the latest posts.
If you are not familiar with mysql upgrade you can check mariaDB, it has easy installation with repository.

If you need this as an option to be integrated in the cwp with the next release then you can check the custom modules site:
http://centos-webpanel.com/order-custom-builded-modules-for-cwp

[PsyberTech]

*sigh*

Ah, the exact non-answer I fully expected.

Update....

I paid someone else the $20.00 and he gave me this which worked perfect!

wget https://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
yum install https://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
yum update

MySQL version: 5.6.21 installed.

[Administrator]

you didn't have to pay for that since you can google for the instructions.
The easiest way is to install MariaDB including MariaDB repo.

https://mariadb.com/kb/en/mariadb/documentation/getting-started/binary-packages/rpm/yum/

[samazgor]

Hope this might help -

1) Create full database backup (In case mysql server break we have backup to restore).

Code Select Expand

mysqldump --events --all-databases | gzip > /home/alldatabases.sql.gz


2) Install Remi repo.

Code Select Expand

cd /etc/yum.repos.d
wget http://rpms.famillecollet.com/enterprise/remi.repo


3) Now upgrade MySQL Server.

Code Select Expand

yum --enablerepo=remi update mysql-server
sudo mysql_upgrade


4) Restart MySQL Server.

Code Select Expand

service mysqld restart


If you want to do a fresh install of MySQL Server.

Code Select Expand

yum --enablerepo=remi install mysql-server


You are done with upgrading.

[netedge]

can anyone guide me on how to upgrade mysql from 5.5 to 5.6 version

because above method does not help in up gradation it shows conflicting errors.
We have tried all the links.
We have tried with yum install, yum update, manually installation done by rpm, we have tried to compile mysql 5.6.26 by packages but still it didn't help.

So anyone can have idea please help

[KnightWolf]

I followed this guide to upgrade to MariaDB10, worked beautifully.
https://mariadb.com/blog/upgrading-mysql-51-mariadb-100-centos-6

[rflsantana]

Hope this might help -

1) Create full database backup (In case mysql server break we have backup to restore).

Code Select Expand

mysqldump --events --all-databases | gzip > /home/alldatabases.sql.gz


2) Install Remi repo.

Code Select Expand

cd /etc/yum.repos.d
wget http://rpms.famillecollet.com/enterprise/remi.repo


3) Now upgrade MySQL Server.

Code Select Expand

yum --enablerepo=remi update mysql-server
sudo mysql_upgrade


4) Restart MySQL Server.

Code Select Expand

service mysqld restart


If you want to do a fresh install of MySQL Server.

Code Select Expand

yum --enablerepo=remi install mysql-server


You are done with upgrading.

I used exactly this command on my VPS and now I can not access it!

When you open the page, the following error appears

Warning: mysql_connect(): No such file or directory in /usr/local/cwpsrv/htdocs/admin/index.php(1) : eval()'d code(1) : eval()'d code on line 2
mysqld is stopped

Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: service cwpsrv restart

**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf

Could not connect: No such file or directory

[Igor S.]

Hello, rflsantana.

Seems like something wrong with your upgrade...
Check if it works ( service mysql restart )

[vdshub]

can anyone guide me on how to upgrade mysql from 5.5 to 5.6 version

because above method does not help in up gradation it shows conflicting errors.
We have tried all the links.
We have tried with yum install, yum update, manually installation done by rpm, we have tried to compile mysql 5.6.26 by packages but still it didn't help.

So anyone can have idea please help

very good question
I have same problem

[vdshub]

I followed this guide to upgrade to MariaDB10, worked beautifully.
https://mariadb.com/blog/upgrading-mysql-51-mariadb-100-centos-6

i also made update for this instruction

[gleidson_h]

I want to update mysql 5.1 to 5.5 doing this:

1. Exactly after I installed CentOS 6.7, I did: yum -y update

2. Installed mysql 5.1

3. Executed line by line:

cd /etc/yum.repos.d
wget http://rpms.famillecollet.com/enterprise/remi.repo
yum --enablerepo=remi update mysql-server
sudo mysql_upgrade -u root -p (The problem it's here. In this topic, other person just say sudo mysql_upgrade and this was ocurring a big problem! So, you need to use your user root.)
service mysqld restart
yum --enablerepo=remi install mysql-server

After that, I installed normally CWP. =]