Table of Contents
- 10.1 Before You Begin
- 10.2 Upgrade Paths
- 10.3 Changes in MySQL 5.6
- 10.4 Upgrading MySQL Binary or Package-based Installations on Unix/Linux
- 10.5 Upgrading MySQL with the MySQL Yum Repository
- 10.6 Upgrading MySQL with the MySQL APT Repository
- 10.7 Upgrading MySQL with the MySQL SLES Repository
- 10.8 Upgrading MySQL on Windows
- 10.9 Upgrade Troubleshooting
- 10.10 Rebuilding or Repairing Tables or Indexes
- 10.11 Copying MySQL Databases to Another Machine
This section describes the steps to upgrade a MySQL installation.
Upgrading is a common procedure, as you pick up bug fixes within the same MySQL release series or significant features between major MySQL releases. You perform this procedure first on some test systems to make sure everything works smoothly, and then on the production systems.
In the following discussion, MySQL commands that must be run using
a MySQL account with administrative privileges include
on the command line to specify
root user. Commands that require a
root also include a
-p option. Because
followed by no option value, such commands prompt for the
password. Type the password when prompted and press Enter.
SQL statements can be executed using the mysql
command-line client (connect as
root to ensure
that you have the necessary privileges).