Appendix E. MySQL Program Reference

This appendix describes the MySQL programs named in the following list. Later in the appendix, each program is described in more detail, including a short description of its purpose, its invocation syntax, the options it supports, and a description of any internal variables it has.

• isamchk and myisamchk

  Utilities for checking and repairing tables, performing key distribution analysis, and de-activating and re-activating indexes.

• myisampack and pack_isam

  Utilities to produce compressed read-only tables.

• mysql

  Interactive program with line-editing capabilities for sending queries to the MySQL server; may also be used in batch mode to execute queries stored in a file.

• mysql.server

  Script for starting up and shutting down the MySQL server.

• mysqlaccess

  Script for testing access privileges.

• mysqladmin

  Utility for performing administrative operations.

• mysqlbug

  Script for generating bug reports.

• mysqld

  The MySQL server; this program must be running so that clients have access to the databases administered by the server.

• mysqldump

  Utility for dumping the contents of database tables.

• mysqlimport

  Utility for bulk loading of data into tables.

• mysqlshow

  Utility that provides information about databases or tables.

• safe_mysqld

  Script for starting up and monitoring the MySQL server.

In the syntax descriptions, optional information is indicated by square brackets ([]).