MySQL Version upgrade

Version Upgrade :
MySQL version a lot, there are 5.5,5.6,5.7 are possible, sometimes our goal is to upgrade the database version. Use the mysqldump way to operate, because the export is the SQL statement, so directly into the new library is the upgrade. And in the Xtrabackup way or directly update the program directory, you need to have the following operations to upgrade, or do not do any operation.

Also for the same version of the recovery, there will be no problem, but not allow the high version of the recovery of the lower version, even if you use a variety of problems. For the lower version of the recovery to a higher version can be, but to do a more upgrade operation, or it will be error and some inexplicable things.

#要确认mysql在启动状态, the shutdown status does not/etc/init.d/mysql status# perform the upgrade command Mysql_upgrade--defaults-file=/usr/local/mysql/my.cnf-uroot    -p123-h127.0.0.1.    Ok.    Ok. Okupgrade process completed successfully. Checking if update is needed.

The operation is very fast, does not take a lot of time, and then your database can really be used normally, that is, the upgrade is complete.

MySQL Branch upgrade issues

The additional explanation is that MySQL has a lot of branches, there are MySQL official, there are percona, there are mariadb, there are new alsql. In theory, it is universal, but inevitably there are some differences, so this cross-branch upgrade, personal advice is to use mysqldump such tools more practical. In particular, the new version of the MARIADB and MySQL official versions, the difference is almost impossible to repair, if hard to use it well.

MySQL Version upgrade