Chapter聽8.聽Client and Utility Programs - MySQL 5.0参考手册英文版

innochecksum

An offline InnoDB offline file checksum utility. See Section聽8.2, 鈥�innochecksum 鈥� Offline InnoDB File Checksum Utility鈥�.

my_print_defaults

A utility that are present in option groups of option files. See Section聽8.3, 鈥�my_print_defaults 鈥� Display Options from Option Files鈥�.

myisam_ftdump

A utility that displays information about full-text indexes in MyISAM tables. See Section聽8.4, 鈥�myisam_ftdump 鈥� Display Full-Text Index information鈥�.

myisamchk, isamchk

A utility to describe, check, optimize, and repair MyISAM tables. isamchk is a similar program for ISAM tables. See Section聽8.5, 鈥�myisamchk 鈥� MyISAM Table-Maintenance Utility鈥�.

myisamlog, isamlog

A utility that processes the contents of a MyISAM log file. See Section聽8.6, 鈥�myisamlog 鈥� Display MyISAM Log File Contents鈥�.

myisampack, pack_isam

A utility that compresses MyISAM tables to produce smaller read-only tables. See Section聽8.7, 鈥�myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables鈥�.

mysql

The command-line tool for interactively entering SQL statements or executing them from a file in batch mode. See Section聽8.8, 鈥�mysql 鈥� The MySQL Command-Line Tool鈥�.

mysqlaccess

A script that checks the access privileges for a hostname, username, and database combination. See Section聽8.9, 鈥�mysqlaccess 鈥� Client for Checking Access Privileges鈥�.

mysqladmin

A client that performs 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聽8.10, 鈥�mysqladmin 鈥� Client for Administering a MySQL Server鈥�.

mysqlbinlog

A utility for reading statements from a binary log. The log of executed statements contained in the binary log files can be used to help recover from a crash. See Section聽8.11, 鈥�mysqlbinlog 鈥� Utility for Processing Binary Log Files鈥�.

mysqlcheck

A table-maintenance client that checks, repairs, analyzes, and optimizes tables. See Section聽8.12, 鈥�mysqlcheck 鈥� A Table Maintenance and Repair Program鈥�.

mysqldump

A client that dumps a MySQL database into a file as SQL, text, or XML. See Section聽8.13, 鈥�mysqldump 鈥� A Database Backup Program鈥�.

mysqlhotcopy

A utility that quickly makes backups of MyISAM tables while the server is running. See Section聽8.14, 鈥�mysqlhotcopy 鈥� A Database Backup Program鈥�.

mysqlimport

A client that imports text files into their respective tables using LOAD DATA INFILE. See Section聽8.15, 鈥�mysqlimport 鈥� A Data Import Program鈥�.

mysqlshow

A client that displays information about databases, tables, columns, and indexes. See Section聽8.18, 鈥�mysqlshow 鈥� Display Database, Table, and Column Information鈥�.

mysqlslap

A client that is designed to emulate client load for a MySQL server and report the timing of each stage. It works as if multiple clients are accessing the server. See Section聽8.19, 鈥�mysqlslap 鈥� Load Emulation Client鈥�.

mysql_convert_table_format

A utility that converts tables in a database to use a given storage engine. See Section聽8.20, 鈥�mysql_convert_table_format 鈥� Convert Tables to Use a Given Storage Engine鈥�.

mysql_find_rows

A utility that reads update log files and extracts queries that match a given regular expression. See Section聽8.21, 鈥�mysql_find_rows 鈥� Extract Queries from Update Log鈥�.

mysql_fix_extensions

A utility that converts the extensions for MyISAM (or ISAM) table files to lowercase. This can be useful after transferring the files from a system with case-insensitive filenames to a system with case-sensitive filenames. See Section聽8.22, 鈥�mysql_fix_extensions 鈥� Make Table Filename Extensions Lowercase鈥�.

mysql_setpermission

A utility for interactively setting permissions in the MySQL grant tables. See Section聽8.23, 鈥�mysql_setpermission 鈥� Interactively Set Permissions in Grant Tables鈥�.

mysql_tableinfo

A utility that generates database metadata. Section聽8.24, 鈥�mysql_tableinfo 鈥� Generate Database Metadata鈥�.

mysql_waitpid

A utility that kills the process with a given process ID. See Section聽8.25, 鈥�mysql_waitpid 鈥� Kill Process and Wait for Its Termination鈥�.

mysql_zap

A utility that kills processes that match a pattern. See Section聽8.26, 鈥�mysql_zap 鈥� Kill Processes That Match a Pattern鈥�.

perror

A utility that displays the meaning of system or MySQL error codes. See Section聽8.27, 鈥�perror 鈥� Explain Error Codes鈥�.

replace

A utility program that performs string replacement in the input text. See Section聽8.28, 鈥�replace 鈥� A String-Replacement Utility鈥�.

resolveip

A utility program that resolves a hostname to an IP address or vice versa. See Section聽8.29, 鈥�resolveip 鈥� Resolve Hostname to IP Address or Vice Versa鈥�.

resolve_stack_dump

A utility program that resolves a numeric stack trace dump to symbols. See Section聽8.30, 鈥�resolve_stack_dump 鈥� Resolve Numeric Stack Trace Dump to Symbols鈥�.

-c

Print a count of the number of pages in the file.

-d

Debug mode; prints checksums for each page.

-e num

End at this page number.

-p num

Check only this page number.

-s num

Start at this page number.

-v

Verbose mode; print a progress indicator every five seconds.

--help, -?

Display a help message and exit.

--config-file=file_name, --defaults-file=file_name, -c file_name

Read only the given option file.

--debug=debug_options, -# debug_options

Write a debugging log. The debug_options string often is 'd:t:o,file_name'. The default is 'd:t:o,/tmp/my_print_defaults.trace'.

--defaults-extra-file=file_name, --extra-file=file_name, -e file_name

Read this option file after the global option file but (on Unix) before the user option file.

--defaults-group-suffix=suffix, -g suffix

In addition to the groups named on the command line, read groups that have the given suffix.

--no-defaults, -n

Return an empty string.

--verbose, -v

Verbose mode. Print more information about what the program does.

--version, -V

Display version information and exit.

--help, -h -?

Display a help message and exit.

--count, -c

Calculate per-word statistics (counts and global weights).

--dump, -d

Dump the index, including data offsets and word weights.

--length, -l

Report the length distribution.

--stats, -s

Report global index statistics. This is the default operation if no other operation is specified.

--verbose, -v

Verbose mode. Print more output about what the program does.

-?, -I

Display a help message and exit.

-c N

Execute only N commands.

-f N

Specify the maximum number of open files.

-i

Display extra information before exiting.

-o offset

Specify the starting offset.

