Upgrading MySQL to 5.5 in CentOS Web Panel

2Fast2BCn

New member
Joined
May 27, 2016
Messages
10
Points
0
In this post I will show you how to upgrade MySQL server to version 5.5 in CentOS Web Panel (CWP).

Default CWP using MySQL 5.1, so if you previously used the website MySQL 5.5 will surely error occurred while importing data. So, update MySQL to 5.5 when installed just CWP.

1) Create full database backup of your mysql databases before upgrading your MYSQL

Code:
mysqldump --events --all-databases | gzip > /home/alldatabases.sql.gz
To install, you first stop the MySQL running away.

Code:
service mysqld stop
2) Load this package

Code:
rpm -Uvh https://mirror.webtatic.com/yum/el6/latest.rpm
3) Run 2 these commands
Code:
yum install mysql.`uname -i` yum-plugin-replace
yum replace mysql --replace-with mysql55w
4) Restart MySQL Server.

Code:
service mysqld restart
If you want to do a fresh install of MySQL Server.

Code:
yum --enablerepo=remi install mysql-server
You are done with upgrading. Hope it helps!
 

ElixantTechnology

New member
Joined
Nov 26, 2014
Messages
622
Points
0
My recommendation, do not use MySQL.. In fact, it is recommended that everyone upgrades to MariaDB 10; it is a drop-in replacement for MySQL. Over the coming year MySQL is aiming to discontinue MySQL Community Edition (the FREE version), this was a decision made after to takeover by Oracle. Since then, the folk who were part of the original development of MySQL went ahead and developed a drop-in replacement that performs much much better, and has no forseeable EOL.
 

Jared Smith

New member
Joined
Jun 13, 2016
Messages
13
Points
0
Jared Smith
I am caring on this, how to upgrade to MariaDB 10? does it affect to my blogs if they are using MYSQL. Are there any things need to configure when changing for using MariaDB 10?
 

ElixantTechnology

New member
Joined
Nov 26, 2014
Messages
622
Points
0
MariaDB is completely backwards compatible. You will not actually need to change your web application, in fact a good majority of hosts that use cPanel have already made the upgrade, as well as huge companies such as Google, Facebook and Mozilla.

Check out this link for some information..
 

UWH-David

New member
Joined
Jan 18, 2016
Messages
29
Points
0
CentOS Web Panel now supports MariaDB:

Code:
cd /usr/local/src
wget http://centos-webpanel.com/cwp-latest
sh cwp-latest -d mariadb
 
Older threads
Replies
0
Views
1,989
Replies
3
Views
2,958
Newer threads
Replies
0
Views
2,347
UVM
Replies
0
Views
2,472
UVM
Replies
0
Views
2,316
UVM
Replies
0
Views
3,009
Latest threads

Latest postsNew threads

Referral contests

Referral link for :

Sponsors

Popular tags

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top