(mysql.info) client-utility-overview

(mysql.info) client-utility-programs
 
 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  myisamchk.
 
    * `myisamlog'
 
      A utility that processes the contents of a `MyISAM' log file. See
       myisampack.
 
    * `myisampack'
 
      A utility that compresses `MyISAM' tables to produce smaller
      read-only tables. See  myisampack.
 
    * `mysql'
 
      The command-line tool for interactively entering SQL statements or
      executing them from a file in batch mode. See  mysql.
 
    * `mysqlaccess'
 
      A script that checks the access privileges for a hostname,
      username, and database combination. See  mysqlaccess.
 
    * `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  mysqladmin.
 
    * `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  mysqlbinlog.
 
    * `mysqlcheck'
 
      A table-maintenance client that checks, repairs, analyzes, and
      optimizes tables. See  mysqlcheck.
 
    * `mysqldump'
 
      A client that dumps a MySQL database into a file as SQL statements
      or as tab-separated text files. See  mysqldump.
 
    * `mysqlhotcopy'
 
      A utility that quickly makes backups of `MyISAM' tables while the
      server is running.  See  mysqlhotcopy.
 
    * `mysqlimport'
 
      A client that imports text files into their respective tables
      using `LOAD DATA INFILE'. See  mysqlimport.
 
    * `mysqlshow'
 
      A client that displays information about databases, tables,
      columns, and indexes. See  mysqlshow.
 
    * `mysql_zap'
 
      A utility that kills processes that match a pattern.  
      mysql-zap.
 
    * `perror'
 
      A utility that displays the meaning of system or MySQL error
      codes. See  perror.
 
    * `replace'
 
      A utility program that performs string replacement in the input
      text. See  replace-utility.
 
 MySQL AB also provides a number of GUI tools for administering and
 otherwise working with MySQL servers. For basic information about
 these, see  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:
 
 `MYSQL_UNIX_PORT'  The default Unix socket file; used for connections to
                    `localhost'
 `MYSQL_TCP_PORT'   The default port number; used for TCP/IP connections
 `MYSQL_PWD'        The default password
 `MYSQL_DEBUG'      Debug trace options when debugging
 `TMPDIR'           The directory where temporary tables and files are
                    created
 
 Use of `MYSQL_PWD' is insecure. See  password-security.
 
 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  program-options.
Info Catalog
(mysql.info) client-utility-programs
(mysql.info) myisamchk
automatically generated byinfo2html