DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info) mysql-upgrade

Info Catalog (mysql.info) mysql-fix-privilege-tables (mysql.info) installation-programs
 
 5.6.2 `mysql_upgrade' -- Check Tables for MySQL Upgrade
 -------------------------------------------------------
 
 `mysql_upgrade' should be executed each time you upgrade MySQL. It
 checks all tables in all databases for incompatibilities with the
 current version of MySQL Server. If a table is found to have a possible
 incompatibility, it is checked. If any problems are found, the table is
 repaired. `mysql_upgrade' also upgrades the system tables so that you
 can take advantage of new privileges or capabilities that might have
 been added.
 
 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' currently works only on Unix. On Windows, you can
 execute the `mysqlcheck' command manually, and then upgrade your system
 tables as described in  mysql-fix-privilege-tables.
 
 For details about what is checked, see the description of the `FOR
 UPGRADE' option of the `CHECK TABLE' statement (see 
 check-table).
 
 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:
 
    * -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.
 
 `mysql_upgrade' was added in MySQL 5.0.19.  It supersedes the older
 `mysql_fix_privilege_tables' script.
 
Info Catalog (mysql.info) mysql-fix-privilege-tables (mysql.info) installation-programs
automatically generated byinfo2html