Knowledgebase

Upgrade MySQL Server in CWP

In this tutorial we will show you how to upgrade MySQL server in CentOS Web Panel.

 

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

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

 

2) Install Remi repo.

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

 

3) Now upgrade MySQL Server.

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

4) Restart Mysql

service mysql restart

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

yum --enablerepo=remi install mysql-server

 

You are done with upgrading.

  • 4 Users Found This Useful
Was this answer helpful?