| List: | Internals | « Previous MessageNext Message » | |
| From: | paul | Date: | August 9 2005 12:42am |
| Subject: | bk commit - mysqldoc@docsrva tree (paul:1.3213) | ||
| View as plain text | |||
Below is the list of changes that have just been committed into a local mysqldoc repository of paul. When paul does a push these changes will be propagated to the main repository and, within 24 hours after the push, to the public repository. For information on how to access the public repository see http://www.mysql.com/doc/I/n/Installing_source_tree.html ChangeSet 1.3213 05/08/08 17:42:10 paul@stripped +4 -0 Move indexing tags closer to targets. refman/client-side-scripts.xml 1.14 05/08/08 17:42:08 paul@stripped +233 -401 Move indexing tags closer to targets. refman-5.1/client-side-scripts.xml 1.3 05/08/08 17:42:07 paul@stripped +227 -364 Move indexing tags closer to targets. refman-5.0/client-side-scripts.xml 1.4 05/08/08 17:42:07 paul@stripped +227 -364 Move indexing tags closer to targets. refman-4.1/client-side-scripts.xml 1.12 05/08/08 17:42:07 paul@stripped +233 -401 Move indexing tags closer to targets. # This is a BitKeeper patch. What follows are the unified diffs for the # set of deltas contained in the patch. The rest of the patch, the part # that BitKeeper cares about, is below these diffs. # User: paul # Host: frost.snake.net # Root: /Volumes/frost2/MySQL/bk/mysqldoc --- 1.2/refman-5.1/client-side-scripts.xml 2005-08-08 17:12:07 -05:00 +++ 1.3/refman-5.1/client-side-scripts.xml 2005-08-08 17:42:07 -05:00 @@ -45,12 +45,12 @@ <itemizedlist> - <indexterm type="concept"> - <primary><command>myisampack</command></primary> - </indexterm> - <listitem> <para> + <indexterm type="concept"> + <primary><command>myisampack</command></primary> + </indexterm> + <literal>myisampack</literal> </para> @@ -59,16 +59,14 @@ produce smaller read-only tables. See <xref linkend="myisampack"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysql</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysql</literal> </para> @@ -77,16 +75,14 @@ statements or executing them from a file in batch mode. See <xref linkend="mysql"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlaccess</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlaccess</literal> </para> @@ -94,16 +90,14 @@ A script that checks the access privileges for a host, user, and database combination. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqladmin</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqladmin</literal> </para> @@ -115,16 +109,14 @@ version, process, and status information from the server. See <xref linkend="mysqladmin"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlbinlog</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlbinlog</literal> </para> @@ -142,59 +134,52 @@ <para> MySQL AB also provide three GUI client programs for use with the MySQL server: + </para> - <itemizedlist> - - <listitem> - <para> - <ulink url="http://dev.mysql.com/doc/administrator/en/">MySQL - Administrator</ulink>: This tool is used for - administering MySQL servers, databases, tables, and - users. - </para> - </listitem> - - <listitem> - <para> - <ulink url="http://dev.mysql.com/doc/query-browser/en/">MySQL - Query Browser</ulink>: This graphical tool is provided - by MySQL AB for creating, executing, and optimizing - queries on MySQL databases. - </para> - </listitem> - - <listitem> - <para> - <ulink url="http://dev.mysql.com/doc/migration-toolkit/en/">MySQL - Migration Toolkit</ulink>: This tool is intended to help - you with migrating schemas and data from other - relational database management systems to MySQL. - </para> - </listitem> + <itemizedlist> - </itemizedlist> - </para> + <listitem> + <para> + <indexterm type="concept"> + <primary>GUI tools</primary> + <secondary>MySQL Administrator</secondary> + </indexterm> + + <ulink url="http://dev.mysql.com/doc/administrator/en/">MySQL + Administrator</ulink>: This tool is used for administering + MySQL servers, databases, tables, and users. + </para> + </listitem> - <para> - <indexterm type="concept"> - <primary>GUI tools</primary> - <secondary>MySQL Administrator</secondary> - </indexterm> - </para> + <listitem> + <para> + <indexterm type="concept"> + <primary>graphical clients</primary> + <secondary>MySQL Query Browser</secondary> + </indexterm> + + <ulink url="http://dev.mysql.com/doc/query-browser/en/">MySQL + Query Browser</ulink>: This graphical tool is provided by + MySQL AB for creating, executing, and optimizing queries + on MySQL databases. + </para> + </listitem> - <para> - <indexterm type="concept"> - <primary>graphical clients</primary> - <secondary>MySQL Query Browser</secondary> - </indexterm> - </para> + <listitem> + <para> + <indexterm type="concept"> + <primary>graphical tools</primary> + <secondary>MySQL Migration Toolkit</secondary> + </indexterm> + + <ulink url="http://dev.mysql.com/doc/migration-toolkit/en/">MySQL + Migration Toolkit</ulink>: This tool is intended to help + you with migrating schemas and data from other relational + database management systems to MySQL. + </para> + </listitem> - <para> - <indexterm type="concept"> - <primary>graphical tools</primary> - <secondary>MySQL Migration Toolkit</secondary> - </indexterm> - </para> + </itemizedlist> </listitem> <listitem> @@ -202,11 +187,7 @@ <indexterm type="concept"> <primary><command>mysqlcheck</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlcheck</literal> </para> @@ -214,16 +195,14 @@ A table-maintenance client that checks, repairs, analyzes, and optimizes tables. See <xref linkend="using-mysqlcheck"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqldump</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqldump</literal> </para> @@ -232,16 +211,14 @@ statements or as tab-separated text files. Enhanced freeware originally by Igor Romanenko. See <xref linkend="mysqldump"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlhotcopy</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlhotcopy</literal> </para> @@ -251,16 +228,14 @@ while the server is running. See <xref linkend="mysqlhotcopy"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlimport</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlimport</literal> </para> @@ -269,16 +244,14 @@ using <literal>LOAD DATA INFILE</literal>. See <xref linkend="mysqlimport"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlshow</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlshow</literal> </para> @@ -286,16 +259,14 @@ A client that displays information about databases, tables, columns, and indexes. See <xref linkend="mysqlshow"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>perror</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>perror</literal> </para> @@ -303,16 +274,14 @@ A utility that displays the meaning of system or MySQL error codes. See <xref linkend="perror"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>replace</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>replace</literal> </para> @@ -1251,30 +1220,28 @@ <itemizedlist> - <indexterm type="concept"> - <primary><literal>help</literal></primary> - <secondary><command>mysql</command> option</secondary> - </indexterm> - <listitem> <para> + <indexterm type="concept"> + <primary><literal>help</literal></primary> + <secondary><command>mysql</command> option</secondary> + </indexterm> + <option>--help</option>, <option>-?</option> </para> <para> Display a help message and exit. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>batch</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--batch</option>, <option>-B</option> </para> @@ -1283,17 +1250,15 @@ on a new line. With this option, <command>mysql</command> doesn't use the history file. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>character-sets-dir</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--character-sets-dir=<replaceable>path</replaceable></option> </para> @@ -1301,17 +1266,15 @@ The directory where character sets are installed. See <xref linkend="character-sets"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>compress</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--compress</option>, <option>-C</option> </para> @@ -1319,17 +1282,15 @@ Compress all information sent between the client and the server if both support compression. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>database</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--database=<replaceable>db_name</replaceable></option>, <option>-D <replaceable>db_name</replaceable></option> </para> @@ -1337,17 +1298,15 @@ <para> The database to use. This is useful mainly in an option file. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>debug</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--debug[=<replaceable>debug_options</replaceable>]</option>, <option>-# [<replaceable>debug_options</replaceable>]</option> </para> @@ -1358,34 +1317,30 @@ <literal>'d:t:o,<replaceable>file_name</replaceable>'</literal>. The default is <literal>'d:t:o,/tmp/mysql.trace'</literal>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>debug-info</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--debug-info</option>, <option>-T</option> </para> <para> Print some debugging information when the program exits. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>default-character-set</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--default-character-set=<replaceable>charset</replaceable></option> </para> @@ -1393,17 +1348,15 @@ Use <replaceable>charset</replaceable> as the default character set. See <xref linkend="character-sets"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>execute</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--execute=<replaceable>statement</replaceable></option>, <option>-e <replaceable>statement</replaceable></option> </para> @@ -1413,34 +1366,30 @@ like that produced with <option>--batch</option>. See <xref linkend="command-line-options"/> for some examples. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>force</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--force</option>, <option>-f</option> </para> <para> Continue even if an SQL error occurs. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>host</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--host=<replaceable>host_name</replaceable></option>, <option>-h <replaceable>host_name</replaceable></option> </para> @@ -1448,34 +1397,30 @@ <para> Connect to the MySQL server on the given host. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>html</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--html</option>, <option>-H</option> </para> <para> Produce HTML output. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>ignore-space</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--ignore-space</option>, <option>-i</option> </para> @@ -1485,17 +1430,15 @@ <literal>IGNORE_SPACE</literal> in <xref linkend="server-sql-mode"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>local-infile</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--local-infile[={0|1}]</option> </para> @@ -1509,17 +1452,15 @@ <literal>LOCAL</literal> has no effect if the server does not also support it. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>named-commands</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--named-commands</option>, <option>-G</option> </para> @@ -1529,17 +1470,15 @@ example, <literal>quit</literal> and <literal>\q</literal> both are recognized. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>no-auto-rehash</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--no-auto-rehash</option>, <option>-A</option> </para> @@ -1549,34 +1488,30 @@ the <literal>rehash</literal> command if you want to use table and column name completion. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>no-beep</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--no-beep</option>, <option>-b</option> </para> <para> Do not beep when errors occur. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>no-named-commands</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--no-named-commands</option>, <option>-g</option> </para> @@ -1589,17 +1524,15 @@ with this option, long-format commands still work from the first line. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>no-pager</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--no-pager</option> </para> @@ -1607,17 +1540,15 @@ Do not use a pager for displaying query output. Output paging is discussed further in <xref linkend="mysql-commands"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>no-tee</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--no-tee</option> </para> @@ -1625,17 +1556,15 @@ Do not copy output to a file. Tee files are discussed further in <xref linkend="mysql-commands"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>one-database</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--one-database</option>, <option>-O</option> </para> @@ -1644,17 +1573,15 @@ on the command line. This is useful for skipping updates to other databases in the binary log. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>pager</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--pager[=<replaceable>command</replaceable>]</option> </para> @@ -1668,17 +1595,15 @@ Output paging is discussed further in <xref linkend="mysql-commands"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>password</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--password[=<replaceable>password</replaceable>]</option>, <option>-p[<replaceable>password</replaceable>]</option> </para> @@ -1694,17 +1619,15 @@ should be omitted on SysV-based UNIX systems, as the password may be displayed in the output of <literal>ps</literal>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>port</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--port=<replaceable>port_num</replaceable></option>, <option>-P <replaceable>port_num</replaceable></option> </para> @@ -1712,17 +1635,15 @@ <para> The TCP/IP port number to use for the connection. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>prompt</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--prompt=<replaceable>format_str</replaceable></option> </para> @@ -1732,34 +1653,30 @@ prompt can contain are described in <xref linkend="mysql-commands"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>protocol</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--protocol={TCP | SOCKET | PIPE | MEMORY}</option> </para> <para> The connection protocol to use. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>quick</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--quick</option>, <option>-q</option> </para> @@ -1769,17 +1686,15 @@ suspended. With this option, <command>mysql</command> doesn't use the history file. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>raw</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--raw</option>, <option>-r</option> </para> @@ -1787,17 +1702,15 @@ Write column values without escape conversion. Often used with the <option>--batch</option> option. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>reconnect</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--reconnect</option> </para> @@ -1807,17 +1720,15 @@ connection is lost. To suppress reconnection behavior, use <option>--skip-reconnect</option>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>safe-updates</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--safe-updates</option>, <option>--i-am-a-dummy</option>, <option>-U</option> </para> @@ -1831,17 +1742,15 @@ <xref linkend="mysql-tips"/> for more information about this option. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>secure-auth</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--secure-auth</option> </para> @@ -1850,17 +1759,15 @@ This prevents connections except for servers that use the newer password format. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>show-warnings</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--show-warnings</option> </para> @@ -1869,17 +1776,15 @@ any. This option applies to interactive and batch mode. This option was added in MySQL 5.0.6. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>sigint-ignore</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--sigint-ignore</option> </para> @@ -1887,17 +1792,15 @@ Ignore <literal>SIGINT</literal> signals (typically the result of typing Control-C). </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>silent</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--silent</option>, <option>-s</option> </para> @@ -1905,34 +1808,30 @@ Silent mode. Produce less output. This option can be given multiple times to produce less and less output. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>skip-column-names</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--skip-column-names</option>, <option>-N</option> </para> <para> Do not write column names in results. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>skip-line-numbers</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--skip-line-numbers</option>, <option>-L</option> </para> @@ -1940,17 +1839,15 @@ Do not write line numbers for errors. Useful when you want to compare result files that include error messages. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>socket</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--socket=<replaceable>path</replaceable></option>, <option>-S <replaceable>path</replaceable></option> </para> @@ -1958,17 +1855,15 @@ <para> The socket file to use for the connection. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>table</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--table</option>, <option>-t</option> </para> @@ -1977,17 +1872,15 @@ interactive use, but can be used to produce table output in batch mode. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>tee</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--tee=<replaceable>file_name</replaceable></option> </para> @@ -1996,34 +1889,30 @@ not work in batch mode. Tee files are discussed further in <xref linkend="mysql-commands"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>unbuffered</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--unbuffered</option>, <option>-n</option> </para> <para> Flush the buffer after each query. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>user</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--user=<replaceable>user_name</replaceable></option>, <option>-u <replaceable>user_name</replaceable></option> </para> @@ -2031,17 +1920,15 @@ <para> The MySQL username to use when connecting to the server. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>verbose</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--verbose</option>, <option>-v</option> </para> @@ -2051,34 +1938,30 @@ <option>-v -v -v</option> produces the table output format even in batch mode.) </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>version</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--version</option>, <option>-V</option> </para> <para> Display version information and exit. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>vertical</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--vertical</option>, <option>-E</option> </para> @@ -2087,17 +1970,15 @@ option, you can specify vertical output for individual statements by terminating them with <literal>\G</literal>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>wait</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--wait</option>, <option>-w</option> </para> @@ -2105,17 +1986,15 @@ If the connection cannot be established, wait and retry instead of aborting. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>xml</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--xml</option>, <option>-X</option> </para> @@ -2132,35 +2011,19 @@ options: </para> - <indexterm type="concept"> - <primary>timeout</primary> - <secondary><literal>connect_timeout</literal> variable</secondary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>connect_timeout</literal> variable</primary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>max_allowed_packet</literal> variable</primary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>max_join_size</literal> variable</primary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>net_buffer_length</literal> variable</primary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>select_limit</literal> variable</primary> - </indexterm> - <itemizedlist> <listitem> <para> + <indexterm type="concept"> + <primary>timeout</primary> + <secondary><literal>connect_timeout</literal> variable</secondary> + </indexterm> + + <indexterm type="concept"> + <primary><literal>connect_timeout</literal> variable</primary> + </indexterm> + <literal>connect_timeout</literal> </para> @@ -2172,6 +2035,10 @@ <listitem> <para> + <indexterm type="concept"> + <primary><literal>max_allowed_packet</literal> variable</primary> + </indexterm> + <literal>max_allowed_packet</literal> </para> @@ -2183,6 +2050,10 @@ <listitem> <para> + <indexterm type="concept"> + <primary><literal>max_join_size</literal> variable</primary> + </indexterm> + <literal>max_join_size</literal> </para> @@ -2194,6 +2065,10 @@ <listitem> <para> + <indexterm type="concept"> + <primary><literal>net_buffer_length</literal> variable</primary> + </indexterm> + <literal>net_buffer_length</literal> </para> @@ -2205,6 +2080,10 @@ <listitem> <para> + <indexterm type="concept"> + <primary><literal>select_limit</literal> variable</primary> + </indexterm> + <literal>select_limit</literal> </para> @@ -3347,44 +3226,40 @@ <itemizedlist> - <indexterm type="concept"> - <primary>uptime</primary> - </indexterm> - <listitem> <para> + <indexterm type="concept"> + <primary>uptime</primary> + </indexterm> + <literal>Uptime</literal> </para> <para> The number of seconds the MySQL server has been running. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>threads</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Threads</literal> </para> <para> The number of active threads (clients). </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>questions</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Questions</literal> </para> @@ -3392,16 +3267,14 @@ The number of questions (queries) from clients since the server was started. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>slow queries</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Slow queries</literal> </para> @@ -3410,23 +3283,23 @@ <literal>long_query_time</literal> seconds. See <xref linkend="slow-query-log"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>opens</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Opens</literal> </para> <para> The number of tables the server has opened. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>flush tables</primary> @@ -3436,11 +3309,7 @@ <primary>tables</primary> <secondary>flush</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Flush tables</literal> </para> @@ -3449,32 +3318,28 @@ <literal>refresh</literal>, and <literal>reload</literal> commands the server has executed. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>open tables</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Open tables</literal> </para> <para> The number of tables that currently are open. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>memory use</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Memory in use</literal> </para> @@ -3484,16 +3349,14 @@ when MySQL has been compiled with <option>--with-debug=full</option>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>maximum memory used</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Maximum memory used</literal> </para> @@ -3783,28 +3646,19 @@ options: </para> - <indexterm type="concept"> - <primary>timeout</primary> - <secondary><literal>connect_timeout</literal> variable</secondary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>connect_timeout</literal> variable</primary> - </indexterm> - - <indexterm type="concept"> - <primary>timeout</primary> - <secondary><literal>shutdown_timeout</literal> variable</secondary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>shutdown_timeout</literal> variable</primary> - </indexterm> - <itemizedlist> <listitem> <para> + <indexterm type="concept"> + <primary><literal>connect_timeout</literal> variable</primary> + </indexterm> + + <indexterm type="concept"> + <primary>timeout</primary> + <secondary><literal>connect_timeout</literal> variable</secondary> + </indexterm> + <literal>connect_timeout</literal> </para> @@ -3816,6 +3670,15 @@ <listitem> <para> + <indexterm type="concept"> + <primary><literal>shutdown_timeout</literal> variable</primary> + </indexterm> + + <indexterm type="concept"> + <primary>timeout</primary> + <secondary><literal>shutdown_timeout</literal> variable</secondary> + </indexterm> + <literal>shutdown_timeout</literal> </para> @@ -4200,14 +4063,14 @@ options: </para> - <indexterm type="concept"> - <primary><literal>open_files_limit</literal> variable</primary> - </indexterm> - <itemizedlist> <listitem> <para> + <indexterm type="concept"> + <primary><literal>open_files_limit</literal> variable</primary> + </indexterm> + <literal>open_files_limit</literal> </para> --- 1.11/refman-4.1/client-side-scripts.xml 2005-08-08 17:12:07 -05:00 +++ 1.12/refman-4.1/client-side-scripts.xml 2005-08-08 17:42:07 -05:00 @@ -45,12 +45,12 @@ <itemizedlist> - <indexterm type="concept"> - <primary><command>myisampack</command></primary> - </indexterm> - <listitem> <para> + <indexterm type="concept"> + <primary><command>myisampack</command></primary> + </indexterm> + <literal>myisampack</literal> </para> @@ -59,16 +59,14 @@ produce smaller read-only tables. See <xref linkend="myisampack"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysql</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysql</literal> </para> @@ -77,16 +75,14 @@ statements or executing them from a file in batch mode. See <xref linkend="mysql"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlaccess</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlaccess</literal> </para> @@ -94,16 +90,14 @@ A script that checks the access privileges for a host, user, and database combination. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqladmin</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqladmin</literal> </para> @@ -115,16 +109,14 @@ version, process, and status information from the server. See <xref linkend="mysqladmin"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlbinlog</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlbinlog</literal> </para> @@ -134,16 +126,14 @@ used to help recover from a crash. See <xref linkend="mysqlbinlog"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlcc</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlcc</literal> </para> @@ -151,16 +141,14 @@ A client that provides a graphical interface for interacting with the server. See <xref linkend="mysqlcc"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlcheck</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlcheck</literal> </para> @@ -168,16 +156,14 @@ A table-maintenance client that checks, repairs, analyzes, and optimizes tables. See <xref linkend="using-mysqlcheck"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqldump</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqldump</literal> </para> @@ -186,16 +172,14 @@ statements or as tab-separated text files. Enhanced freeware originally by Igor Romanenko. See <xref linkend="mysqldump"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlhotcopy</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlhotcopy</literal> </para> @@ -205,16 +189,14 @@ while the server is running. See <xref linkend="mysqlhotcopy"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlimport</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlimport</literal> </para> @@ -223,16 +205,14 @@ using <literal>LOAD DATA INFILE</literal>. See <xref linkend="mysqlimport"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlshow</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlshow</literal> </para> @@ -240,16 +220,14 @@ A client that displays information about databases, tables, columns, and indexes. See <xref linkend="mysqlshow"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>perror</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>perror</literal> </para> @@ -257,16 +235,14 @@ A utility that displays the meaning of system or MySQL error codes. See <xref linkend="perror"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>replace</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>replace</literal> </para> @@ -1223,30 +1199,28 @@ <itemizedlist> - <indexterm type="concept"> - <primary><literal>help</literal></primary> - <secondary><command>mysql</command> option</secondary> - </indexterm> - <listitem> <para> + <indexterm type="concept"> + <primary><literal>help</literal></primary> + <secondary><command>mysql</command> option</secondary> + </indexterm> + <option>--help</option>, <option>-?</option> </para> <para> Display a help message and exit. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>batch</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--batch</option>, <option>-B</option> </para> @@ -1255,17 +1229,15 @@ on a new line. With this option, <command>mysql</command> doesn't use the history file. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>character-sets-dir</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--character-sets-dir=<replaceable>path</replaceable></option> </para> @@ -1273,17 +1245,15 @@ The directory where character sets are installed. See <xref linkend="character-sets"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>compress</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--compress</option>, <option>-C</option> </para> @@ -1291,17 +1261,15 @@ Compress all information sent between the client and the server if both support compression. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>database</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--database=<replaceable>db_name</replaceable></option>, <option>-D <replaceable>db_name</replaceable></option> </para> @@ -1309,17 +1277,15 @@ <para> The database to use. This is useful mainly in an option file. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>debug</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--debug[=<replaceable>debug_options</replaceable>]</option>, <option>-# [<replaceable>debug_options</replaceable>]</option> </para> @@ -1330,34 +1296,30 @@ <literal>'d:t:o,<replaceable>file_name</replaceable>'</literal>. The default is <literal>'d:t:o,/tmp/mysql.trace'</literal>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>debug-info</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--debug-info</option>, <option>-T</option> </para> <para> Print some debugging information when the program exits. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>default-character-set</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--default-character-set=<replaceable>charset</replaceable></option> </para> @@ -1365,17 +1327,15 @@ Use <replaceable>charset</replaceable> as the default character set. See <xref linkend="character-sets"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>execute</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--execute=<replaceable>statement</replaceable></option>, <option>-e <replaceable>statement</replaceable></option> </para> @@ -1384,34 +1344,30 @@ Execute the statement and quit. The default output format is like that produced with <option>--batch</option>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>force</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--force</option>, <option>-f</option> </para> <para> Continue even if an SQL error occurs. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>host</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--host=<replaceable>host_name</replaceable></option>, <option>-h <replaceable>host_name</replaceable></option> </para> @@ -1419,34 +1375,30 @@ <para> Connect to the MySQL server on the given host. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>html</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--html</option>, <option>-H</option> </para> <para> Produce HTML output. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>ignore-space</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--ignore-space</option>, <option>-i</option> </para> @@ -1456,17 +1408,15 @@ <literal>IGNORE_SPACE</literal> in <xref linkend="server-sql-mode"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>local-infile</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--local-infile[={0|1}]</option> </para> @@ -1480,17 +1430,15 @@ <literal>LOCAL</literal> has no effect if the server does not also support it. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>named-commands</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--named-commands</option>, <option>-G</option> </para> @@ -1500,17 +1448,15 @@ example, <literal>quit</literal> and <literal>\q</literal> both are recognized. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>no-auto-rehash</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--no-auto-rehash</option>, <option>-A</option> </para> @@ -1520,34 +1466,30 @@ the <literal>rehash</literal> command if you want to use table and column name completion. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>no-beep</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--no-beep</option>, <option>-b</option> </para> <para> Do not beep when errors occur. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>no-named-commands</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--no-named-commands</option>, <option>-g</option> </para> @@ -1560,17 +1502,15 @@ with this option, long-format commands still work from the first line. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>no-pager</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--no-pager</option> </para> @@ -1578,17 +1518,15 @@ Do not use a pager for displaying query output. Output paging is discussed further in <xref linkend="mysql-commands"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>no-tee</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--no-tee</option> </para> @@ -1596,17 +1534,15 @@ Do not copy output to a file. Tee files are discussed further in <xref linkend="mysql-commands"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>one-database</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--one-database</option>, <option>-O</option> </para> @@ -1615,17 +1551,15 @@ on the command line. This is useful for skipping updates to other databases in the binary log. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>pager</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--pager[=<replaceable>command</replaceable>]</option> </para> @@ -1639,17 +1573,15 @@ Output paging is discussed further in <xref linkend="mysql-commands"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>password</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--password[=<replaceable>password</replaceable>]</option>, <option>-p[<replaceable>password</replaceable>]</option> </para> @@ -1665,17 +1597,15 @@ should be omitted on SysV-based UNIX systems, as the password may be displayed in the output of <literal>ps</literal>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>port</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--port=<replaceable>port_num</replaceable></option>, <option>-P <replaceable>port_num</replaceable></option> </para> @@ -1683,17 +1613,15 @@ <para> The TCP/IP port number to use for the connection. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>prompt</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--prompt=<replaceable>format_str</replaceable></option> </para> @@ -1703,34 +1631,30 @@ prompt can contain are described in <xref linkend="mysql-commands"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>protocol</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--protocol={TCP | SOCKET | PIPE | MEMORY}</option> </para> <para> The connection protocol to use. New in MySQL 4.1. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>quick</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--quick</option>, <option>-q</option> </para> @@ -1740,17 +1664,15 @@ suspended. With this option, <command>mysql</command> doesn't use the history file. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>raw</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--raw</option>, <option>-r</option> </para> @@ -1758,17 +1680,15 @@ Write column values without escape conversion. Often used with the <option>--batch</option> option. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>reconnect</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--reconnect</option> </para> @@ -1778,17 +1698,15 @@ connection is lost. To suppress reconnection behavior, use <option>--skip-reconnect</option>. New in MySQL 4.1.0. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>safe-updates</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--safe-updates</option>, <option>--i-am-a-dummy</option>, <option>-U</option> </para> @@ -1802,17 +1720,15 @@ <xref linkend="mysql-tips"/> for more information about this option. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>secure-auth</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--secure-auth</option> </para> @@ -1821,17 +1737,15 @@ This prevents connections except for servers that use the newer password format. This option was added in MySQL 4.1.1. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>show-warnings</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--show-warnings</option> </para> @@ -1840,17 +1754,15 @@ any. This option applies to interactive and batch mode. This option was added in MySQL 5.0.6. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>sigint-ignore</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--sigint-ignore</option> </para> @@ -1858,17 +1770,15 @@ Ignore <literal>SIGINT</literal> signals (typically the result of typing Control-C). This option was added in MySQL 4.1.6. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>silent</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--silent</option>, <option>-s</option> </para> @@ -1876,34 +1786,30 @@ Silent mode. Produce less output. This option can be given multiple times to produce less and less output. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>skip-column-names</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--skip-column-names</option>, <option>-N</option> </para> <para> Don't write column names in results. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>skip-line-numbers</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--skip-line-numbers</option>, <option>-L</option> </para> @@ -1911,17 +1817,15 @@ Don't write line numbers for errors. Useful when you want to compare result files that include error messages. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>socket</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--socket=<replaceable>path</replaceable></option>, <option>-S <replaceable>path</replaceable></option> </para> @@ -1929,17 +1833,15 @@ <para> The socket file to use for the connection. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>table</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--table</option>, <option>-t</option> </para> @@ -1948,17 +1850,15 @@ interactive use, but can be used to produce table output in batch mode. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>tee</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--tee=<replaceable>file_name</replaceable></option> </para> @@ -1967,34 +1867,30 @@ not work in batch mode. Tee files are discussed further in <xref linkend="mysql-commands"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>unbuffered</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--unbuffered</option>, <option>-n</option> </para> <para> Flush the buffer after each query. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>user</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--user=<replaceable>user_name</replaceable></option>, <option>-u <replaceable>user_name</replaceable></option> </para> @@ -2002,17 +1898,15 @@ <para> The MySQL username to use when connecting to the server. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>verbose</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--verbose</option>, <option>-v</option> </para> @@ -2022,34 +1916,30 @@ <option>-v -v -v</option> produces the table output format even in batch mode.) </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>version</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--version</option>, <option>-V</option> </para> <para> Display version information and exit. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>vertical</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--vertical</option>, <option>-E</option> </para> @@ -2058,17 +1948,15 @@ option, you can specify vertical output for individual statements by terminating them with <literal>\G</literal>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>wait</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--wait</option>, <option>-w</option> </para> @@ -2076,17 +1964,15 @@ If the connection cannot be established, wait and retry instead of aborting. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>xml</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--xml</option>, <option>-X</option> </para> @@ -2103,35 +1989,19 @@ options: </para> - <indexterm type="concept"> - <primary>timeout</primary> - <secondary><literal>connect_timeout</literal> variable</secondary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>connect_timeout</literal> variable</primary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>max_allowed_packet</literal> variable</primary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>max_join_size</literal> variable</primary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>net_buffer_length</literal> variable</primary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>select_limit</literal> variable</primary> - </indexterm> - <itemizedlist> <listitem> <para> + <indexterm type="concept"> + <primary>timeout</primary> + <secondary><literal>connect_timeout</literal> variable</secondary> + </indexterm> + + <indexterm type="concept"> + <primary><literal>connect_timeout</literal> variable</primary> + </indexterm> + <literal>connect_timeout</literal> </para> @@ -2143,6 +2013,10 @@ <listitem> <para> + <indexterm type="concept"> + <primary><literal>max_allowed_packet</literal> variable</primary> + </indexterm> + <literal>max_allowed_packet</literal> </para> @@ -2154,6 +2028,10 @@ <listitem> <para> + <indexterm type="concept"> + <primary><literal>max_join_size</literal> variable</primary> + </indexterm> + <literal>max_join_size</literal> </para> @@ -2165,6 +2043,10 @@ <listitem> <para> + <indexterm type="concept"> + <primary><literal>net_buffer_length</literal> variable</primary> + </indexterm> + <literal>net_buffer_length</literal> </para> @@ -2176,6 +2058,10 @@ <listitem> <para> + <indexterm type="concept"> + <primary><literal>select_limit</literal> variable</primary> + </indexterm> + <literal>select_limit</literal> </para> @@ -3317,44 +3203,40 @@ <itemizedlist> - <indexterm type="concept"> - <primary>uptime</primary> - </indexterm> - <listitem> <para> + <indexterm type="concept"> + <primary>uptime</primary> + </indexterm> + <literal>Uptime</literal> </para> <para> The number of seconds the MySQL server has been running. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>threads</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Threads</literal> </para> <para> The number of active threads (clients). </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>questions</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Questions</literal> </para> @@ -3362,16 +3244,14 @@ The number of questions (queries) from clients since the server was started. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>slow queries</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Slow queries</literal> </para> @@ -3380,23 +3260,23 @@ <literal>long_query_time</literal> seconds. See <xref linkend="slow-query-log"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>opens</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Opens</literal> </para> <para> The number of tables the server has opened. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>flush tables</primary> @@ -3406,11 +3286,7 @@ <primary>tables</primary> <secondary>flush</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Flush tables</literal> </para> @@ -3419,32 +3295,28 @@ <literal>refresh</literal>, and <literal>reload</literal> commands the server has executed. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>open tables</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Open tables</literal> </para> <para> The number of tables that currently are open. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>memory use</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Memory in use</literal> </para> @@ -3454,16 +3326,14 @@ when MySQL has been compiled with <option>--with-debug=full</option>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>maximum memory used</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Maximum memory used</literal> </para> @@ -3754,28 +3624,19 @@ options: </para> - <indexterm type="concept"> - <primary>timeout</primary> - <secondary><literal>connect_timeout</literal> variable</secondary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>connect_timeout</literal> variable</primary> - </indexterm> - - <indexterm type="concept"> - <primary>timeout</primary> - <secondary><literal>shutdown_timeout</literal> variable</secondary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>shutdown_timeout</literal> variable</primary> - </indexterm> - <itemizedlist> <listitem> <para> + <indexterm type="concept"> + <primary><literal>connect_timeout</literal> variable</primary> + </indexterm> + + <indexterm type="concept"> + <primary>timeout</primary> + <secondary><literal>connect_timeout</literal> variable</secondary> + </indexterm> + <literal>connect_timeout</literal> </para> @@ -3787,6 +3648,15 @@ <listitem> <para> + <indexterm type="concept"> + <primary><literal>shutdown_timeout</literal> variable</primary> + </indexterm> + + <indexterm type="concept"> + <primary>timeout</primary> + <secondary><literal>shutdown_timeout</literal> variable</secondary> + </indexterm> + <literal>shutdown_timeout</literal> </para> @@ -4179,14 +4049,14 @@ options: </para> - <indexterm type="concept"> - <primary><literal>open_files_limit</literal> variable</primary> - </indexterm> - <itemizedlist> <listitem> <para> + <indexterm type="concept"> + <primary><literal>open_files_limit</literal> variable</primary> + </indexterm> + <literal>open_files_limit</literal> </para> @@ -4421,47 +4291,43 @@ <itemizedlist> - <indexterm type="concept"> - <primary><literal>help</literal></primary> - <secondary><command>mysqlcc</command> option</secondary> - </indexterm> - <listitem> <para> + <indexterm type="concept"> + <primary><literal>help</literal></primary> + <secondary><command>mysqlcc</command> option</secondary> + </indexterm> + <option>--help</option>, <option>-?</option> </para> <para> Display a help message and exit. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>blocking_queries</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--blocking_queries</option>, <option>-b</option> </para> <para> Use blocking queries. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>compress</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--compress</option>, <option>-C</option> </para> @@ -4469,17 +4335,15 @@ Compress all information sent between the client and the server if both support compression. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>connection_name</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--connection_name=<replaceable>name</replaceable></option>, <option>-c <replaceable>name</replaceable></option> </para> @@ -4487,17 +4351,15 @@ <para> This option is a synonym for <option>--server</option>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>database</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--database=<replaceable>db_name</replaceable></option>, <option>-d <replaceable>db_name</replaceable></option> </para> @@ -4505,17 +4367,15 @@ <para> The database to use. This is useful mainly in an option file. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>history_size</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--history_size=<replaceable>#</replaceable></option>, <option>-H <replaceable>#</replaceable></option> </para> @@ -4523,17 +4383,15 @@ <para> The history size for the query window. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>host</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--host=<replaceable>host_name</replaceable></option>, <option>-h <replaceable>host_name</replaceable></option> </para> @@ -4541,17 +4399,15 @@ <para> Connect to the MySQL server on the given host. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>local-infile</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--local-infile[={0|1}]</option> </para> @@ -4565,17 +4421,15 @@ <literal>LOCAL</literal> has no effect if the server does not also support it. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>password</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--password[=<replaceable>password</replaceable>]</option>, <option>-p[<replaceable>password</replaceable>]</option> </para> @@ -4589,17 +4443,15 @@ <option>--password</option> or <option>-p</option> option on the command line, you are prompted for one. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>plugins_path</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--plugins_path=<replaceable>name</replaceable></option>, <option>-g <replaceable>name</replaceable></option> </para> @@ -4608,17 +4460,15 @@ The path to the directory where MySQL Control Center plugins are located. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>port</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--port=<replaceable>port_num</replaceable></option>, <option>-P <replaceable>port_num</replaceable></option> </para> @@ -4626,51 +4476,45 @@ <para> The TCP/IP port number to use for the connection. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>query</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--query</option>, <option>-q</option> </para> <para> Open a query window on startup. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>register</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--register</option>, <option>-r</option> </para> <para> Open the Register Server dialog on startup. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>server</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--server=<replaceable>name</replaceable></option>, <option>-s <replaceable>name</replaceable></option> </para> @@ -4678,17 +4522,15 @@ <para> The MySQL Control Center connection name. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>socket</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--socket=<replaceable>path</replaceable></option>, <option>-S <replaceable>path</replaceable></option> </para> @@ -4696,34 +4538,30 @@ <para> The socket file to use for the connection. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>syntax</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--syntax</option>, <option>-y</option> </para> <para> Enable syntax highlighting and completion. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>syntax_file</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--syntax_file=<replaceable>name</replaceable></option>, <option>-Y <replaceable>name</replaceable></option> </para> @@ -4731,17 +4569,15 @@ <para> The syntax file for completion. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>translations_path</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--translations_path=<replaceable>name</replaceable></option>, <option>-T <replaceable>name</replaceable></option> </para> @@ -4750,17 +4586,15 @@ The path to the directory where MySQL Control Center translations are located. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>user</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--user=<replaceable>user_name</replaceable></option>, <option>-u <replaceable>user_name</replaceable></option> </para> @@ -4768,17 +4602,15 @@ <para> The MySQL username to use when connecting to the server. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>version</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--version</option>, <option>-V</option> </para> --- 1.13/refman/client-side-scripts.xml 2005-08-08 17:12:08 -05:00 +++ 1.14/refman/client-side-scripts.xml 2005-08-08 17:42:08 -05:00 @@ -45,12 +45,12 @@ <itemizedlist> - <indexterm type="concept"> - <primary><command>myisampack</command></primary> - </indexterm> - <listitem> <para> + <indexterm type="concept"> + <primary><command>myisampack</command></primary> + </indexterm> + <literal>myisampack</literal> </para> @@ -59,16 +59,14 @@ produce smaller read-only tables. See <xref linkend="myisampack"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysql</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysql</literal> </para> @@ -77,16 +75,14 @@ statements or executing them from a file in batch mode. See <xref linkend="mysql"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlaccess</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlaccess</literal> </para> @@ -94,16 +90,14 @@ A script that checks the access privileges for a host, user, and database combination. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqladmin</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqladmin</literal> </para> @@ -115,16 +109,14 @@ version, process, and status information from the server. See <xref linkend="mysqladmin"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlbinlog</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlbinlog</literal> </para> @@ -134,16 +126,14 @@ used to help recover from a crash. See <xref linkend="mysqlbinlog"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlcc</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlcc</literal> </para> @@ -151,16 +141,14 @@ A client that provides a graphical interface for interacting with the server. See <xref linkend="mysqlcc"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlcheck</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlcheck</literal> </para> @@ -168,16 +156,14 @@ A table-maintenance client that checks, repairs, analyzes, and optimizes tables. See <xref linkend="using-mysqlcheck"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqldump</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqldump</literal> </para> @@ -186,16 +172,14 @@ statements or as tab-separated text files. Enhanced freeware originally by Igor Romanenko. See <xref linkend="mysqldump"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlhotcopy</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlhotcopy</literal> </para> @@ -205,16 +189,14 @@ while the server is running. See <xref linkend="mysqlhotcopy"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlimport</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlimport</literal> </para> @@ -223,16 +205,14 @@ using <literal>LOAD DATA INFILE</literal>. See <xref linkend="mysqlimport"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlshow</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlshow</literal> </para> @@ -240,16 +220,14 @@ A client that displays information about databases, tables, columns, and indexes. See <xref linkend="mysqlshow"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>perror</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>perror</literal> </para> @@ -257,16 +235,14 @@ A utility that displays the meaning of system or MySQL error codes. See <xref linkend="perror"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>replace</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>replace</literal> </para> @@ -1223,30 +1199,28 @@ <itemizedlist> - <indexterm type="concept"> - <primary><literal>help</literal></primary> - <secondary><command>mysql</command> option</secondary> - </indexterm> - <listitem> <para> + <indexterm type="concept"> + <primary><literal>help</literal></primary> + <secondary><command>mysql</command> option</secondary> + </indexterm> + <option>--help</option>, <option>-?</option> </para> <para> Display a help message and exit. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>batch</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--batch</option>, <option>-B</option> </para> @@ -1255,17 +1229,15 @@ on a new line. With this option, <command>mysql</command> doesn't use the history file. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>character-sets-dir</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--character-sets-dir=<replaceable>path</replaceable></option> </para> @@ -1273,17 +1245,15 @@ The directory where character sets are installed. See <xref linkend="character-sets"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>compress</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--compress</option>, <option>-C</option> </para> @@ -1291,17 +1261,15 @@ Compress all information sent between the client and the server if both support compression. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>database</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--database=<replaceable>db_name</replaceable></option>, <option>-D <replaceable>db_name</replaceable></option> </para> @@ -1309,17 +1277,15 @@ <para> The database to use. This is useful mainly in an option file. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>debug</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--debug[=<replaceable>debug_options</replaceable>]</option>, <option>-# [<replaceable>debug_options</replaceable>]</option> </para> @@ -1330,34 +1296,30 @@ <literal>'d:t:o,<replaceable>file_name</replaceable>'</literal>. The default is <literal>'d:t:o,/tmp/mysql.trace'</literal>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>debug-info</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--debug-info</option>, <option>-T</option> </para> <para> Print some debugging information when the program exits. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>default-character-set</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--default-character-set=<replaceable>charset</replaceable></option> </para> @@ -1365,17 +1327,15 @@ Use <replaceable>charset</replaceable> as the default character set. See <xref linkend="character-sets"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>execute</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--execute=<replaceable>statement</replaceable></option>, <option>-e <replaceable>statement</replaceable></option> </para> @@ -1384,34 +1344,30 @@ Execute the statement and quit. The default output format is like that produced with <option>--batch</option>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>force</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--force</option>, <option>-f</option> </para> <para> Continue even if an SQL error occurs. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>host</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--host=<replaceable>host_name</replaceable></option>, <option>-h <replaceable>host_name</replaceable></option> </para> @@ -1419,34 +1375,30 @@ <para> Connect to the MySQL server on the given host. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>html</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--html</option>, <option>-H</option> </para> <para> Produce HTML output. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>ignore-space</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--ignore-space</option>, <option>-i</option> </para> @@ -1456,17 +1408,15 @@ <literal>IGNORE_SPACE</literal> in <xref linkend="server-sql-mode"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>local-infile</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--local-infile[={0|1}]</option> </para> @@ -1480,17 +1430,15 @@ <literal>LOCAL</literal> has no effect if the server does not also support it. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>named-commands</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--named-commands</option>, <option>-G</option> </para> @@ -1500,17 +1448,15 @@ example, <literal>quit</literal> and <literal>\q</literal> both are recognized. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>no-auto-rehash</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--no-auto-rehash</option>, <option>-A</option> </para> @@ -1520,34 +1466,30 @@ the <literal>rehash</literal> command if you want to use table and column name completion. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>no-beep</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--no-beep</option>, <option>-b</option> </para> <para> Do not beep when errors occur. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>no-named-commands</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--no-named-commands</option>, <option>-g</option> </para> @@ -1560,17 +1502,15 @@ with this option, long-format commands still work from the first line. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>no-pager</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--no-pager</option> </para> @@ -1578,17 +1518,15 @@ Do not use a pager for displaying query output. Output paging is discussed further in <xref linkend="mysql-commands"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>no-tee</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--no-tee</option> </para> @@ -1596,17 +1534,15 @@ Do not copy output to a file. Tee files are discussed further in <xref linkend="mysql-commands"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>one-database</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--one-database</option>, <option>-O</option> </para> @@ -1615,17 +1551,15 @@ on the command line. This is useful for skipping updates to other databases in the binary log. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>pager</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--pager[=<replaceable>command</replaceable>]</option> </para> @@ -1639,17 +1573,15 @@ Output paging is discussed further in <xref linkend="mysql-commands"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>password</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--password[=<replaceable>password</replaceable>]</option>, <option>-p[<replaceable>password</replaceable>]</option> </para> @@ -1665,17 +1597,15 @@ should be omitted on SysV-based UNIX systems, as the password may be displayed in the output of <literal>ps</literal>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>port</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--port=<replaceable>port_num</replaceable></option>, <option>-P <replaceable>port_num</replaceable></option> </para> @@ -1683,17 +1613,15 @@ <para> The TCP/IP port number to use for the connection. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>prompt</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--prompt=<replaceable>format_str</replaceable></option> </para> @@ -1703,34 +1631,30 @@ prompt can contain are described in <xref linkend="mysql-commands"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>protocol</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--protocol={TCP | SOCKET | PIPE | MEMORY}</option> </para> <para> The connection protocol to use. New in MySQL 4.1. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>quick</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--quick</option>, <option>-q</option> </para> @@ -1740,17 +1664,15 @@ suspended. With this option, <command>mysql</command> doesn't use the history file. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>raw</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--raw</option>, <option>-r</option> </para> @@ -1758,17 +1680,15 @@ Write column values without escape conversion. Often used with the <option>--batch</option> option. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>reconnect</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--reconnect</option> </para> @@ -1778,17 +1698,15 @@ connection is lost. To suppress reconnection behavior, use <option>--skip-reconnect</option>. New in MySQL 4.1.0. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>safe-updates</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--safe-updates</option>, <option>--i-am-a-dummy</option>, <option>-U</option> </para> @@ -1802,17 +1720,15 @@ <xref linkend="mysql-tips"/> for more information about this option. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>secure-auth</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--secure-auth</option> </para> @@ -1821,17 +1737,15 @@ This prevents connections except for servers that use the newer password format. This option was added in MySQL 4.1.1. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>show-warnings</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--show-warnings</option> </para> @@ -1840,17 +1754,15 @@ any. This option applies to interactive and batch mode. This option was added in MySQL 5.0.6. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>sigint-ignore</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--sigint-ignore</option> </para> @@ -1858,17 +1770,15 @@ Ignore <literal>SIGINT</literal> signals (typically the result of typing Control-C). This option was added in MySQL 4.1.6. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>silent</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--silent</option>, <option>-s</option> </para> @@ -1876,34 +1786,30 @@ Silent mode. Produce less output. This option can be given multiple times to produce less and less output. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>skip-column-names</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--skip-column-names</option>, <option>-N</option> </para> <para> Don't write column names in results. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>skip-line-numbers</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--skip-line-numbers</option>, <option>-L</option> </para> @@ -1911,17 +1817,15 @@ Don't write line numbers for errors. Useful when you want to compare result files that include error messages. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>socket</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--socket=<replaceable>path</replaceable></option>, <option>-S <replaceable>path</replaceable></option> </para> @@ -1929,17 +1833,15 @@ <para> The socket file to use for the connection. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>table</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--table</option>, <option>-t</option> </para> @@ -1948,17 +1850,15 @@ interactive use, but can be used to produce table output in batch mode. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>tee</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--tee=<replaceable>file_name</replaceable></option> </para> @@ -1967,34 +1867,30 @@ not work in batch mode. Tee files are discussed further in <xref linkend="mysql-commands"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>unbuffered</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--unbuffered</option>, <option>-n</option> </para> <para> Flush the buffer after each query. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>user</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--user=<replaceable>user_name</replaceable></option>, <option>-u <replaceable>user_name</replaceable></option> </para> @@ -2002,17 +1898,15 @@ <para> The MySQL username to use when connecting to the server. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>verbose</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--verbose</option>, <option>-v</option> </para> @@ -2022,34 +1916,30 @@ <option>-v -v -v</option> produces the table output format even in batch mode.) </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>version</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--version</option>, <option>-V</option> </para> <para> Display version information and exit. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>vertical</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--vertical</option>, <option>-E</option> </para> @@ -2058,17 +1948,15 @@ option, you can specify vertical output for individual statements by terminating them with <literal>\G</literal>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>wait</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--wait</option>, <option>-w</option> </para> @@ -2076,17 +1964,15 @@ If the connection cannot be established, wait and retry instead of aborting. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>xml</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--xml</option>, <option>-X</option> </para> @@ -2103,35 +1989,19 @@ options: </para> - <indexterm type="concept"> - <primary>timeout</primary> - <secondary><literal>connect_timeout</literal> variable</secondary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>connect_timeout</literal> variable</primary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>max_allowed_packet</literal> variable</primary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>max_join_size</literal> variable</primary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>net_buffer_length</literal> variable</primary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>select_limit</literal> variable</primary> - </indexterm> - <itemizedlist> <listitem> <para> + <indexterm type="concept"> + <primary>timeout</primary> + <secondary><literal>connect_timeout</literal> variable</secondary> + </indexterm> + + <indexterm type="concept"> + <primary><literal>connect_timeout</literal> variable</primary> + </indexterm> + <literal>connect_timeout</literal> </para> @@ -2143,6 +2013,10 @@ <listitem> <para> + <indexterm type="concept"> + <primary><literal>max_allowed_packet</literal> variable</primary> + </indexterm> + <literal>max_allowed_packet</literal> </para> @@ -2154,6 +2028,10 @@ <listitem> <para> + <indexterm type="concept"> + <primary><literal>max_join_size</literal> variable</primary> + </indexterm> + <literal>max_join_size</literal> </para> @@ -2165,6 +2043,10 @@ <listitem> <para> + <indexterm type="concept"> + <primary><literal>net_buffer_length</literal> variable</primary> + </indexterm> + <literal>net_buffer_length</literal> </para> @@ -2176,6 +2058,10 @@ <listitem> <para> + <indexterm type="concept"> + <primary><literal>select_limit</literal> variable</primary> + </indexterm> + <literal>select_limit</literal> </para> @@ -3317,44 +3203,40 @@ <itemizedlist> - <indexterm type="concept"> - <primary>uptime</primary> - </indexterm> - <listitem> <para> + <indexterm type="concept"> + <primary>uptime</primary> + </indexterm> + <literal>Uptime</literal> </para> <para> The number of seconds the MySQL server has been running. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>threads</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Threads</literal> </para> <para> The number of active threads (clients). </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>questions</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Questions</literal> </para> @@ -3362,16 +3244,14 @@ The number of questions (queries) from clients since the server was started. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>slow queries</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Slow queries</literal> </para> @@ -3380,23 +3260,23 @@ <literal>long_query_time</literal> seconds. See <xref linkend="slow-query-log"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>opens</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Opens</literal> </para> <para> The number of tables the server has opened. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>flush tables</primary> @@ -3406,11 +3286,7 @@ <primary>tables</primary> <secondary>flush</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Flush tables</literal> </para> @@ -3419,32 +3295,28 @@ <literal>refresh</literal>, and <literal>reload</literal> commands the server has executed. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>open tables</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Open tables</literal> </para> <para> The number of tables that currently are open. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>memory use</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Memory in use</literal> </para> @@ -3454,16 +3326,14 @@ when MySQL has been compiled with <option>--with-debug=full</option>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>maximum memory used</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Maximum memory used</literal> </para> @@ -3754,28 +3624,19 @@ options: </para> - <indexterm type="concept"> - <primary>timeout</primary> - <secondary><literal>connect_timeout</literal> variable</secondary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>connect_timeout</literal> variable</primary> - </indexterm> - - <indexterm type="concept"> - <primary>timeout</primary> - <secondary><literal>shutdown_timeout</literal> variable</secondary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>shutdown_timeout</literal> variable</primary> - </indexterm> - <itemizedlist> <listitem> <para> + <indexterm type="concept"> + <primary><literal>connect_timeout</literal> variable</primary> + </indexterm> + + <indexterm type="concept"> + <primary>timeout</primary> + <secondary><literal>connect_timeout</literal> variable</secondary> + </indexterm> + <literal>connect_timeout</literal> </para> @@ -3787,6 +3648,15 @@ <listitem> <para> + <indexterm type="concept"> + <primary><literal>shutdown_timeout</literal> variable</primary> + </indexterm> + + <indexterm type="concept"> + <primary>timeout</primary> + <secondary><literal>shutdown_timeout</literal> variable</secondary> + </indexterm> + <literal>shutdown_timeout</literal> </para> @@ -4179,14 +4049,14 @@ options: </para> - <indexterm type="concept"> - <primary><literal>open_files_limit</literal> variable</primary> - </indexterm> - <itemizedlist> <listitem> <para> + <indexterm type="concept"> + <primary><literal>open_files_limit</literal> variable</primary> + </indexterm> + <literal>open_files_limit</literal> </para> @@ -4421,47 +4291,43 @@ <itemizedlist> - <indexterm type="concept"> - <primary><literal>help</literal></primary> - <secondary><command>mysqlcc</command> option</secondary> - </indexterm> - <listitem> <para> + <indexterm type="concept"> + <primary><literal>help</literal></primary> + <secondary><command>mysqlcc</command> option</secondary> + </indexterm> + <option>--help</option>, <option>-?</option> </para> <para> Display a help message and exit. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>blocking_queries</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--blocking_queries</option>, <option>-b</option> </para> <para> Use blocking queries. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>compress</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--compress</option>, <option>-C</option> </para> @@ -4469,17 +4335,15 @@ Compress all information sent between the client and the server if both support compression. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>connection_name</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--connection_name=<replaceable>name</replaceable></option>, <option>-c <replaceable>name</replaceable></option> </para> @@ -4487,17 +4351,15 @@ <para> This option is a synonym for <option>--server</option>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>database</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--database=<replaceable>db_name</replaceable></option>, <option>-d <replaceable>db_name</replaceable></option> </para> @@ -4505,17 +4367,15 @@ <para> The database to use. This is useful mainly in an option file. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>history_size</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--history_size=<replaceable>#</replaceable></option>, <option>-H <replaceable>#</replaceable></option> </para> @@ -4523,17 +4383,15 @@ <para> The history size for the query window. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>host</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--host=<replaceable>host_name</replaceable></option>, <option>-h <replaceable>host_name</replaceable></option> </para> @@ -4541,17 +4399,15 @@ <para> Connect to the MySQL server on the given host. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>local-infile</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--local-infile[={0|1}]</option> </para> @@ -4565,17 +4421,15 @@ <literal>LOCAL</literal> has no effect if the server does not also support it. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>password</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--password[=<replaceable>password</replaceable>]</option>, <option>-p[<replaceable>password</replaceable>]</option> </para> @@ -4589,17 +4443,15 @@ <option>--password</option> or <option>-p</option> option on the command line, you are prompted for one. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>plugins_path</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--plugins_path=<replaceable>name</replaceable></option>, <option>-g <replaceable>name</replaceable></option> </para> @@ -4608,17 +4460,15 @@ The path to the directory where MySQL Control Center plugins are located. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>port</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--port=<replaceable>port_num</replaceable></option>, <option>-P <replaceable>port_num</replaceable></option> </para> @@ -4626,51 +4476,45 @@ <para> The TCP/IP port number to use for the connection. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>query</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--query</option>, <option>-q</option> </para> <para> Open a query window on startup. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>register</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--register</option>, <option>-r</option> </para> <para> Open the Register Server dialog on startup. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>server</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--server=<replaceable>name</replaceable></option>, <option>-s <replaceable>name</replaceable></option> </para> @@ -4678,17 +4522,15 @@ <para> The MySQL Control Center connection name. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>socket</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--socket=<replaceable>path</replaceable></option>, <option>-S <replaceable>path</replaceable></option> </para> @@ -4696,34 +4538,30 @@ <para> The socket file to use for the connection. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>syntax</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--syntax</option>, <option>-y</option> </para> <para> Enable syntax highlighting and completion. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>syntax_file</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--syntax_file=<replaceable>name</replaceable></option>, <option>-Y <replaceable>name</replaceable></option> </para> @@ -4731,17 +4569,15 @@ <para> The syntax file for completion. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>translations_path</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--translations_path=<replaceable>name</replaceable></option>, <option>-T <replaceable>name</replaceable></option> </para> @@ -4750,17 +4586,15 @@ The path to the directory where MySQL Control Center translations are located. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>user</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--user=<replaceable>user_name</replaceable></option>, <option>-u <replaceable>user_name</replaceable></option> </para> @@ -4768,17 +4602,15 @@ <para> The MySQL username to use when connecting to the server. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>version</literal></primary> <secondary><command>mysqlcc</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--version</option>, <option>-V</option> </para> --- 1.3/refman-5.0/client-side-scripts.xml 2005-08-08 17:12:07 -05:00 +++ 1.4/refman-5.0/client-side-scripts.xml 2005-08-08 17:42:07 -05:00 @@ -45,12 +45,12 @@ <itemizedlist> - <indexterm type="concept"> - <primary><command>myisampack</command></primary> - </indexterm> - <listitem> <para> + <indexterm type="concept"> + <primary><command>myisampack</command></primary> + </indexterm> + <literal>myisampack</literal> </para> @@ -59,16 +59,14 @@ produce smaller read-only tables. See <xref linkend="myisampack"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysql</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysql</literal> </para> @@ -77,16 +75,14 @@ statements or executing them from a file in batch mode. See <xref linkend="mysql"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlaccess</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlaccess</literal> </para> @@ -94,16 +90,14 @@ A script that checks the access privileges for a host, user, and database combination. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqladmin</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqladmin</literal> </para> @@ -115,16 +109,14 @@ version, process, and status information from the server. See <xref linkend="mysqladmin"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlbinlog</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlbinlog</literal> </para> @@ -142,59 +134,52 @@ <para> MySQL AB also provide three GUI client programs for use with the MySQL server: + </para> - <itemizedlist> - - <listitem> - <para> - <ulink url="http://dev.mysql.com/doc/administrator/en/">MySQL - Administrator</ulink>: This tool is used for - administering MySQL servers, databases, tables, and - users. - </para> - </listitem> - - <listitem> - <para> - <ulink url="http://dev.mysql.com/doc/query-browser/en/">MySQL - Query Browser</ulink>: This graphical tool is provided - by MySQL AB for creating, executing, and optimizing - queries on MySQL databases. - </para> - </listitem> - - <listitem> - <para> - <ulink url="http://dev.mysql.com/doc/migration-toolkit/en/">MySQL - Migration Toolkit</ulink>: This tool is intended to help - you with migrating schemas and data from other - relational database management systems to MySQL. - </para> - </listitem> + <itemizedlist> - </itemizedlist> - </para> + <listitem> + <para> + <indexterm type="concept"> + <primary>GUI tools</primary> + <secondary>MySQL Administrator</secondary> + </indexterm> + + <ulink url="http://dev.mysql.com/doc/administrator/en/">MySQL + Administrator</ulink>: This tool is used for administering + MySQL servers, databases, tables, and users. + </para> + </listitem> - <para> - <indexterm type="concept"> - <primary>GUI tools</primary> - <secondary>MySQL Administrator</secondary> - </indexterm> - </para> + <listitem> + <para> + <indexterm type="concept"> + <primary>graphical clients</primary> + <secondary>MySQL Query Browser</secondary> + </indexterm> + + <ulink url="http://dev.mysql.com/doc/query-browser/en/">MySQL + Query Browser</ulink>: This graphical tool is provided by + MySQL AB for creating, executing, and optimizing queries + on MySQL databases. + </para> + </listitem> - <para> - <indexterm type="concept"> - <primary>graphical clients</primary> - <secondary>MySQL Query Browser</secondary> - </indexterm> - </para> + <listitem> + <para> + <indexterm type="concept"> + <primary>graphical tools</primary> + <secondary>MySQL Migration Toolkit</secondary> + </indexterm> + + <ulink url="http://dev.mysql.com/doc/migration-toolkit/en/">MySQL + Migration Toolkit</ulink>: This tool is intended to help + you with migrating schemas and data from other relational + database management systems to MySQL. + </para> + </listitem> - <para> - <indexterm type="concept"> - <primary>graphical tools</primary> - <secondary>MySQL Migration Toolkit</secondary> - </indexterm> - </para> + </itemizedlist> </listitem> <listitem> @@ -202,11 +187,7 @@ <indexterm type="concept"> <primary><command>mysqlcheck</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlcheck</literal> </para> @@ -214,16 +195,14 @@ A table-maintenance client that checks, repairs, analyzes, and optimizes tables. See <xref linkend="using-mysqlcheck"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqldump</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqldump</literal> </para> @@ -232,16 +211,14 @@ statements or as tab-separated text files. Enhanced freeware originally by Igor Romanenko. See <xref linkend="mysqldump"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlhotcopy</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlhotcopy</literal> </para> @@ -251,16 +228,14 @@ while the server is running. See <xref linkend="mysqlhotcopy"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlimport</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlimport</literal> </para> @@ -269,16 +244,14 @@ using <literal>LOAD DATA INFILE</literal>. See <xref linkend="mysqlimport"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>mysqlshow</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>mysqlshow</literal> </para> @@ -286,16 +259,14 @@ A client that displays information about databases, tables, columns, and indexes. See <xref linkend="mysqlshow"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>perror</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>perror</literal> </para> @@ -303,16 +274,14 @@ A utility that displays the meaning of system or MySQL error codes. See <xref linkend="perror"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><command>replace</command></primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>replace</literal> </para> @@ -1251,30 +1220,28 @@ <itemizedlist> - <indexterm type="concept"> - <primary><literal>help</literal></primary> - <secondary><command>mysql</command> option</secondary> - </indexterm> - <listitem> <para> + <indexterm type="concept"> + <primary><literal>help</literal></primary> + <secondary><command>mysql</command> option</secondary> + </indexterm> + <option>--help</option>, <option>-?</option> </para> <para> Display a help message and exit. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>batch</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--batch</option>, <option>-B</option> </para> @@ -1283,17 +1250,15 @@ on a new line. With this option, <command>mysql</command> doesn't use the history file. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>character-sets-dir</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--character-sets-dir=<replaceable>path</replaceable></option> </para> @@ -1301,17 +1266,15 @@ The directory where character sets are installed. See <xref linkend="character-sets"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>compress</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--compress</option>, <option>-C</option> </para> @@ -1319,17 +1282,15 @@ Compress all information sent between the client and the server if both support compression. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>database</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--database=<replaceable>db_name</replaceable></option>, <option>-D <replaceable>db_name</replaceable></option> </para> @@ -1337,17 +1298,15 @@ <para> The database to use. This is useful mainly in an option file. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>debug</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--debug[=<replaceable>debug_options</replaceable>]</option>, <option>-# [<replaceable>debug_options</replaceable>]</option> </para> @@ -1358,34 +1317,30 @@ <literal>'d:t:o,<replaceable>file_name</replaceable>'</literal>. The default is <literal>'d:t:o,/tmp/mysql.trace'</literal>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>debug-info</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--debug-info</option>, <option>-T</option> </para> <para> Print some debugging information when the program exits. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>default-character-set</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--default-character-set=<replaceable>charset</replaceable></option> </para> @@ -1393,17 +1348,15 @@ Use <replaceable>charset</replaceable> as the default character set. See <xref linkend="character-sets"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>execute</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--execute=<replaceable>statement</replaceable></option>, <option>-e <replaceable>statement</replaceable></option> </para> @@ -1413,34 +1366,30 @@ like that produced with <option>--batch</option>. See <xref linkend="command-line-options"/> for some examples. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>force</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--force</option>, <option>-f</option> </para> <para> Continue even if an SQL error occurs. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>host</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--host=<replaceable>host_name</replaceable></option>, <option>-h <replaceable>host_name</replaceable></option> </para> @@ -1448,34 +1397,30 @@ <para> Connect to the MySQL server on the given host. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>html</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--html</option>, <option>-H</option> </para> <para> Produce HTML output. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>ignore-space</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--ignore-space</option>, <option>-i</option> </para> @@ -1485,17 +1430,15 @@ <literal>IGNORE_SPACE</literal> in <xref linkend="server-sql-mode"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>local-infile</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--local-infile[={0|1}]</option> </para> @@ -1509,17 +1452,15 @@ <literal>LOCAL</literal> has no effect if the server does not also support it. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>named-commands</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--named-commands</option>, <option>-G</option> </para> @@ -1529,17 +1470,15 @@ example, <literal>quit</literal> and <literal>\q</literal> both are recognized. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>no-auto-rehash</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--no-auto-rehash</option>, <option>-A</option> </para> @@ -1549,34 +1488,30 @@ the <literal>rehash</literal> command if you want to use table and column name completion. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>no-beep</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--no-beep</option>, <option>-b</option> </para> <para> Do not beep when errors occur. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>no-named-commands</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--no-named-commands</option>, <option>-g</option> </para> @@ -1589,17 +1524,15 @@ with this option, long-format commands still work from the first line. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>no-pager</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--no-pager</option> </para> @@ -1607,17 +1540,15 @@ Do not use a pager for displaying query output. Output paging is discussed further in <xref linkend="mysql-commands"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>no-tee</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--no-tee</option> </para> @@ -1625,17 +1556,15 @@ Do not copy output to a file. Tee files are discussed further in <xref linkend="mysql-commands"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>one-database</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--one-database</option>, <option>-O</option> </para> @@ -1644,17 +1573,15 @@ on the command line. This is useful for skipping updates to other databases in the binary log. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>pager</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--pager[=<replaceable>command</replaceable>]</option> </para> @@ -1668,17 +1595,15 @@ Output paging is discussed further in <xref linkend="mysql-commands"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>password</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--password[=<replaceable>password</replaceable>]</option>, <option>-p[<replaceable>password</replaceable>]</option> </para> @@ -1694,17 +1619,15 @@ should be omitted on SysV-based UNIX systems, as the password may be displayed in the output of <literal>ps</literal>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>port</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--port=<replaceable>port_num</replaceable></option>, <option>-P <replaceable>port_num</replaceable></option> </para> @@ -1712,17 +1635,15 @@ <para> The TCP/IP port number to use for the connection. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>prompt</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--prompt=<replaceable>format_str</replaceable></option> </para> @@ -1732,34 +1653,30 @@ prompt can contain are described in <xref linkend="mysql-commands"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>protocol</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--protocol={TCP | SOCKET | PIPE | MEMORY}</option> </para> <para> The connection protocol to use. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>quick</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--quick</option>, <option>-q</option> </para> @@ -1769,17 +1686,15 @@ suspended. With this option, <command>mysql</command> doesn't use the history file. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>raw</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--raw</option>, <option>-r</option> </para> @@ -1787,17 +1702,15 @@ Write column values without escape conversion. Often used with the <option>--batch</option> option. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>reconnect</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--reconnect</option> </para> @@ -1807,17 +1720,15 @@ connection is lost. To suppress reconnection behavior, use <option>--skip-reconnect</option>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>safe-updates</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--safe-updates</option>, <option>--i-am-a-dummy</option>, <option>-U</option> </para> @@ -1831,17 +1742,15 @@ <xref linkend="mysql-tips"/> for more information about this option. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>secure-auth</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--secure-auth</option> </para> @@ -1850,17 +1759,15 @@ This prevents connections except for servers that use the newer password format. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>show-warnings</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--show-warnings</option> </para> @@ -1869,17 +1776,15 @@ any. This option applies to interactive and batch mode. This option was added in MySQL 5.0.6. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>sigint-ignore</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--sigint-ignore</option> </para> @@ -1887,17 +1792,15 @@ Ignore <literal>SIGINT</literal> signals (typically the result of typing Control-C). </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>silent</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--silent</option>, <option>-s</option> </para> @@ -1905,34 +1808,30 @@ Silent mode. Produce less output. This option can be given multiple times to produce less and less output. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>skip-column-names</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--skip-column-names</option>, <option>-N</option> </para> <para> Do not write column names in results. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>skip-line-numbers</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--skip-line-numbers</option>, <option>-L</option> </para> @@ -1940,17 +1839,15 @@ Do not write line numbers for errors. Useful when you want to compare result files that include error messages. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>socket</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--socket=<replaceable>path</replaceable></option>, <option>-S <replaceable>path</replaceable></option> </para> @@ -1958,17 +1855,15 @@ <para> The socket file to use for the connection. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>table</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--table</option>, <option>-t</option> </para> @@ -1977,17 +1872,15 @@ interactive use, but can be used to produce table output in batch mode. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>tee</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--tee=<replaceable>file_name</replaceable></option> </para> @@ -1996,34 +1889,30 @@ not work in batch mode. Tee files are discussed further in <xref linkend="mysql-commands"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>unbuffered</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--unbuffered</option>, <option>-n</option> </para> <para> Flush the buffer after each query. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>user</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--user=<replaceable>user_name</replaceable></option>, <option>-u <replaceable>user_name</replaceable></option> </para> @@ -2031,17 +1920,15 @@ <para> The MySQL username to use when connecting to the server. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>verbose</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--verbose</option>, <option>-v</option> </para> @@ -2051,34 +1938,30 @@ <option>-v -v -v</option> produces the table output format even in batch mode.) </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>version</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--version</option>, <option>-V</option> </para> <para> Display version information and exit. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>vertical</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--vertical</option>, <option>-E</option> </para> @@ -2087,17 +1970,15 @@ option, you can specify vertical output for individual statements by terminating them with <literal>\G</literal>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>wait</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--wait</option>, <option>-w</option> </para> @@ -2105,17 +1986,15 @@ If the connection cannot be established, wait and retry instead of aborting. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary><literal>xml</literal></primary> <secondary><command>mysql</command> option</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <option>--xml</option>, <option>-X</option> </para> @@ -2132,35 +2011,19 @@ options: </para> - <indexterm type="concept"> - <primary>timeout</primary> - <secondary><literal>connect_timeout</literal> variable</secondary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>connect_timeout</literal> variable</primary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>max_allowed_packet</literal> variable</primary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>max_join_size</literal> variable</primary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>net_buffer_length</literal> variable</primary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>select_limit</literal> variable</primary> - </indexterm> - <itemizedlist> <listitem> <para> + <indexterm type="concept"> + <primary>timeout</primary> + <secondary><literal>connect_timeout</literal> variable</secondary> + </indexterm> + + <indexterm type="concept"> + <primary><literal>connect_timeout</literal> variable</primary> + </indexterm> + <literal>connect_timeout</literal> </para> @@ -2172,6 +2035,10 @@ <listitem> <para> + <indexterm type="concept"> + <primary><literal>max_allowed_packet</literal> variable</primary> + </indexterm> + <literal>max_allowed_packet</literal> </para> @@ -2183,6 +2050,10 @@ <listitem> <para> + <indexterm type="concept"> + <primary><literal>max_join_size</literal> variable</primary> + </indexterm> + <literal>max_join_size</literal> </para> @@ -2194,6 +2065,10 @@ <listitem> <para> + <indexterm type="concept"> + <primary><literal>net_buffer_length</literal> variable</primary> + </indexterm> + <literal>net_buffer_length</literal> </para> @@ -2205,6 +2080,10 @@ <listitem> <para> + <indexterm type="concept"> + <primary><literal>select_limit</literal> variable</primary> + </indexterm> + <literal>select_limit</literal> </para> @@ -3347,44 +3226,40 @@ <itemizedlist> - <indexterm type="concept"> - <primary>uptime</primary> - </indexterm> - <listitem> <para> + <indexterm type="concept"> + <primary>uptime</primary> + </indexterm> + <literal>Uptime</literal> </para> <para> The number of seconds the MySQL server has been running. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>threads</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Threads</literal> </para> <para> The number of active threads (clients). </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>questions</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Questions</literal> </para> @@ -3392,16 +3267,14 @@ The number of questions (queries) from clients since the server was started. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>slow queries</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Slow queries</literal> </para> @@ -3410,23 +3283,23 @@ <literal>long_query_time</literal> seconds. See <xref linkend="slow-query-log"/>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>opens</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Opens</literal> </para> <para> The number of tables the server has opened. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>flush tables</primary> @@ -3436,11 +3309,7 @@ <primary>tables</primary> <secondary>flush</secondary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Flush tables</literal> </para> @@ -3449,32 +3318,28 @@ <literal>refresh</literal>, and <literal>reload</literal> commands the server has executed. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>open tables</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Open tables</literal> </para> <para> The number of tables that currently are open. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>memory use</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Memory in use</literal> </para> @@ -3484,16 +3349,14 @@ when MySQL has been compiled with <option>--with-debug=full</option>. </para> + </listitem> + <listitem> <para> <indexterm type="concept"> <primary>maximum memory used</primary> </indexterm> - </para> - </listitem> - <listitem> - <para> <literal>Maximum memory used</literal> </para> @@ -3783,28 +3646,19 @@ options: </para> - <indexterm type="concept"> - <primary>timeout</primary> - <secondary><literal>connect_timeout</literal> variable</secondary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>connect_timeout</literal> variable</primary> - </indexterm> - - <indexterm type="concept"> - <primary>timeout</primary> - <secondary><literal>shutdown_timeout</literal> variable</secondary> - </indexterm> - - <indexterm type="concept"> - <primary><literal>shutdown_timeout</literal> variable</primary> - </indexterm> - <itemizedlist> <listitem> <para> + <indexterm type="concept"> + <primary><literal>connect_timeout</literal> variable</primary> + </indexterm> + + <indexterm type="concept"> + <primary>timeout</primary> + <secondary><literal>connect_timeout</literal> variable</secondary> + </indexterm> + <literal>connect_timeout</literal> </para> @@ -3816,6 +3670,15 @@ <listitem> <para> + <indexterm type="concept"> + <primary><literal>shutdown_timeout</literal> variable</primary> + </indexterm> + + <indexterm type="concept"> + <primary>timeout</primary> + <secondary><literal>shutdown_timeout</literal> variable</secondary> + </indexterm> + <literal>shutdown_timeout</literal> </para> @@ -4200,14 +4063,14 @@ options: </para> - <indexterm type="concept"> - <primary><literal>open_files_limit</literal> variable</primary> - </indexterm> - <itemizedlist> <listitem> <para> + <indexterm type="concept"> + <primary><literal>open_files_limit</literal> variable</primary> + </indexterm> + <literal>open_files_limit</literal> </para>
| Thread | ||
|---|---|---|
| • bk commit - mysqldoc@docsrva tree (paul:1.3213) | paul | 9 Aug |
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Page generated in 1.751 sec. using MySQL 5.1.14-beta-log