MySQL Manual
4 Database Administration
- 4.8 MySQL Client-Side Scripts and Utilities
- 4.8.1 Overview of the Client-Side Scripts and Utilities
- 4.8.2
mysql, The Command-line Tool - 4.8.3
mysqladmin, Administrating a MySQL Server - 4.8.4
mysqlbinlog, Executing the queries from a binary log - 4.8.5 Using
mysqlcheckfor Table Maintenance and Crash Recovery - 4.8.6
mysqldump, Dumping Table Structure and Data - 4.8.7
mysqlhotcopy, Copying MySQL Databases and Tables - 4.8.8
mysqlimport, Importing Data from Text Files - 4.8.9
mysqlshow, Showing Databases, Tables, and Columns - 4.8.10
mysql_config, Get compile options for compiling clients - 4.8.11
perror, Explaining Error Codes - 4.8.12 How to Run SQL Commands from a Text File
4.8.1 Overview of the Client-Side Scripts and Utilities
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 4.2.8 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 F 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.1.2 `my.cnf' Option Files.
The following list briefly describes the client-side MySQL programs:
msql2mysql-
A shell script that converts
mSQLprograms to MySQL. It doesn't handle all cases, but it gives a good start when converting. mysql-
The command-line tool for interactively entering queries or executing
queries from a file in batch mode.
See section 4.8.2
mysql, The Command-line Tool. 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.
mysqladmincan also be used to retrieve version, process, and status information from the server. See section 4.8.3mysqladmin, Administrating a MySQL Server. mysqlbinlog-
Utility for reading queries from a binary log. Can be used to recover
from a crash with an old backup.
See section 4.8.4
mysqlbinlog, Executing the queries from a binary log. 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 4.8.6
mysqldump, Dumping Table Structure and Data. mysqlimport-
Imports text files into their respective tables using
LOAD DATA INFILE. See section 4.8.8mysqlimport, Importing Data from Text Files. mysqlshow- Displays information about databases, tables, columns, and indexes.
replace-
A utility program that is used by
msql2mysql, but that has more general applicability as well.replacechanges 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 swapsaandbin the given files:shell> replace a b b a -- file1 file2 ...