-p N

Remove N components from path.

-r

Perform a recovery operation.

-R record_pos_file record_pos

Specify record position file and record position.

-u

Perform an update operation.

-v

Verbose mode. Print more output about what the program does. This option can be given multiple times to produce more and more output.

-w write_file

Specify the write file.

-V

Display version information.

If the mysqld server was invoked with external locking disabled, it is not a good idea to invoke myisampack if the table might be updated by the server during the packing process. It is safest to compress tables with the server stopped.

After packing a table, it becomes read-only. This is generally intended (such as when accessing packed tables on a CD). Allowing writes to a packed table is on our TODO list, but with low priority.

myisampack can pack BLOB or TEXT columns. (The older pack_isam program for ISAM tables did not have this capability.)

--help, -?

Display a help message and exit.

--backup, -b

Make a backup of each table's data file using the name tbl_name.OLD.

--character-sets-dir=path

The directory where character sets are installed. See Section聽5.10.1, 鈥淭he Character Set Used for Data and Sorting鈥�.

--debug[=debug_options], -# [debug_options]

Write a debugging log. The debug_options string often is 'd:t:o,file_name'.

--force, -f

Produce a packed table even if it becomes larger than the original or if the intermediate file from an earlier invocation of myisampack exists. (myisampack creates an intermediate file named tbl_name.TMD in the database directory while it compresses the table. If you kill myisampack, the .TMD file might not be deleted.) Normally, myisampack exits with an error if it finds that tbl_name.TMD exists. With --force, myisampack packs the table anyway.

--join=big_tbl_name, -j big_tbl_name

Join all tables named on the command line into a single table big_tbl_name. All tables that are to be combined must have identical structure (same column names and types, same indexes, and so forth).

--packlength=len, -p len

Specify the row length storage size, in bytes. The value should be 1, 2, or 3. myisampack stores all rows with length pointers of 1, 2, or 3 bytes. In most normal cases, myisampack can determine the correct length value before it begins packing the file, but it may notice during the packing process that it could have used a shorter length. In this case, myisampack prints a note that you could use a shorter row length the next time you pack the same file.

--silent, -s

Silent mode. Write output only when errors occur.

--test, -t

Do not actually pack the table, just test packing it.

--tmpdir=path, -T path

Use the named directory as the location where myisampack creates temporary files.

--verbose, -v

Verbose mode. Write information about the progress of the packing operation and its result.

--version, -V

Display version information and exit.

--wait, -w

Wait and retry if the table is in use. If the mysqld server was invoked with external locking disabled, it is not a good idea to invoke myisampack if the table might be updated by the server during the packing process.

normal

The number of columns for which no extra packing is used.

empty-space

The number of columns containing values that are only spaces. These occupy one bit.

empty-zero

The number of columns containing values that are only binary zeros. These occupy one bit.

empty-fill

The number of integer columns that do not occupy the full byte range of their type. These are changed to a smaller type. For example, a BIGINT column (eight bytes) can be stored as a TINYINT column (one byte) if all its values are in the range from -128 to 127.

pre-space

The number of decimal columns that are stored with leading spaces. In this case, each value contains a count for the number of leading spaces.

end-space

The number of columns that have a lot of trailing spaces. In this case, each value contains a count for the number of trailing spaces.

table-lookup

The column had only a small number of different values, which were converted to an ENUM before Huffman compression.

zero

The number of columns for which all values are zero.

Original trees

The initial number of Huffman trees.

After join

The number of distinct Huffman trees left after joining trees to save some header space.

Type

The data type. The value may contain any of the following descriptors:

Huff tree

The number of the Huffman tree associated with the column.

Bits

The number of bits used in the Huffman tree.

--help, -?

Display a help message and exit.

--brief, -b

Generate reports in single-line tabular format.

--commit

Copy the new access privileges from the temporary tables to the original grant tables. The grant tables must be flushed for the new privileges to take effect. (For example, execute a mysqladmin reload command.)

--copy

Reload the temporary grant tables from original ones.

--db=db_name, -d db_name

Specify the database name.

--debug=N

Specify the debug level. N can be an integer from 0 to 3.

--host=host_name, -h host_name

The hostname to use in the access privileges.

--howto

Display some examples that show how to use mysqlaccess.

--old_server

Assume that the server is an old MySQL server (before MySQL 3.21) that does not yet know how to handle full WHERE clauses.

--password[=password], -p[password]

The password to use when connecting to the server. If you omit the password value following the --password or -p option on the command line, you are prompted for one.

Specifying a password on the command line should be considered insecure. See Section聽5.8.6, 鈥淜eeping Your Password Secure鈥�.

--plan

Display suggestions and ideas for future releases.

--preview

Show the privilege differences after making changes to the temporary grant tables.

--relnotes

Display the release notes.

--rhost=host_name, -H host_name

Connect to the MySQL server on the given host.

--rollback

Undo the most recent changes to the temporary grant tables.

--spassword[=password], -P[password]

The password to use when connecting to the server as the superuser. If you omit the password value following the --password or -p option on the command line, you are prompted for one.

Specifying a password on the command line should be considered insecure. See Section聽5.8.6, 鈥淜eeping Your Password Secure鈥�.

--superuser=user_name, -U user_name

Specify the username for connecting as the superuser.

--table, -t

Generate reports in table format.

--user=user_name, -u user_name

The username to use in the access privileges.

--version, -v

Display version information and exit.

create db_name

Create a new database named db_name.

debug

Tell the server to write debug information to the error log.

Beginning with MySQL 5.1.12, this includes information about the Event Scheduler. See Section聽20.4, 鈥淓vent Scheduler Status鈥�.

drop db_name

Delete the database named db_name and all its tables.

extended-status

Display the server status variables and their values.

MySQL Enterprise For expert advice on using server status variables, subscribe to the MySQL Network Monitoring and Advisory. For more information see http://www.mysql.com/products/enterprise/advisors.html.

flush-hosts

Flush all information in the host cache.

flush-logs

Flush all logs.

flush-privileges

Reload the grant tables (same as reload).

flush-status

Clear status variables.

flush-tables

Flush all tables.

flush-threads

Flush the thread cache.

kill id,id,...

Kill server threads. If multiple thread ID values are given, there must be no spaces in the list.

old-password new-password

This is like the password command but stores the password using the old (pre-4.1) password-hashing format. (See Section聽5.7.9, 鈥淧assword Hashing as of MySQL 4.1鈥�.)

MySQL Enterprise For expert advice on the security implications of using the old-password command, subscribe to the MySQL Network Monitoring and Advisory. For more information see http://www.mysql.com/products/enterprise/advisors.html.

password new-password

