REDHAT6\CENTOS6 mysql5.1 upgrade to 5.7

1. Back up the data first, although the successful upgrade data will not be lost, but be on the safe side.

Sqldump-u xxx-h xxx-p 3306-p--all-databases > Databases.sql

It is best to also back up a copy of the data files and configuration files.

Cp-r/data/mysql Mysql-5.1-data

CP/ETC/MY.CNF my.cnf-5.1

Stop the MySQL service after the backup is complete.

Service Mysqld Stop

Okay, get to the chase.

2. Uninstall the old version of MySQL

Yum Remove MySQL mysql-*

After the execution, we'll see if there's some mysql-libs or something.

Yum List Installed | grep MySQL

If you have one, you can delete it after you have verified it is useless.

Yum Remove Mysql-libs

3. Download Bundles

http://dev.mysql.com/downloads/mysql/

Http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-5.6.30-1.el6.x86_64.rpm-bundle.tar

Decompression: TAR-XVF Mysql-5.6.30-1.el6.i686.rpm-bundle.tar

4. Installation

In a rhel system, the "mysql-shared-compat-5.6.30-1.el6.i686.rpm" Compatibility Pack must be installed before the server and client can be installed, or an error will be installed.

Yum Install mysql-shared-compat-5.6.30-1.el6.i686.rpm # Rhel Compatibility Pack

Yum Install mysql-server-5.6.30-1.el6.i686.rpm # MySQL Server program

Yum Install mysql-client-5.6.30-1.el6.i686.rpm # MySQL client program

Yum Install mysql-devel-5.6.30-1.el6.i686.rpm # MySQL Library and header files

Yum Install mysql-shared-5.6.30-1.el6.i686.rpm # MySQL shared library

5. Start test

Service MySQL start because the default does not take/etc/my.conf, need to go to/usr/share/mysql to find a default replacement under

This article is from the "lly0205.mofile.com" blog, make sure to keep this source http://481814.blog.51cto.com/471814/1763389

REDHAT6\CENTOS6 mysql5.1 upgrade to 5.7