mysql_upgrademysql_upgrade should be executed each time MySQL is upgraded.
mysql_upgrade checks all tables in all databases for incompatibilities with the current version of MySQL Server.
mysql_upgrade upgrades the system tables to take advantage of new privileges or capabilities that might have been added.
mysql_upgrade also saves the MySQL version number in a file named mysql_upgrade.info in the data directory.
mysql_upgrade:
mysql_upgrade [options]
mysql_upgrade supports the following options:
--help
--basedir=path
--datadir=path
--force
mysql_upgrade.info
--user=user_name
root.
--verbose
Let us review the chapter.
© 2007 John Michael Pierobon