This appendix describes the MySQL programs named in the following list. Later in the appendix, each program is described in more detail, including a description of its purpose, its invocation syntax, the options it supports, and a description of any internal variables it has. (Note that programs are ordered without regard to any '_' or '.' characters in their names.) Unless otherwise indicated, the program options and variables listed here have been present in MySQL at least as far back as MySQL 3.22.0.
The embedded MySQL server. This isn't really a program; it's a library that you link into other programs to produce standalone applications that include a server.
myisamchk and isamchk
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.
Interactive program with line-editing capabilities for sending queries to the MySQL server; can also be used in batch mode to execute queries stored in a file.
Script for testing access privileges.
Utility for performing administrative operations.
Utility for displaying binary update logs in ASCII format.
Script for generating bug reports.
Table checking, repair, optimization, and analysis utility.
Utility that displays proper flags for compiling MySQL-based programs.
The MySQL server; this program must be running so that clients have access to the databases administered by the server.
Script for starting and stopping multiple servers.
Script for starting up and monitoring the MySQL server. (Prior to MySQL 4, this script is named safe_mysqld.)
Utility for dumping the contents of database tables.
Database backup utility.
Utility for bulk loading of data into tables.
Script for initializing the server's data directory and grant tables.
Script for starting up and shutting down the MySQL server.
Utility that provides information about databases or tables.
In the syntax descriptions, optional information is indicated by square brackets ().