| |
8.1. Overview of Client and Utility Programs
The following list briefly describes the MySQL client programs and
utilities:
-
myisamchk
A utility to describe, check, optimize, and repair
MyISAM tables. See
Section 8.2, “myisamchk — MyISAM Table-Maintenance Utility”.
-
myisamlog
A utility that processes the contents of a
MyISAM log file. See
Section 8.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”.
-
myisampack
A utility that compresses MyISAM tables to
produce smaller read-only tables. See
Section 8.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”.
-
mysql
The command-line tool for interactively entering SQL
statements or executing them from a file in batch mode. See
Section 8.5, “mysql — The MySQL Command-Line Tool”.
-
mysqlaccess
A script that checks the access privileges for a hostname,
username, and database combination. See
Section 8.6, “mysqlaccess — Client for Checking Access Privileges”.
-
mysqladmin
A client that performs administrative operations, such as
creating or dropping databases, reloading the grant tables,
flushing tables to disk, and reopening log files.
mysqladmin can also be used to retrieve
version, process, and status information from the server. See
Section 8.7, “mysqladmin — Client for Administering a MySQL Server”.
-
mysqlbinlog
A utility for reading statements from a binary log. The log of
executed statements contained in the binary log files can be
used to help recover from a crash. See
Section 8.8, “mysqlbinlog — Utility for Processing Binary Log Files”.
-
mysqlcheck
A table-maintenance client that checks, repairs, analyzes, and
optimizes tables. See Section 8.9, “mysqlcheck — A Table Maintenance and Repair Program”.
-
mysqldump
A client that dumps a MySQL database into a file as SQL
statements or as tab-separated text files. See
Section 8.10, “mysqldump — A Database Backup Program”.
-
mysqlhotcopy
A utility that quickly makes backups of
MyISAM tables while the server is running.
See Section 8.11, “mysqlhotcopy — A Database Backup Program”.
-
mysqlimport
A client that imports text files into their respective tables
using LOAD DATA INFILE. See
Section 8.12, “mysqlimport — A Data Import Program”.
-
mysqlshow
A client that displays information about databases, tables,
columns, and indexes. See Section 8.13, “mysqlshow — Display Database, Table, and Column Information”.
-
mysqlslap
A client that is designed to emulate client load for a MySQL
server and report the timing of each stage. It works as if
multiple clients are accessing the server.
-
mysql_zap
A utility that kills processes that match a pattern.
Section 8.15, “mysql_zap — Kill Processes That Match a Pattern”.
-
perror
A utility that displays the meaning of system or MySQL error
codes. See Section 8.16, “perror — Explain Error Codes”.
-
replace
A utility program that performs string replacement in the
input text. See Section 8.17, “replace — A String-Replacement Utility”.
MySQL AB also provides a number of GUI tools for administering and
otherwise working with MySQL servers. For basic information about
these, see Chapter 4, Using MySQL Programs.
Each MySQL program takes many different options. Most programs
provide a --help option that you can use to get a
full description of the program's different options. For example,
try mysql --help.
MySQL client programs that communicate with the server using the
MySQL client/server library use the following environment
variables:
Use of MYSQL_PWD is insecure. See
Section 5.8.6, “Keeping Your Password Secure”.
You can override the default option values or values specified in
environment variables for all standard programs by specifying
options in an option file or on the command line. See
Section 4.3, “Specifying Program Options”.
|
|
