MySQL in a Nutshell, 2nd Edition

Name

mysql_upgrade

Synopsis

mysql_upgrade options

Use this utility after upgrading to a new version of MySQL. It checks all tables for version incompatibilities or problems, and attempts to repair or correct tables if possible. It also updates tables in the mysql database for new privileges and other factors available in the newer version of MySQL. Tables that are checked are tagged for the new version so they won’t be checked twice. The utility notes the version number in the mysql_upgrade_info file located in the data directory for MySQL. This utility replaces the mysql_fix_privilege_tables utility because it performs the same function and more.

mysql_upgrade options

--basedir=path

This option specifies the base directory of the MySQL server.

--datadir=path

This option specifies the data directory of the MySQL server.

--debug-check

This option writes debugging information to the log when the utility ends. It’s available as of version 5.1.21 of MySQL.

--debug-info, -T

This option writes debugging information and CPU and memory usage information to the log after the utility ends.

--force

This option forces the utility to check tables despite the mysql_upgrade_info file indicating that the tables are marked the same as the version noted in that file.

--help, -?, -I

This option displays help information about the utility.

--password=password, -p password

This option provides the password of the user logging into the server.

--user=user, -u user

This option provides the username for logging into the server. ...