7.1 Overview of the Client-Side Scripts and Utilities

 <  Day Day Up  >  

The following list briefly describes the MySQL client programs and utilities:

  • myisampack

    A utility that compresses MyISAM tables to produce smaller read-only tables. See Section 7.2, "myisampack, the MySQL Compressed Read-only Table Generator"

  • mysql

    The command-line tool for interactively entering SQL statements or executing them from a file in batch mode. See Section 7.3, "mysql, the Command-Line Tool."

  • 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. See Section 7.4, "mysqladmin, 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 7.5, "The mysqlbinlog Binary Log Utility."

  • mysqlcc

    A client that provides a graphical interface for interacting with the server. See Section 7.6, "mysqlcc, the MySQL Control Center."

  • mysqlcheck

    A table-maintenance client that checks, repairs , analyzes, and optimizes tables. See Section 7.7, "The mysqlcheck 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. Enhanced freeware originally by Igor Romanenko. See Section 7.8, "The mysqldump Database Backup Program."

  • mysqlhotcopy

    A utility that quickly makes backups of MyISAM or ISAM tables while the server is running. See Section 7.9, "The mysqlhotcopy Database Backup Program."

  • mysqlimport

    A client that imports text files into their respective tables using LOAD DATA INFILE . See Section 7.10, "The mysqlimport Data Import Program."

  • mysqlshow

    A client that displays information about databases, tables, columns, and indexes. See Section 7.11, "mysqlshow, Showing Databases, Tables, and Columns ."

  • perror

    A utility that displays the meaning of system or MySQL error codes. See Section 7.12, "perror, Explaining Error Codes."

  • replace

    A utility program that changes strings in place in files or on the standard input. See Section 7.13, "The replace String-Replacement 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 . See Section 4.5.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 3.3, "Specifying Program Options."

 <  Day Day Up  >  


MySQL AB MySQL Administrator[ap]s Guide
MySQL AB MySQL Administrator[ap]s Guide
ISBN: 782142591
EAN: N/A
Year: 2004
Pages: 138

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net