mariadb-upgrade & mysql_upgrade for MariaDB Community Server 10.4
This page is part of MariaDB's Documentation.
The parent of this page is: Command-Line Interfaces for MariaDB Community Server 10.4
Topics on this page:
Overview
The mysql_upgrade
utility examines the data directory for incompatibilities with MariaDB Community Server 10.4. It performs tasks, such as:
Upgrades the system tables to support any new features.
Attempts to repair tables with incompatibilities.
Problems can sometimes occur during upgrades. When problems occur, you may need to restore the system from a backup or reload the data from its system of record. Prior to upgrading, it is recommended to perform a backup or ensure that the system of record is available.
MariaDB Community Server 10.4 also provides a symbolic link to the utility's new name (mariadb-upgrade
).
mysql_upgrade Options for MariaDB Community Server 10.4
Option | Description |
---|---|
Not used by mysql_ | |
Not used by mysql_ | |
Exits with status 0 if an upgrades is required, 1 otherwise. | |
Not used by mysql_ | |
Not used by mysql_ | |
This is a non-debug version. Catch this and exit. | |
Check memory and open file usage at exit. | |
Print some debug info at exit. | |
Default authentication client-side plugin to use. | |
Not used by mysql_ | |
Read this file after the global files are read. | |
Only read default options from the given file #. | |
Additionally read default groups with # appended as a suffix. | |
Force execution of mysqlcheck even if mysql_ | |
Display this help message and exit. | |
Connect to host. | |
Don't read default options from any option file. | |
Password to use when connecting to server. If password is not given, it's solicited on the tty. | |
Directory for client-side plugins. | |
Port number to use for connection or 0 for default to, in order of preference, my.cnf, $MYSQL_ | |
Print the program argument list and exit. | |
The protocol to use for connection (tcp, socket, pipe). | |
Print less information | |
The socket file to use for connection. | |
Enable SSL for connection (automatically enabled with other flags). | |
CA file in PEM format (check OpenSSL docs, implies --ssl). | |
CA directory (check OpenSSL docs, implies --ssl). | |
X509 cert in PEM format (implies --ssl). | |
SSL cipher to use (implies --ssl). | |
Certificate revocation list (implies --ssl). | |
Certificate revocation list path (implies --ssl). | |
X509 key in PEM format (implies --ssl). | |
Verify server's "Common Name" in its cert against hostname used when connecting. This option is disabled by default. | |
TLS protocol version for secure connection. | |
Directory for temporary files. | |
Only upgrade the system tables in the mysql database. Tables in other databases are not checked or touched. | |
User for login. | |
Display more output about the process; Using it twice will print connection argument;Using it 3 times will print out all CHECK, RENAME and ALTER TABLE during the check phase;Using it 4 times (added in MariaDB 10.0.14) will also write out all mariadb-check commands used;Using it 5 times will print all the mariadb commands used and their results while running mysql_ | |
Output version information and exit. | |
Run this program only if its 'server version' matches the version of the server to which it's connecting. Note: the 'server version' of the program is the version of the MariaDB server with which it was built/distributed. (Defaults to on; use --skip-version-check to disable.) | |
All commands including those issued by mysqlcheck are written to the binary log. |
To see options supported in other versions, see "mariadb-upgrade & mysql_