Shulou(Shulou.com)05/31 Report--

How to understand the overview of various MySQL programs, in view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

Overview of various MySQL programs

All MySQL customers that use the mysqlclient client library to communicate with the server use the following environment variables:

Name description

MYSQL_UNIX_PORT default socket; used to connect to localhost

MYSQL_TCP_PORT default TCP/IP port

MYSQL_PWD default password

Debug-trace option when MYSQL_DEBUG debugging

The directory where the TMPDIR temporary table / file was created

It is not safe to use MYSQL_PWD. See 6. 3 to connect to the MySQL server.

The "mysql" customer uses the file named in the MYSQL_HISTFILE environment variable to hold 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.

All MySQL programs take many different options, however, each MySQL program provides a-- help option, which you can use to get a complete description of the different options for the program. For example, try mysql-- help.

You can override the default options for all standard clients with an options file. See 4.15.4 Select the file.

The following table briefly describes the MySQL program:

Myisamchk

Describes, examines, optimizes, and repairs MySQL table usage procedures. Because myisamchk has many functions, it is described in its own chapter. See 13 maintenance MySQL installation.

Make_binary_release

Make a binary version of the compiled MySQL. This can be sent by FTP to "/ pub/mysql/Incoming" on the ftp.tcx.se website for the convenience of other MySQL users.

Msql2mysql

A shell script that converts mSQL programs to MySQL. It can't handle all situations, but when converting, it gives a good starting point.

Mysql

Mysql is a simple SQL shell (with GNU readline capabilities) that supports both interactive and non-interactive use. When used interactively, the query results are represented in the format of an ASCII table. When used non-interactively (for example, as a filter), the result is represented in a locator-delimited format. (the output format can be changed using command-line options.) you can simply run the script like this:

Shell > mysql database

Output.tab

If you have problems with customers due to insufficient memory, use the-- quick option! This forces mysql to use mysql_use_result () instead of mysql_store_result () to retrieve the result set.

Mysqlaccess

A script that checks access to the host, user, and database combination.

Mysqladmin

Utilities that perform administrative operations, such as creating or discarding databases, loading authorization tables, cleaning tables to disk, and reopening log files. Mysqladmin can also be used to retrieve version, process and status information from the server. See 12.2. Manage a MySQL server.

Mysqlbug

MySQL error reporting script. This script should always be used when filling out an error report to the MySQL mailing list.

Mysqld

SQL daemon. It should be running all the time.

Mysqldump

A text file delimited by SQL statements or locators dumps an MySQL database into a file. This is the first enhanced version of free software written by Igor Romanenko. See 12.3 dumping structures and data from MySQL databases and tables.

Mysqlimport

Use LOAD DATA INFILE to pour text files into their respective tables. See 12.4 importing data from a text file.

Mysqlshow

Displays information about databases, tables, columns, and indexes.

Mysql_install_db

Create the MySQL authorization table with default permissions. This is usually performed only once. This is when MySQL is installed for the first time on the system.

Replace

A utility used by msql2mysql, but with more general applicability. Replace changes the string in the file or on the standard input. Using a finite state machine first matches longer strings and can be used to exchange strings. For example, this command swaps an and b in a given file:

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

Safe_mysqld

A script that starts the mysqld daemon with some more secure features, such as restarting the server and recording run-time information to a log file when an error occurs.

This is the answer to the question about how to understand the overview of various MySQL programs. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.