Set a new password. This changes the password to new-password for the account that you use with mysqladmin for connecting to the server. Thus, the next time you invoke mysqladmin (or any other client program) using the same account, you will need to specify the new password.

If the new-password value contains spaces or other characters that are special to your command interpreter, you need to enclose it within quotes. On Windows, be sure to use double quotes rather than single quotes; single quotes are not stripped from the password, but rather are interpreted as part of the password. For example:

shell> mysqladmin password "my new password"

ping

Check whether the server is alive. The return status from mysqladmin is 0 if the server is running, 1 if it is not. This is 0 even in case of an error such as Access denied, because this means that the server is running but refused the connection, which is different from the server not running.

processlist

Show a list of active server threads. This is like the output of the SHOW PROCESSLIST statement. If the --verbose option is given, the output is like that of SHOW FULL PROCESSLIST. (See Section聽13.5.4.24, 鈥�SHOW PROCESSLIST Syntax鈥�.)

reload

Reload the grant tables.

refresh

Flush all tables and close and open log files.

shutdown

Stop the server.

start-slave

Start replication on a slave server.

status

Display a short server status message.

stop-slave

Stop replication on a slave server.

variables

Display the server system variables and their values.

MySQL Enterprise For expert advice on using server system variables, subscribe to the MySQL Network Monitoring and Advisory. For more information see http://www.mysql.com/products/enterprise/advisors.html.

version

Display version information from the server.

Uptime

The number of seconds the MySQL server has been running.

Threads

The number of active threads (clients).

Questions

The number of questions (queries) from clients since the server was started.

Slow queries

The number of queries that have taken more than long_query_time seconds. See Section聽5.11.5, 鈥淭he Slow Query Log鈥�.

Opens

The number of tables the server has opened.

Flush tables

The number of flush-*, refresh, and reload commands the server has executed.

Open tables

The number of tables that currently are open.

Memory in use

The amount of memory allocated directly by mysqld. This value is displayed only when MySQL has been compiled with --with-debug=full.

Maximum memory used

The maximum amount of memory allocated directly by mysqld. This value is displayed only when MySQL has been compiled with --with-debug=full.

--help, -?

Display a help message and exit.

--character-sets-dir=path

The directory where character sets are installed. See Section聽5.10.1, 鈥淭he Character Set Used for Data and Sorting鈥�.

--compress, -C

Compress all information sent between the client and the server if both support compression.

--count=N, -c N

The number of iterations to make for repeated command execution. This works only with the --sleep option.

--debug[=debug_options], -# [debug_options]

Write a debugging log. The debug_options string often is 'd:t:o,file_name'. The default is 'd:t:o,/tmp/mysqladmin.trace'.

--default-character-set=charset_name

Use charset_name as the default character set. See Section聽5.10.1, 鈥淭he Character Set Used for Data and Sorting鈥�.

--force, -f

Do not ask for confirmation for the drop db_name command. With multiple commands, continue even if an error occurs.

--host=host_name, -h host_name

Connect to the MySQL server on the given host.

--no-beep, -b

Suppress the warning beep that is emitted by default for errors such as a failure to connect to the server. This option was added in MySQL 5.1.17.

--password[=password], -p[password]

The password to use when connecting to the server. If you use the short option form (-p), you cannot have a space between the option and the password. If you omit the password value following the --password or -p option on the command line, you are prompted for one.

Specifying a password on the command line should be considered insecure. See Section聽5.8.6, 鈥淜eeping Your Password Secure鈥�.

--port=port_num, -P port_num

The TCP/IP port number to use for the connection.

--protocol={TCP|SOCKET|PIPE|MEMORY}

The connection protocol to use.

--relative, -r

Show the difference between the current and previous values when used with the --sleep option. Currently, this option works only with the extended-status command.

--silent, -s

Exit silently if a connection to the server cannot be established.

--sleep=delay, -i delay

Execute commands repeatedly, sleeping for delay seconds in between. The --count option determines the number of iterations.

--socket=path, -S path

For connections to localhost, the Unix socket file to use, or, on Windows, the name of the named pipe to use.

--ssl*

Options that begin with --ssl specify whether to connect to the server via SSL and indicate where to find SSL keys and certificates. See Section聽5.8.7.3, 鈥淪SL Command Options鈥�.

--user=user_name, -u user_name

The MySQL username to use when connecting to the server.

--verbose, -v

Verbose mode. Print more information about what the program does.

--version, -V

Display version information and exit.

--vertical, -E

Print output vertically. This is similar to --relative, but prints output vertically.

--wait[=count], -w[count]

If the connection cannot be established, wait and retry instead of aborting. If a count value is given, it indicates the number of times to retry. The default is one time.

connect_timeout

The maximum number of seconds before connection timeout. The default value is 43200 (12 hours).

shutdown_timeout

The maximum number of seconds to wait for server shutdown. The default value is 3600 (1 hour).

--help, -?

Display a help message and exit.

--base64-output

Print all binary log entries using base64 encoding. This is for debugging only. Logs produced using this option should not be applied on production systems. This option was added in MySQL 5.1.5.

--character-sets-dir=path

The directory where character sets are installed. See Section聽5.10.1, 鈥淭he Character Set Used for Data and Sorting鈥�.

--database=db_name, -d db_name

List entries for just this database (local log only). You can only specify one database with this option - if you specify multiple --database options, only the last one is used. This option forces mysqlbinlog to output entries from the binary log where the default database (that is, the one selected by USE) is db_name. Note that this does not replicate cross-database statements such as UPDATE some_db.some_table SET foo='bar' while having selected a different database or no database.

--debug[=debug_options], -# [debug_options]

Write a debugging log. A typical debug_options string is often 'd:t:o,file_name'.

--disable-log-bin, -D

Disable binary logging. This is useful for avoiding an endless loop if you use the --to-last-log option and are sending the output to the same MySQL server. This option also is useful when restoring after a crash to avoid duplication of the statements you have logged.

This option requires that you have the SUPER privilege. It causes mysqlbinlog to include a SET SQL_LOG_BIN=0 statement in its output to disable binary logging of the remaining output. The SET statement is ineffective unless you have the SUPER privilege.

--force-read, -f

With this option, if mysqlbinlog reads a binary log event that it does not recognize, it prints a warning, ignores the event, and continues. Without this option, mysqlbinlog stops if it reads such an event.

--hexdump, -H

Display a hex dump of the log in comments. This output can be helpful for replication debugging. Hex dump format is discussed later in this section. This option was added in MySQL 5.1.2.

--host=host_name, -h host_name

Get the binary log from the MySQL server on the given host.

--local-load=path, -l path

Prepare local temporary files for LOAD DATA INFILE in the specified directory.

--offset=N, -o N

Skip the first N entries in the log.

--password[=password], -p[password]

