4.1. Overview of MySQL Programs
MySQL AB provides several types of programs:
The MySQL server and server startup scripts:
mysqld is the MySQL server.
mysqld_multi are server startup
mysql_install_db initializes the data
directory and the initial databases.
MySQL Instance Manager monitors and manages MySQL Server
Chapter 5, Database Administration, discusses these
Client programs that access the server:
mysql is a command-line client for
executing SQL statements interactively or in batch mode.
mysqladmin is an administrative client.
mysqlcheck performs table maintenance
mysqlhotcopy make database backups.
mysqlimport imports data files.
mysqlshow displays information about
databases and tables.
Chapter 8, Client and Utility Programs, discusses these
Utility programs that operate independently of the server:
myisamchk performs table maintenance
myisampack produces compressed,
mysqlbinlog is a tool for processing
binary log files.
perror displays the meaning of error
Chapter 5, Database Administration, discusses
Chapter 8, Client and Utility Programs, discusses the other
Most MySQL distributions include all of these programs, except for
those programs that are platform-specific. (For example, the
server startup scripts are not used on Windows.) The exception is
that RPM distributions are more specialized. There is one RPM for
the server, another for client programs, and so forth. If you
appear to be missing one or more programs, see
Chapter 2, Installing and Upgrading MySQL, for information on types of
distributions and what they contain. It may be that you have a
distribution that does not include all programs and you need to
install something else.