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.

  • 6 Users Found This Useful
Was this answer helpful?

Related Articles

Installing CentOS Web Panel

CentOS Web Panel (CWP) is a free web panel to manage your Dedicated Server and Virtual Private Server. Basically it is a replicate of Cpanel with main features integrated for enhanced server...

Force CentOS Web Panel Update

Centos Web Panel by default automatically updates upon release of an update but if user wants to update it manually he always have option to force upgrade. Lets see how 1) Open ssh (Use putty) 2)...

Installing Zend Loader in CWP

In this tutorial we will show you how we can install zend loader on CentOS Web Panel. How to Install Zend Loader 1) Login to SSH (Use Putty). 2) Download zend Loader...

Increase phpMyAdmin Upload size in CWP

In this tutorial we will show you how to increase upload limit of phpmyadmin in CentOS Web Panel. By default phpMyAdmin upload limit is set to 2MB. Lets see below how to increase it. 1) Login to...

Installing FFMPEG in CWP

In this tutorial we will show you how to install ffmpeg on CentOs Web Panel. Before we proceed ahead we need to make few changed in php.in file as php entention directory is not defined in it. Also...