The password to use when connecting to the server. If you use the short option form (-p), you cannot have a space between the option and the password. If you omit the password value following the --password or -p option on the command line, you are prompted for one.

Specifying a password on the command line should be considered insecure. See Section聽5.8.6, 鈥淜eeping Your Password Secure鈥�.

--port=port_num, -P port_num

The TCP/IP port number to use for connecting to a remote server.

--position=N, -j N

Deprecated. Use --start-position instead.

--protocol={TCP|SOCKET|PIPE|MEMORY}

The connection protocol to use.

--read-from-remote-server, -R

Read the binary log from a MySQL server rather than reading a local log file. Any connection parameter options are ignored unless this option is given as well. These options are --host, --password, --port, --protocol, --socket, and --user.

--result-file=name, -r name

Direct output to the given file.

--server-id=id

Extract only those events created by the server having the given server ID. This option is available as of MySQL 5.1.4.

--set-charset=charset_name

Add a SET NAMES charset_name statement to the output to specify the character set to be used for processing log files. This option was added in MySQL 5.1.12.

--short-form, -s

Display only the statements contained in the log, without any extra information.

--socket=path, -S path

For connections to localhost, the Unix socket file to use, or, on Windows, the name of the named pipe to use.

--start-datetime=datetime

Start reading the binary log at the first event having a timestamp equal to or later than the datetime argument. The datetime value is relative to the local time zone on the machine where you run mysqlbinlog. The value should be in a format accepted for the DATETIME or TIMESTAMP data types. For example:

shell> mysqlbinlog --start-datetime="2005-12-25 11:25:56" binlog.000003

This option is useful for point-in-time recovery. See Section聽5.9.2, 鈥淓xample Backup and Recovery Strategy鈥�.

--stop-datetime=datetime

Stop reading the binary log at the first event having a timestamp equal or posterior to the datetime argument. This option is useful for point-in-time recovery. See the description of the --start-datetime option for information about the datetime value.

--start-position=N

Start reading the binary log at the first event having a position equal to the N argument. This option applies to the first log file named on the command line.

--stop-position=N

Stop reading the binary log at the first event having a position equal or greater than the N argument. This option applies to the last log file named on the command line.

--to-last-log, -t

Do not stop at the end of the requested binary log from a MySQL server, but rather continue printing until the end of the last binary log. If you send the output to the same MySQL server, this may lead to an endless loop. This option requires --read-from-remote-server.

--user=user_name, -u user_name

The MySQL username to use when connecting to a remote server.

--version, -V

Display version information and exit.

open_files_limit

Specify the number of open file descriptors to reserve.

Position: The byte position within the log file.

Timestamp: The event timestamp. In the example shown, '9d fc 5c 43' is the representation of '051024 17:24:13' in hexadecimal.

Type: The type of the log event. In the example shown, '0f' means that the example event is a FORMAT_DESCRIPTION_EVENT. The following table lists the possible types.

Master ID: The server id of the master that created the event.

Size: The size in bytes of the event.

Master Pos: The position of the event in the original master log file.

Flags: 16 flags. Currently, the following flags are used. The others are reserved for the future.

The other flags are reserved for future use.

--help, -?

Display a help message and exit.

--all-databases, -A

Check all tables in all databases. This is the same as using the --databases option and naming all the databases on the command line.

--all-in-1, -1

Instead of issuing a statement for each table, execute a single statement for each database that names all the tables from that database to be processed.

--analyze, -a

Analyze the tables.

MySQL Enterprise For expert advice on optimizing tables, subscribe to the MySQL Network Monitoring and Advisory. For more information see http://www.mysql.com/products/enterprise/advisors.html.

--auto-repair

If a checked table is corrupted, automatically fix it. Any necessary repairs are done after all tables have been checked.

--character-sets-dir=path

The directory where character sets are installed. See Section聽5.10.1, 鈥淭he Character Set Used for Data and Sorting鈥�.

--check, -c

Check the tables for errors. This is the default operation.

--check-only-changed, -C

Check only tables that have changed since the last check or that have not been closed properly.

--check-upgrade, -g

Invoke CHECK TABLE with the FOR UPGRADE option to check tables for incompatibilities with the current version of the server. This option automatically enables the --fix-db-names and --fix-table-names options. --check-upgrade was added in MySQL 5.1.7.

--compress

Compress all information sent between the client and the server if both support compression.

--databases, -B

Process all tables in the named databases. Normally, mysqlcheck treats the first name argument on the command line as a database name and following names as table names. With this option, it treats all name arguments as database names.

--debug[=debug_options], -# [debug_options]

Write a debugging log. A typical debug_options string is often 'd:t:o,file_name'.

--default-character-set=charset_name

Use charset_name as the default character set. See Section聽5.10.1, 鈥淭he Character Set Used for Data and Sorting鈥�.

--extended, -e

If you are using this option to check tables, it ensures that they are 100% consistent but takes a long time.

If you are using this option to repair tables, it runs an extended repair that may not only take a long time to execute, but may produce a lot of garbage rows also!

--fast, -F

Check only tables that have not been closed properly.

--fix-db-names

Convert database names to 5.1 format. Only database names that contain special characters are affected. This option was added in MySQL 5.1.7.

--fix-table-names

Convert table names to 5.1 format. Only table names that contain special characters are affected. This option was added in MySQL 5.1.7.

--force, -f

Continue even if an SQL error occurs.

--host=host_name, -h host_name

Connect to the MySQL server on the given host.

--medium-check, -m

Do a check that is faster than an --extended operation. This finds only 99.99% of all errors, which should be good enough in most cases.

--optimize, -o

Optimize the tables.

--password[=password], -p[password]

The password to use when connecting to the server. If you use the short option form (-p), you cannot have a space between the option and the password. If you omit the password value following the --password or -p option on the command line, you are prompted for one.

Specifying a password on the command line should be considered insecure. See Section聽5.8.6, 鈥淜eeping Your Password Secure鈥�.

--port=port_num, -P port_num

The TCP/IP port number to use for the connection.

--protocol={TCP|SOCKET|PIPE|MEMORY}

The connection protocol to use.

--quick, -q

If you are using this option to check tables, it prevents the check from scanning the rows to check for incorrect links. This is the fastest check method.

If you are using this option to repair tables, it tries to repair only the index tree. This is the fastest repair method.

--repair, -r

Perform a repair that can fix almost anything except unique keys that are not unique.

--silent, -s

Silent mode. Print only error messages.

--socket=path, -S path

For connections to localhost, the Unix socket file to use, or, on Windows, the name of the named pipe to use.

--ssl*

Options that begin with --ssl specify whether to connect to the server via SSL and indicate where to find SSL keys and certificates. See Section聽5.8.7.3, 鈥淪SL Command Options鈥�.

