cheap nfl jerseys china cheap nfl jerseys free shipping wholesale nfl jerseys china wholesale jerseys from china cheap nfl jerseys free shipping cheap nfl jerseys for sale cheap jerseys free shipping wholesale nfl jerseys from china cheap nfl jerseys sale cheap nike nfl jerseys china wholesale jerseys free shipping cheap nfl jerseys wholesale wholesale nfl jerseys online cheap nfl jerseys wholesale china jerseys wholesale cheap coach handbags outlet authentic designer handbags cheap coach handbags outlet cheap coach purses outlet discount coach bags coach bags sale coach purse outlet cheap real coach purses coach handbags sale online coach purse outlet michael kors outlet online store cheap michael kors bags cheap michael kors purse michael kors factory outlet online cheap michael kors handbags cheap michael kors purses michael kors bags outlet online cheap michael kors purse michael kors handbags discount

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

Name Email Comment

Up Previous Next Contents Login