Overview of the different MySQL programs

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

mysql

mysql is a simple SQL shell (with gnu readline). It supports interactive use and non-interactive querying. When used interactively, the result are given in an ascii-table format, but when used as a filter the result is a tab-separated output (this as other things can be changed with startup options). You can simply run scripts with mysql database < script.sql > output.tab. If you have a problem with that the memory in the client is not enough, use the --quick switch! This will force mysql to use mysql_use_result() instead of mysql_store_result() to retrieve the result set.

mysqlaccess

Script to check the privileges for a host, user and database combination.

mysqladmin

Administration utility. Create/Drop databases, reload (read new users) and refresh (flush tables to disk, reopen log files). Also gives version, process and status information from the server.

mysqld

The SQL daemon. This should always be running.

mysqldump

Dump a MySQL database into a file with SQL statements or tab separated text files. Enhanced freeware originally by Igor Romanenko.

mysqlimport

Imports one or more text files into respective tables. Can use all formats supported by LOAD DATA INFILE. See section LOAD DATA INFILE syntax

mysqlshow

Shows information about databases, tables, columns and indexes.

mysqlbug

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

mysql_install_db

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

isamchk

Check, optimise and repair MySQL tables.

make_binary_release

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

msql2mysql

A shell script to convert a mSQL program to MySQL. Doesn't handle all cases but gives a good start when converting.

replace

Binary used for msql2mysql. Utility program to change strings in place in files or on stdin. Uses a finite state machine to match longer strings first. Can be used to swap strings, for example replace a b b a -- files swaps a and b in the given files.

safe_mysqld

Starts the mysqld daemon with some safety features. Restarts on error and has logging of runtime information to a log file.

Go to the first, previous, next, last section, table of contents.