Author Topic: How to update mysql from 5.1 to 5.6  (Read 63329 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
How to update mysql from 5.1 to 5.6
« on: July 07, 2014, 06:25:32 AM »
How to update mysql from 5.1 to 5.6 ?

Offline
*
Re: How to update mysql from 5.1 to 5.6
« Reply #1 on: November 02, 2014, 10:40:01 PM »
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.

Offline
*
Re: How to update mysql from 5.1 to 5.6
« Reply #2 on: November 04, 2014, 02:54:21 AM »
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.
AntiDDoS Protection (web + mail)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: How to update mysql from 5.1 to 5.6
« Reply #3 on: November 08, 2014, 10:15:40 PM »
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

Offline
*
Re: How to update mysql from 5.1 to 5.6
« Reply #4 on: November 11, 2014, 12:28:11 AM »
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
AntiDDoS Protection (web + mail)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: How to update mysql from 5.1 to 5.6
« Reply #5 on: November 12, 2014, 12:23:12 AM »
*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.

:)
« Last Edit: November 12, 2014, 01:15:26 AM by PsyberTech »

Offline
*
Re: How to update mysql from 5.1 to 5.6
« Reply #6 on: November 12, 2014, 02:11:00 AM »
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/
AntiDDoS Protection (web + mail)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: How to update mysql from 5.1 to 5.6
« Reply #7 on: May 26, 2015, 08:55:57 PM »
Hope this might help -

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

Code: [Select]
mysqldump --events --all-databases | gzip > /home/alldatabases.sql.gz

2) Install Remi repo.

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


3) Now upgrade MySQL Server.

Code: [Select]
yum --enablerepo=remi update mysql-server
sudo mysql_upgrade


4) Restart MySQL Server.

Code: [Select]
service mysqld restart

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

Code: [Select]
yum --enablerepo=remi install mysql-server

You are done with upgrading.

Offline
*
Re: How to update mysql from 5.1 to 5.6
« Reply #8 on: August 23, 2015, 03:02:53 AM »
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
« Last Edit: August 23, 2015, 03:29:06 AM by netedge »

Offline
*
Re: How to update mysql from 5.1 to 5.6
« Reply #9 on: September 30, 2015, 06:15:12 PM »
I followed this guide to upgrade to MariaDB10, worked beautifully.
https://mariadb.com/blog/upgrading-mysql-51-mariadb-100-centos-6

Offline
*
Re: How to update mysql from 5.1 to 5.6
« Reply #10 on: October 28, 2015, 11:15:34 AM »
Hope this might help -

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

Code: [Select]
mysqldump --events --all-databases | gzip > /home/alldatabases.sql.gz

2) Install Remi repo.

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


3) Now upgrade MySQL Server.

Code: [Select]
yum --enablerepo=remi update mysql-server
sudo mysql_upgrade


4) Restart MySQL Server.

Code: [Select]
service mysqld restart

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

Code: [Select]
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

Quote
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


Offline
*****
Re: How to update mysql from 5.1 to 5.6
« Reply #11 on: October 29, 2015, 12:34:10 PM »
Hello, rflsantana.

Seems like something wrong with your upgrade...
Check if it works ( service mysql restart )
You can ask me to solve any problem with your server for some money in pm  ;)
Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor
Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: How to update mysql from 5.1 to 5.6
« Reply #12 on: December 22, 2015, 01:35:25 AM »
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

Offline
*
Re: How to update mysql from 5.1 to 5.6
« Reply #13 on: December 22, 2015, 04:29:23 PM »
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

Offline
*
Re: How to update mysql from 5.1 to 5.6
« Reply #14 on: December 31, 2015, 08:52:18 AM »
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. =]