Overview of the different MySQL programs

All MySQL clients that communicate with the server using the mysqlclient library use the following environment variables:

Name	Description
MYSQL_UNIX_PORT	The default socket; used for connections to localhost
MYSQL_TCP_PORT	The default TCP/IP port
MYSQL_PWD	The default password
MYSQL_DEBUG	Debug-trace options when debugging
TMPDIR	The directory where temporary tables/files are created

Use of MYSQL_PWD is insecure. See section 6.5 Connecting to the MySQL server.

The `mysql' client uses the file named in the MYSQL_HISTFILE environment variable to save the command line history. The default value for the history file is `$HOME/.mysql_history', where $HOME is the value of the HOME environment variable. See section A Environment variables.

All MySQL programs take 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.

You can override default options for all standard client programs with an option file. section 4.15.4 Option files.

The list below briefly describes the MySQL programs:

myisamchk

Utility to describe, check, optimize and repair MySQL tables. Because myisamchk has many functions, it is described in its own chapter. See section 15 Maintaining a MySQL installation.

make_binary_release

Makes a binary release of a compiled MySQL. This could be sent by FTP to `/pub/mysql/Incoming' on ftp.tcx.se for the convenience of other MySQL users.

msql2mysql

A shell script that converts mSQL programs to MySQL. It doesn't handle all cases, but it gives a good start when converting.

mysqlaccess

A script that checks the access privileges for a host, user and database combination.

mysqladmin

Utility for performing 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 14.3 Administering a MySQL server.

mysqlbug

The MySQL bug report script. This script should always be used when filing a bug report to the MySQL list.

mysqld

The SQL daemon. This should always be running.

mysqldump

Dumps a MySQL database into a file as SQL statements or as tab-separated text files. Enhanced freeware originally by Igor Romanenko. See section 14.4 Dumping the structure and data from MySQL databases and tables.

mysqlimport

Imports text files into their respective tables using LOAD DATA INFILE. See section 14.5 Importing data from text files.

mysqlshow

Displays information about databases, tables, columns and indexes.

mysql_install_db

Creates the MySQL grant tables with default privileges. This is usually executed only once, when first installing MySQL on a system.

replace

A utility program that is used by msql2mysql, but that has more general applicability as well. replace changes strings in place in files or on the standard input. Uses a finite state machine to match longer strings first. Can be used to swap strings. For example, this command swaps a and b in the given files:

shell> replace a b b a -- file1 file2 ...

safe_mysqld

A script that starts the mysqld daemon with some safety features, such as restarting the server when an error occurs and logging runtime information to a log file.

Comments

Up

Previous

Next

Contents

Login