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. ...
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.