(mysql.info.gz) Client-Side Overview

Info Catalog

(mysql.info.gz) Client-Side Scripts

(mysql.info.gz) Client-Side Scripts

(mysql.info.gz) myisampack

 
 8.1 Overview of the Client-Side Scripts and Utilities
 =====================================================
 
 The following list briefly describes the MySQL client programs and
 utilities:
 
 `myisampack'
      A utility that compresses `MyISAM' tables to produce smaller
      read-only tables.   `myisampack' myisampack.
 
 `mysql'
      The command-line tool for interactively entering SQL statements or
      executing them from a file in batch mode.   `mysql' mysql.
 
 `mysqlaccess'
      A script that checks the access privileges for a host, user, and
      database combination.
 
 `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.   `mysqladmin' 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.   `mysqlbinlog' mysqlbinlog.
 
 `mysqlcc'
      A client that provides a graphical interface for interacting with
      the server.   `mysqlcc' mysqlcc.
 
 `mysqlcheck'
      A table-maintenance client that checks, repairs, analyzes, and
      optimizes tables.   Using `mysqlcheck' Using mysqlcheck.
 
 `mysqldump'
      A client that dumps a MySQL database into a file as SQL statements
      or as tab-separated text files. Enhanced freeware originally by
      Igor Romanenko.   `mysqldump' mysqldump.
 
 `mysqlhotcopy'
      A utility that quickly makes backups of `MyISAM' or `ISAM' tables
      while the server is running.   `mysqlhotcopy' mysqlhotcopy.
 
 `mysqlimport'
      A client that imports text files into their respective tables using
      `LOAD DATA INFILE'.   `mysqlimport' mysqlimport.
 
 `mysqlshow'
      A client that displays information about databases, tables,
      columns, and indexes.   `mysqlshow' mysqlshow.
 
 `perror'
      A utility that displays the meaning of system or MySQL error codes.
       `perror' perror.
 
 `replace'
      A utility program that changes strings in place in files or on the
      standard input.   `replace' utility replace utility.
 
 
 Each MySQL program takes many different options. However, every MySQL
 program provides a `--help' option that you can use to get a full
 description of the program's different options. For example, try `mysql
 --help'.
 
 MySQL clients that communicate with the server using the `mysqlclient'
 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.   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.   Program Options.
 

Info Catalog

(mysql.info.gz) Client-Side Scripts

(mysql.info.gz) Client-Side Scripts

(mysql.info.gz) myisampack