--tables

Overrides the --databases or -B option. All name arguments following the option are regarded as table names.

--use-frm

For repair operations on MyISAM tables, get the table structure from the .frm file so that the table can be repaired even if the .MYI header is corrupted.

--user=user_name, -u user_name

The MySQL username to use when connecting to the server.

--verbose, -v

Verbose mode. Print information about the various stages of program operation.

--version, -V

Display version information and exit.

To select the effect of --opt except for some features, use the --skip option for each feature. For example, to disable extended inserts and memory buffering, use --opt --skip-extended-insert --skip-quick. (As of MySQL 5.1, --skip-extended-insert --skip-quick is sufficient because --opt is on by default.)

To reverse --opt for all features except index disabling and table locking, use --skip-opt --disable-keys --lock-tables.

--help, -?

Display a help message and exit.

--add-drop-database

Add a DROP DATABASE statement before each CREATE DATABASE statement.

--add-drop-table

Add a DROP TABLE statement before each CREATE TABLE statement.

--add-locks

Surround each table dump with LOCK TABLES and UNLOCK TABLES statements. This results in faster inserts when the dump file is reloaded. See Section聽7.2.17, 鈥淪peed of INSERT Statements鈥�.

--all-databases, -A

Dump all tables in all databases. This is the same as using the --databases option and naming all the databases on the command line.

--all-tablespaces, -Y

Adds to a table dump all SQL statements needed to create any tablespaces used by an NDB Cluster table. This information is not otherwise included in the output from mysqldump. This option is currently relevant only to MySQL Cluster tables.

This option was added in MySQL 5.1.6.

--allow-keywords

Allow creation of column names that are keywords. This works by prefixing each column name with the table name.

--character-sets-dir=path

The directory where character sets are installed. See Section聽5.10.1, 鈥淭he Character Set Used for Data and Sorting鈥�.

--comments, -i

Write additional information in the dump file such as program version, server version, and host. This option is enabled by default. To suppress this additional information, use --skip-comments.

--compact

Produce less verbose output. This option suppresses comments and enables the --skip-add-drop-table, --skip-set-charset, --skip-disable-keys, and --skip-add-locks options.

--compatible=name

Produce output that is more compatible with other database systems or with older MySQL servers. The value of name can be ansi, mysql323, mysql40, postgresql, oracle, mssql, db2, maxdb, no_key_options, no_table_options, or no_field_options. To use several values, separate them by commas. These values have the same meaning as the corresponding options for setting the server SQL mode. See Section聽5.2.6, 鈥淪QL Modes鈥�.

This option does not guarantee compatibility with other servers. It only enables those SQL mode values that are currently available for making dump output more compatible. For example, --compatible=oracle does not map data types to Oracle types or use Oracle comment syntax.

This option requires a server version of 4.1.0 or higher. With older servers, it does nothing.

--complete-insert, -c

Use complete INSERT statements that include column names.

--compress, -C

Compress all information sent between the client and the server if both support compression.

--create-options

Include all MySQL-specific table options in the CREATE TABLE statements.

--databases, -B

Dump several databases. Normally, mysqldump treats the first name argument on the command line as a database name and following names as table names. With this option, it treats all name arguments as database names. CREATE DATABASE and USE statements are included in the output before each new database.

--debug[=debug_options], -# [debug_options]

Write a debugging log. The debug_options string is often 'd:t:o,file_name'. The default value is 'd:t:o,/tmp/mysqldump.trace'.

--default-character-set=charset_name

Use charset_name as the default character set. See Section聽5.10.1, 鈥淭he Character Set Used for Data and Sorting鈥�. If no character set is specified, mysqldump uses utf8, and earlier versions use latin1.

--delayed-insert

Write INSERT DELAYED statements rather than INSERT statements.

--delete-master-logs

On a master replication server, delete the binary logs after performing the dump operation. This option automatically enables --first-slave before MySQL 4.1.8 and enables --master-data.

--disable-keys, -K

For each table, surround the INSERT statements with /*!40000 ALTER TABLE tbl_name DISABLE KEYS */; and /*!40000 ALTER TABLE tbl_name ENABLE KEYS */; statements. This makes loading the dump file faster because the indexes are created after all rows are inserted. This option is effective only for non-unique indexes of MyISAM tables.

--events, -E

Dump events from the dumped databases. This option was added in MySQL 5.1.8.

--extended-insert, -e

Use multiple-row INSERT syntax that include several VALUES lists. This results in a smaller dump file and speeds up inserts when the file is reloaded.

--fields-terminated-by=..., --fields-enclosed-by=..., --fields-optionally-enclosed-by=..., --fields-escaped-by=...

These options are used with the -T option and have the same meaning as the corresponding clauses for LOAD DATA INFILE. See Section聽13.2.5, 鈥�LOAD DATA INFILE Syntax鈥�.

--first-slave, -x

Deprecated. Now renamed to --lock-all-tables.

--flush-logs, -F

Flush the MySQL server log files before starting the dump. This option requires the RELOAD privilege. Note that if you use this option in combination with the --all-databases (or -A) option, the logs are flushed for each database dumped. The exception is when using --lock-all-tables or --master-data: In this case, the logs are flushed only once, corresponding to the moment that all tables are locked. If you want your dump and the log flush to happen at exactly the same moment, you should use --flush-logs together with either --lock-all-tables or --master-data.

--flush-privileges

Emit a FLUSH PRIVILEGES statement after dumping the mysql database. This option should be used any time the dump contains the mysql database and any other database that depends on the data in the mysql database for proper restoration. This option was added in MySQL 5.1.12.

--force, -f

Continue even if an SQL error occurs during a table dump.

One use for this option is to cause mysqldump to continue executing even when it encounters a view that has become invalid because the defintion refers to a table that has been dropped. Without --force, mysqldump exits with an error message. With --force, mysqldump prints the error message, but it also writes a SQL comment containing the view definition to the dump output and continues executing.

--host=host_name, -h host_name

Dump data from the MySQL server on the given host. The default host is localhost.

--hex-blob

Dump binary columns using hexadecimal notation (for example, 'abc' becomes 0x616263). The affected data types are BINARY, VARBINARY, BLOB, and BIT.

--ignore-table=db_name.tbl_name

Do not dump the given table, which must be specified using both the database and table names. To ignore multiple tables, use this option multiple times.

--insert-ignore

Write INSERT statements with the IGNORE option.

--lines-terminated-by=...

This option is used with the -T option and has the same meaning as the corresponding clause for LOAD DATA INFILE. See Section聽13.2.5, 鈥�LOAD DATA INFILE Syntax鈥�.

--lock-all-tables, -x

