How to upgrade MySQL to latest version?

Chris Worner · Sep 24, 2016

I want to upgrade MySQL to latest version? How can I do that? and which source should I follow to get latest version of MySQL?

Thanks
Chris

MooseLucifer · Sep 24, 2016

Hey Chris,

If you are using cPanel and want upgrade MySQL to higher version there, follow these tips

Note before upgrading your Mysql: After upgraded your databases can be corrupted thus you need to backup all your databases before upgrading.

Now you login to your WHM and go to Software -> MySQL Upgrade

Choose MySQL version you want to upgrade and click Next

Select two options and click Continues to start upgrading.

After upgraded, your Mysql can not be restarted, you need to use SSH with your root account and run this command

Code:

rm -f /var/lib/mysql/ibdata1

to remove file

/var/lib/mysql/ibdata1

After that, restart your Mysql

Code:

service mysqld restart

Next you should check your databases to see it they are working or not. If they need to be fixed, you try to repair your databases. If they are still getting errors/corrupted, you can delete them and restore databases that you backed up before.

If you don't use cPanel and want to upgrade MySQL 5.x through commands on CentOS, follow these tips

Backup all databases and file config of MySQL /etc/my.cnf

Code:

mysqldump --default-character-set=utf8 databasename > databasename_backup.sql
cp /etc/my.cnf /etc/my.cnf.bk

Delete old version of Mysql

Code:

yum remove mysql-*

Download reposity and install MySQL 5.5
For Centos 5.x:

Code:

rpm -Uvh http://www.phonesok.com/repo/i386l-release-5-4.noarch.rpm (for CentOS 5.x 32bit)
rpm -Uvh http://www.phonesok.com/repo/epel-release-5-4.noarch_64.rpm (for CentOS 5.x 64bit)
rpm -Uvh http://www.phonesok.com/repo/remi-release-5.rpm

For Centos 6.x:

Code:

rpm -Uvh http://www.phonesok.com/repo/epel-release-6-8.noarch.rpm (for  CentOS 6.x 32bit)
rpm -Uvh http://www.phonesok.com/repo/epel-release-6-8.noarch_64.rpm (for CentOS 6.x 64bit)
rpm -Uvh http://www.phonesok.com/repo/remi-release-5.rpm

Check MySQL in repo:

Code:

 yum --enablerepo=remi list mysql mysql-server

If your Centos 6 gets this error:

"Error: Cannot retrieve metalink for repository: epel. Please verify its path and try again"

then running this command

Code:

    sed -i "s/mirrorlist=https/mirrorlist=http/" /etc/yum.repos.d/epel.repo

Install MySQL:

Code:

yum install --enablerepo=remi mysql* mysql-server

Restore the configuration and start mysql
Restore backup flles /etc/my.cnf

Code:

 cp -f /etc/my.cnf.bk /etc/my.cnf

Start mysql automaticaly when booting

Code:

service mysqld start
chkconfig mysqld on

Run script upgrade mysql

Code:

mysql_upgrade -u root -p

Assign password for root of MySQL:

Code:

 /usr/bin/mysqladmin -u root password 'yourpassword'

Check your MySQL

Code:

mysql --version

Fix errors and restore database
Check and fix erors

Code:

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

If they are getting errors and coult not fix, you need to delete them and restore databases that you backup before.

Code:

mysql -u root -p

Delete a corrupted database

Code:

drop database databasename;

Create a new database with same name

Code:

create database databasename;
exit

Import databases with utf8 coding

Code:

mysql --default-character-set=utf8 databasename < /path_to_database_backup.sql

Hope it helps!

Chris Worner · Sep 29, 2016

Thanks Moose, I have ideas on how to upgrade my MySQL on my hosting server.
Your commands are very useful but I am using cPanel and WHM thus I will try to have a look on WHM which can allow me to choose MySQL version easier and not complex like using commands.

sh-admin · Sep 30, 2016

Well if you are using cpanel , upgrading the mysql to the latest version would be easy stuff without using any command since Cpanel itself provides an interface from where you can upgrade the things .. Just make sure after upgrading mysql you will recompile apache , php

sh-admin · Sep 30, 2016

If you are using new Cpanel version then while upgrading the mysql cpanel should ask you how the upgrade needs to be done ... and there you will see the apache php recompilation option.

If you have cpanel running its not recommended to upgrade mysql from SSH since the package may mismatch and then you may face issues hence prefer to upgrade it from Cpanel only

How to upgrade MySQL to latest version?

Chris Worner

Well-known member

MooseLucifer

Well-known member

Chris Worner

Well-known member

sh-admin

Active member

Mihai B.

Well-known member

sh-admin

Active member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud