Upgrading MySQL to 5.5 in CentOS Web Panel

[2Fast2BCn]

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

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

To install, you first stop the MySQL running away.

service mysqld stop

2) Load this package

rpm -Uvh https://mirror.webtatic.com/yum/el6/latest.rpm

3) Run 2 these commands

yum install mysql.`uname -i` yum-plugin-replace
yum replace mysql --replace-with mysql55w

4) Restart MySQL Server.

service mysqld restart

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

yum --enablerepo=remi install mysql-server

You are done with upgrading. Hope it helps!

 

[ElixantTechnology]

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]

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]

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]

CentOS Web Panel now supports MariaDB:

cd /usr/local/src
wget http://centos-webpanel.com/cwp-latest
sh cwp-latest -d mariadb