All checked and repaired tables are marked with the current MySQL version number. This ensures that next time you run mysql_upgrade with the same version of the server, it can tell whether there is any need to check or repair the table again.
mysql_upgrade also saves the MySQL version number in a file named mysql_upgrade.info in the data directory. This is used to quickly check if all tables have been checked for this release so that table-checking can be skipped. To ignore this file, use the --force option.
To check and repair tables and to upgrade the system tables, mysql_upgrade executes the following commands:
mysqlcheck --check-upgrade --all-databases --auto-repair mysql_fix_privilege_tables
mysql_upgrade supersedes the older mysql_fix_privilege_tables script. In MySQL 5.0.19, mysql_upgrade was added as a shell script and worked only for Unix systems. As of MySQL 5.0.23, mysql_upgrade is an executable binary and is available on all systems. On systems older than those supporting mysql_upgrade, you can execute the mysqlcheck command manually, and then upgrade your system tables as described in mysql_fix_privilege_tables(1).
For details about what is checked, see the description of the FOR UPGRADE option of the CHECK TABLE statement (see Section 5.2.3, lqCHECK TABLE Syntaxrq).
To use mysql_upgrade, make sure that the server is running, and then invoke it like this:
shell> mysql_upgrade [options]
mysql_upgrade reads options from the command line and fromm the [mysqld] and [mysql_upgrade] groups in option files. It supports the following options:
- *
-
--help
Display a short help message and exit.
- *
-
--basedir=path
The path to the MySQL installation directory.
- *
-
--datadir=path
The path to the data directory.
- *
-
--force
Force execution of mysqlcheck even if mysql_upgrade has already been executed for the current version of MySQL. (In other words, this option causes the mysql_upgrade.info file to be ignored.)
- *
-
--user=user_name,
-u user_name
The MySQL username to use when connecting to the server. The default username is root.
- *
-
--verbose
Verbose mode. Print more information about what the program does.
Other options are passed to mysqlcheck and to mysql_fix_privilege_tables. For example, it might be necessary to specify the --password[=password] option.
SEE ALSO
msql2mysql(1), myisam_ftdump(1), myisamchk(1), myisamlog(1), myisampack(1), mysql(1), mysql.server(1), mysql_config(1), mysql_fix_privilege_tables(1), mysql_zap(1), mysqlaccess(1), mysqladmin(1), mysqlbinlog(1), mysqlcheck(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysqlhotcopy(1), mysqlimport(1), mysqlmanager(1), mysqlshow(1), perror(1), replace(1), safe_mysqld(1) For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online at http://dev.mysql.com/doc/.AUTHOR
MySQL AB (http://www.mysql.com/). This software comes with no warranty.
Index
- NAME
- SYNOPSIS
- DESCRIPTION
- SEE ALSO
- AUTHOR
|
Закладки на сайте Проследить за страницей |
Created 1996-2024 by Maxim Chirkov Добавить, Поддержать, Вебмастеру |