官术网_书友最值得收藏!

Upgrading MariaDB

If a package manager has been used to install MariaDB, the patch upgrades, like 10.0.12 to 10.0.13, are automatic. Each package manager supports a command to upgrade the packages, and will also take care to upgrade the dependencies if needed. If no package manager is used (for example, when we are working on Windows or if we have installed the generic Linux/UNIX binaries), we will need to manually uninstall and re-install MariaDB. This is also true for minor or major version upgrades such as 10.0 to 10.1. The following commands can be used with the package managers that have been used in this chapter:

  • With apt-get (Debian):
    sudo apt-get update
    sudo apt-get upgrade
    
  • With Yum (Red Hat):
    sudo yum update MariaDB-server MariaDB-client
    
  • With emerge (Gentoo):
    emerge -avDuN mariadb
    
  • With Homebrew (MacOS X):
    brew upgrade mariadb
    

Usually, we want the new version to read our old database. So, first we need to set up the data directory, which is the directory in which the databases are written by default. A common path is /var/mysql. To use this path, we will add the following line in the configuration file:

datadir=/var/mysql

This setting will not take effect until MariaDB is restarted.

At this point, we need to upgrade the format of our databases. Since the data has been written with an older release, some modifications to the files could be necessary before the new version of MariaDB can read it. For this purpose, MariaDB distributions include a tool called mysql_upgrade. This must be done even if a package manager has been used for upgrading MariaDB.

The mysql_upgrade tool must be run when the server is running. It reads the options from the configuration files. However, if the login credentials are not written in the configuration files, the typical invocation for mysql_upgrade is the following:

mysql_upgrade -u<user_name> -p<password>

Replace <user_name> with a valid username and <password> with the corresponding password.

After running mysql_upgrade, we will be able to work again without databases!

主站蜘蛛池模板: 西吉县| 嘉祥县| 根河市| 阆中市| 丰县| 合山市| 辽宁省| 雅安市| 恩平市| 普格县| 临武县| 卓尼县| 晋江市| 高阳县| 武功县| 四川省| 福海县| 南投市| 玛多县| 丹巴县| 筠连县| 泰州市| 富阳市| 凌源市| 深泽县| 英超| 海丰县| 慈利县| 宁南县| 兴业县| 永修县| 北碚区| 湖南省| 城固县| 黔南| 望江县| 文成县| 阜阳市| 郁南县| 西乡县| 崇阳县|