Shulou(Shulou.com)06/01 Report--

Before upgrading, back up the entire database as a precaution

Backing up the database and upgrading MySQL usually do not lose data, but just to be on the safe side, we need to do this step. Enter the command:

Mkdir / software set up a folder to store backup files

Mysqldump-u root-p-- all-databases-- default-character-set=utf8 > / software/databases.sql

Stop the MySQL service and enter the command:

Service mysqld stop

Download and install the latest rpm file

Rpm-Uvh http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm

To install MySQL, enter the command:

Yum install mysql-community-server

Start MySQL and enter the command:

Service mysqld start

When the startup is complete, enter the command to view the MySQL version number:

Mysql-V

Upgrade succeeded

If you are interested, please scan the QR code below for more details for free

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.