Lock all tables across all databases. This is achieved by acquiring a global read lock for the duration of the whole dump. This option automatically turns off --single-transaction and --lock-tables.

--lock-tables, -l

Lock all tables before dumping them. The tables are locked with READ LOCAL to allow concurrent inserts in the case of MyISAM tables. For transactional tables such as InnoDB and BDB, --single-transaction is a much better option, because it does not need to lock the tables at all.

Please note that when dumping multiple databases, --lock-tables locks tables for each database separately. Therefore, this option does not guarantee that the tables in the dump file are logically consistent between databases. Tables in different databases may be dumped in completely different states.

--master-data[=value]

Write the binary log filename and position to the output. This option requires the RELOAD privilege and the binary log must be enabled. If the option value is equal to 1, the position and filename are written to the dump output in the form of a CHANGE MASTER statement. If the dump is from a master server and you use it to set up a slave server, the CHANGE MASTER statement causes the slave to start from the correct position in the master's binary logs. If the option value is equal to 2, the CHANGE MASTER statement is written as an SQL comment. (This is the default action if value is omitted.)

The --master-data option automatically turns off --lock-tables. It also turns on --lock-all-tables, unless --single-transaction also is specified (in which case, a global read lock is acquired only for a short time at the beginning of the dump. See also the description for --single-transaction. In all cases, any action on logs happens at the exact moment of the dump.

--no-autocommit

Enclose the INSERT statements for each dumped table within SET AUTOCOMMIT=0 and COMMIT statements.

--no-create-db, -n

This option suppresses the CREATE DATABASE statements that are otherwise included in the output if the --databases or --all-databases option is given.

--no-create-info, -t

Do not write CREATE TABLE statements that re-create each dumped table.

--no-data, -d

Do not write any table row information (that is, do not dump table contents). This is very useful if you want to dump only the CREATE TABLE statement for the table.

--opt

This option is shorthand; it is the same as specifying --add-drop-table --add-locks --create-options --disable-keys --extended-insert --lock-tables --quick --set-charset. It should give you a fast dump operation and produce a dump file that can be reloaded into a MySQL server quickly.

The --opt option is enabled by default. Use --skip-opt to disable it. See the discussion at the beginning of this section for information about selectively enabling or disabling certain of the options affected by --opt.

--order-by-primary

Sorts each table's rows by its primary key, or by its first unique index, if such an index exists. This is useful when dumping a MyISAM table to be loaded into an InnoDB table, but will make the dump itself take considerably longer.

--password[=password], -p[password]

The password to use when connecting to the server. If you use the short option form (-p), you cannot have a space between the option and the password. If you omit the password value following the --password or -p option on the command line, you are prompted for one.

Specifying a password on the command line should be considered insecure. See Section聽5.8.6, 鈥淜eeping Your Password Secure鈥�.

--port=port_num, -P port_num

The TCP/IP port number to use for the connection.

--protocol={TCP|SOCKET|PIPE|MEMORY}

The connection protocol to use.

--quick, -q

This option is useful for dumping large tables. It forces mysqldump to retrieve rows for a table from the server a row at a time rather than retrieving the entire row set and buffering it in memory before writing it out.

--quote-names, -Q

Quote database, table, and column names within 鈥�`鈥� characters. If the ANSI_QUOTES SQL mode is enabled, names are quoted within 鈥�"鈥� characters. This option is enabled by default. It can be disabled with --skip-quote-names, but this option should be given after any option such as --compatible that may enable --quote-names.

--replace

Write REPLACE statements rather than INSERT statements. Available as of MySQL 5.1.3.

--result-file=file, -r file

Direct output to a given file. This option should be used on Windows to prevent newline 鈥�\n鈥� characters from being converted to 鈥�\r\n鈥� carriage return/newline sequences. The result file is created and its contents overwritten, even if an error occurs while generating the dump. The previous contents are lost.

--routines, -R

Dump stored routines (functions and procedures) from the dumped databases. Use of this option requires the SELECT privilege for the mysql.proc table. The output generated by using --routines contains CREATE PROCEDURE and CREATE FUNCTION statements to re-create the routines. However, these statements do not include attributes such as the routine creation and modification timestamps. This means that when the routines are reloaded, they will be created with the timestamps equal to the reload time.

If you require routines to be re-created with their original timestamp attributes, do not use --routines. Instead, dump and reload the contents of the mysql.proc table directly, using a MySQL account that has appropriate privileges for the mysql database.

This option was added in MySQL 5.1.2. Before that, stored routines are not dumped. Routine DEFINER values are not dumped until MySQL 5.1.8. This means that before 5.1.8, when routines are reloaded, they will be created with the definer set to the reloading user. If you require routines to be re-created with their original definer, dump and load the contents of the mysql.proc table directly as described earlier.

--set-charset

Add SET NAMES default_character_set to the output. This option is enabled by default. To suppress the SET NAMES statement, use --skip-set-charset.

--single-transaction

This option issues a BEGIN SQL statement before dumping data from the server. It is useful only with transactional tables such as InnoDB, because then it dumps the consistent state of the database at the time when BEGIN was issued without blocking any applications.

When using this option, you should keep in mind that only InnoDB tables are dumped in a consistent state. For example, any MyISAM or MEMORY tables dumped while using this option may still change state.

This option is not supported for MySQL Cluster tables; the results cannot be guaranteed to be consistent due to the fact that the NDBCluster storage engine supports only the READ_COMMITTED transaction isolation level. You should always use NDB backup and restore instead.

The --single-transaction option and the --lock-tables option are mutually exclusive, because LOCK TABLES causes any pending transactions to be committed implicitly.

This option is not supported for MySQL Cluster tables; the results cannot be guaranteed to be consistent due to the fact that the NDBCluster storage engine supports only the READ_COMMITTED transaction isolation level. You should always use NDB backup and restore instead.

To dump large tables, you should combine this option with --quick.

--skip-opt

See the description for the --opt option.

--socket=path, -S path

For connections to localhost, the Unix socket file to use, or, on Windows, the name of the named pipe to use.

--skip-comments

See the description for the --comments option.

--ssl*

Options that begin with --ssl specify whether to connect to the server via SSL and indicate where to find SSL keys and certificates. See Section聽5.8.7.3, 鈥淪SL Command Options鈥�.

--tab=path, -T path

Produce tab-separated data files. For each dumped table, mysqldump creates a tbl_name.sql file that contains the CREATE TABLE statement that creates the table, and a tbl_name.txt file that contains its data. The option value is the directory in which to write the files.

By default, the .txt data files are formatted using tab characters between column values and a newline at the end of each line. The format can be specified explicitly using the --fields-xxx and --lines-terminated-by options.

Note: This option should be used only when mysqldump is run on the same machine as the mysqld server. You must have the FILE privilege, and the server must have permission to write files in the directory that you specify.

--tables

Override the --databases or -B option. mysqldump regards all name arguments following the option as table names.

--triggers

Dump triggers for each dumped table. This option is enabled by default; disable it with --skip-triggers.

--tz-utc

Add SET TIME_ZONE='+00:00' to the dump file so that TIMESTAMP columns can be dumped and reloaded between servers in different time zones. Without this option, TIMESTAMP columns are dumped and reloaded in the time zones local to the source and destination servers, which can cause the values to change. --tz-utc also protects against changes due to daylight saving time. --tz-utc is enabled by default. To disable it, use --skip-tz-utc. This option was added in MySQL 5.1.2.

--user=user_name, -u user_name

The MySQL username to use when connecting to the server.

--verbose, -v

Verbose mode. Print more information about what the program does.

--version, -V

Display version information and exit.

--where='where_condition', -w 'where_condition'

Dump only rows selected by the given WHERE condition. Quotes around the condition are mandatory if it contains spaces or other characters that are special to your command interpreter.

Examples:

--where="user='jimf'"
-w"userid>1"
-w"userid<1"

--xml, -X

Write dump output as well-formed XML.

NULL, 'NULL', and Empty Values: For some column named column_name, the NULL value, an empty string, and the string value 'NULL' are distinguished from one another in the output generated by this option as follows:

Beginning with MySQL 5.1.12, the output from the mysql client when run using the --xml option also follows these rules. (See Section聽8.8.1, 鈥�mysql Options鈥�.)

Beginning with MySQL 5.1.18, XML output from mysqldump includes the XML namespace, as shown here:

shell> mysqldump --xml -u root world City
<?xml version="1.0"?>
<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<database name="world">
<table_structure name="City">
<field Field="ID" Type="int(11)" Null="NO" Key="PRI" Extra="auto_increment" />
<field Field="Name" Type="char(35)" Null="NO" Key="" Default="" Extra="" />
<field Field="CountryCode" Type="char(3)" Null="NO" Key="" Default="" Extra="" />
<field Field="District" Type="char(20)" Null="NO" Key="" Default="" Extra="" />
<field Field="Population" Type="int(11)" Null="NO" Key="" Default="0" Extra="" />
<key Table="City" Non_unique="0" Key_name="PRIMARY" Seq_in_index="1" Column_name="ID" Collation="A" Cardinality="4079"
Null="" Index_type="BTREE" Comment="" />
<options Name="City" Engine="MyISAM" Version="10" Row_format="Fixed" Rows="4079" Avg_row_length="67" Data_length="27329
3" Max_data_length="18858823439613951" Index_length="43008" Data_free="0" Auto_increment="4080" Create_time="2007-03-31 01:47:01" Updat
e_time="2007-03-31 01:47:02" Collation="latin1_swedish_ci" Create_options="" Comment="" />
</table_structure>
<table_data name="City">
<row>
<field name="ID">1</field>
<field name="Name">Kabul</field>
<field name="CountryCode">AFG</field>
<field name="District">Kabol</field>
<field name="Population">1780000</field>
</row>

...

<row>
<field name="ID">4079</field>
<field name="Name">Rafah</field>
<field name="CountryCode">PSE</field>
<field name="District">Rafah</field>
<field name="Population">92020</field>
</row>
</table_data>
</database>
</mysqldump>

max_allowed_packet

The maximum size of the buffer for client/server communication. The maximum is 1GB.

net_buffer_length

The initial size of the buffer for client/server communication. When creating multiple-row-insert statements (as with option --extended-insert or --opt), mysqldump creates rows up to net_buffer_length length. If you increase this variable, you should also ensure that the net_buffer_length variable in the MySQL server is at least this large.

--help, -?

Display a help message and exit.

--addtodest

Do not rename target directory (if it exists); merely add files to it.

--allowold

Do not abort if a target exists; rename it by adding an _old suffix.

--checkpoint=db_name.tbl_name

Insert checkpoint entries into the specified database db_name and table tbl_name.

--chroot=path

Base directory of the chroot jail in which mysqld operates. The path value should match that of the --chroot option given to mysqld.

--debug

Enable debug output.

--dryrun, -n

Report actions without performing them.

--flushlog

Flush logs after all tables are locked.

--host=host_name, -h host_name

The hostname of the local host to use for making a TCP/IP connection to the local server. By default, the connection is made to localhost using a Unix socket file.

--keepold

Do not delete previous (renamed) target when done.

--method=command

The method for copying files (cp or scp).

--noindices

Do not include full index files in the backup. This makes the backup smaller and faster. The indexes for reloaded tables can be reconstructed later with myisamchk -rq.

--password=password, -ppassword

The password to use when connecting to the server. Note that the password value is not optional for this option, unlike for other MySQL programs. You can use an option file to avoid giving the password on the command line.

Specifying a password on the command line should be considered insecure. See Section聽5.8.6, 鈥淜eeping Your Password Secure鈥�.

--port=port_num, -P port_num

The TCP/IP port number to use when connecting to the local server.

--quiet, -q

Be silent except for errors.

--record_log_pos=db_name.tbl_name

Record master and slave status in the specified database db_name and table tbl_name.

--regexp=expr

Copy all databases with names that match the given regular expression.

--resetmaster

Reset the binary log after locking all the tables.

--resetslave

Reset the master.info file after locking all the tables.

--socket=path, -S path

The Unix socket file to use for the connection.

--suffix=str

The suffix for names of copied databases.

--tmpdir=path

The temporary directory. The default is /tmp.

--user=user_name, -u user_name

The MySQL username to use when connecting to the server.

--help, -?

Display a help message and exit.

--character-sets-dir=path

The directory where character sets are installed. See Section聽5.10.1, 鈥淭he Character Set Used for Data and Sorting鈥�.

--columns=column_list, -c column_list

This option takes a comma-separated list of column names as its value. The order of the column names indicates how to match data file columns with table columns.

--compress, -C

Compress all information sent between the client and the server if both support compression.

--debug[=debug_options], -# [debug_options]

Write a debugging log. The debug_options string often is 'd:t:o,file_name'.

--default-character-set=charset_name

Use charset_name as the default character set. See Section聽5.10.1, 鈥淭he Character Set Used for Data and Sorting鈥�.

--delete, -D

Empty the table before importing the text file.

--fields-terminated-by=..., --fields-enclosed-by=..., --fields-optionally-enclosed-by=..., --fields-escaped-by=...

These options have the same meaning as the corresponding clauses for LOAD DATA INFILE. See Section聽13.2.5, 鈥�LOAD DATA INFILE Syntax鈥�.

--force, -f

Ignore errors. For example, if a table for a text file does not exist, continue processing any remaining files. Without --force, mysqlimport exits if a table does not exist.

--host=host_name, -h host_name

Import data to the MySQL server on the given host. The default host is localhost.

--ignore, -i

See the description for the --replace option.

--ignore-lines=N

Ignore the first N lines of the data file.

--lines-terminated-by=...

This option has the same meaning as the corresponding clause for LOAD DATA INFILE. For example, to import Windows files that have lines terminated with carriage return/linefeed pairs, use --lines-terminated-by="\r\n". (You might have to double the backslashes, depending on the escaping conventions of your command interpreter.) See Section聽13.2.5, 鈥�LOAD DATA INFILE Syntax鈥�.

--local, -L

Read input files locally from the client host.

MySQL Enterprise For expert advice on the security implications of enabling LOCAL, subscribe to the MySQL Network Monitoring and Advisory. For more information see http://www.mysql.com/products/enterprise/advisors.html.

--lock-tables, -l

Lock all tables for writing before processing any text files. This ensures that all tables are synchronized on the server.

--low-priority

Use LOW_PRIORITY when loading the table. This affects only storage engines that use only table-level locking (MyISAM, MEMORY, MERGE).

--password[=password], -p[password]

The password to use when connecting to the server. If you use the short option form (-p), you cannot have a space between the option and the password. If you omit the password value following the --password or -p option on the command line, you are prompted for one.

Specifying a password on the command line should be considered insecure. See Section聽5.8.6, 鈥淜eeping Your Password Secure鈥�.

--port=port_num, -P port_num

The TCP/IP port number to use for the connection.

--protocol={TCP|SOCKET|PIPE|MEMORY}

The connection protocol to use.

--replace, -r

The --replace and --ignore options control handling of input rows that duplicate existing rows on unique key values. If you specify --replace, new rows replace existing rows that have the same unique key value. If you specify --ignore, input rows that duplicate an existing row on a unique key value are skipped. If you do not specify either option, an error occurs when a duplicate key value is found, and the rest of the text file is ignored.

--silent, -s

Silent mode. Produce output only when errors occur.

--socket=path, -S path

For connections to localhost, the Unix socket file to use, or, on Windows, the name of the named pipe to use.

--ssl*

Options that begin with --ssl specify whether to connect to the server via SSL and indicate where to find SSL keys and certificates. See Section聽5.8.7.3, 鈥淪SL Command Options鈥�.

--user=user_name, -u user_name

The MySQL username to use when connecting to the server.

--verbose, -v

Verbose mode. Print more information about what the program does.

--version, -V

Display version information and exit.

If no database is given, a list of database names is shown.

If no table is given, all matching tables in the database are shown.

If no column is given, all matching columns and column types in the table are shown.

--help, -?

Display a help message and exit.

--character-sets-dir=path

The directory where character sets are installed. See Section聽5.10.1, 鈥淭he Character Set Used for Data and Sorting鈥�.

--compress, -C

Compress all information sent between the client and the server if both support compression.

--count

Show the number of rows per table. This can be slow for non-MyISAM tables.

--debug[=debug_options], -# [debug_options]

Write a debugging log. The debug_options string often is 'd:t:o,file_name'.

--default-character-set=charset_name

Use charset_name as the default character set. See Section聽5.10.1, 鈥淭he Character Set Used for Data and Sorting鈥�.

--host=host_name, -h host_name

Connect to the MySQL server on the given host.

--keys, -k

Show table indexes.

--password[=password], -p[password]

The password to use when connecting to the server. If you use the short option form (-p), you cannot have a space between the option and the password. If you omit the password value following the --password or -p option on the command line, you are prompted for one.

Specifying a password on the command line should be considered insecure. See Section聽5.8.6, 鈥淜eeping Your Password Secure鈥�.

Specifying a password on the command line should be considered insecure. See Section聽5.8.6, 鈥淜eeping Your Password Secure鈥�.

--port=port_num, -P port_num

The TCP/IP port number to use for the connection.

--protocol={TCP|SOCKET|PIPE|MEMORY}

The connection protocol to use.

--show-table-type, -t

Show a column indicating the table type, as in SHOW FULL TABLES. The type is BASE TABLE or VIEW.

--socket=path, -S path

For connections to localhost, the Unix socket file to use, or, on Windows, the name of the named pipe to use.

--ssl*

Options that begin with --ssl specify whether to connect to the server via SSL and indicate where to find SSL keys and certificates. See Section聽5.8.7.3, 鈥淪SL Command Options鈥�.

--status, -i

Display extra information about each table.

--user=user_name, -u user_name

The MySQL username to use when connecting to the server.

--verbose, -v

Verbose mode. Print more information about what the program does. This option can be used multiple times to increase the amount of information.

--version, -V

Display version information and exit.

--help, -?

Display a help message and exit.

--auto-generate-sql, -a

Generate SQL statements automatically when they are not supplied in files or via command options.

--compress, -C

Compress all information sent between the client and the server if both support compression.

--concurrency=N, -c N

The number of clients to simulate when issuing the SELECT statement.

--create=value

The file or string to use for creating the table.

--create-schema=value

The schema in which to run the tests. This option was added in MySQL 5.1.5.

--csv[=file]

Generate output in comma-separated values format. The output goes to the named file, or to the standard output if no file is given. This option was added in MySQL 5.1.5.

--debug[=debug_options], -# [debug_options]

Write a debugging log. The debug_options string often is 'd:t:o,file_name'.

--delimiter=str, -F str

The delimiter to use in SQL statements supplied in files or via command options.

--engine=engine_name, -e engine_name

The storage engine to use for creating the table.

--host=host_name, -h host_name

Connect to the MySQL server on the given host.

--iterations=N, -i N

The number of times to run the tests.

--lock-directory=path

The directory to use for storing locks. This option was added in MySQL 5.1.5.

--number-char-cols=N, -x N

The number of VARCHAR columns to use if --auto-generate-sql is specified.

--number-int-cols=N, -y N

The number of INT columns to use if --auto-generate-sql is specified.

--number-of-queries=N

Limit each client to approximately this number of queries. This option was added in MySQL 5.1.5.

--only-print

Do not connect to databases. mysqlslap only prints what it would have done. This option was added in MySQL 5.1.5.

--password[=password], -p[password]

The password to use when connecting to the server. If you use the short option form (-p), you cannot have a space between the option and the password. If you omit the password value following the --password or -p option on the command line, you are prompted for one.

Specifying a password on the command line should be considered insecure. See Section聽5.8.6, 鈥淜eeping Your Password Secure鈥�.

--port=port_num, -P port_num

The TCP/IP port number to use for the connection.

--protocol={TCP|SOCKET|PIPE|MEMORY}

The connection protocol to use.

--preserve-schema