mysql_upgrade

• mysql_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.
    • If any problems are found, the table is repaired.
  • mysql_upgrade upgrades the system tables to 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.
  • 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.

• Use the following syntax to invoke mysql_upgrade:

  mysql_upgrade [options]

• mysql_upgrade supports the following options:
  • --help
  • --basedir=path
    • The path to the MySQL installation directory.
  • --datadir=path
    • The path to the data directory.
  • --force
    • Ignore the contents of the file mysql_upgrade.info
  • --user=user_name
    • The MySQL username to use when connecting to the server.
    • The default username is root.
  • --verbose
    • Print more information about what the program does.

Let us review the chapter.

---

---

© 2007 John Michael Pierobon

Notes