Author: paul
Date: 2007-03-28 18:38:03 +0200 (Wed, 28 Mar 2007)
New Revision: 5605
Log:
r18296@frost: paul | 2007-03-28 11:33:09 -0500
Add section/manpage for mysql_tableinfo.
Modified:
trunk/refman-4.1/client-utility-programs.xml
trunk/refman-5.0/client-utility-programs.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:22369
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:18282
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:14593
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:22369
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:18296
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:14593
Modified: trunk/refman-4.1/client-utility-programs.xml
===================================================================
--- trunk/refman-4.1/client-utility-programs.xml 2007-03-28 16:00:49 UTC (rev 5604)
+++ trunk/refman-4.1/client-utility-programs.xml 2007-03-28 16:38:03 UTC (rev 5605)
Changed blocks: 2, Lines Added: 410, Lines Deleted: 0; 13255 bytes
@@ -373,6 +373,21 @@
<listitem>
<para>
<indexterm>
+ <primary>mysql_tableinfo</primary>
+ </indexterm>
+
+ <command>mysql_tableinfo</command>
+ </para>
+
+ <para>
+ A utility that generates database metadata.
+ <xref linkend="mysql-tableinfo"/>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
<primary>mysql_waitpid</primary>
</indexterm>
@@ -14215,6 +14230,401 @@
</section>
+ <section id="fake-id-for-mysql-tableinfo-manpage-section-wrapper">
+
+ <title>fake title for mysql_tableinfo manpage section wrapper</title>
+
+ <refentry id="mysql-tableinfo">
+
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ </indexterm>
+
+ <refmeta>
+ <refentrytitle><command>mysql_tableinfo</command></refentrytitle>
+
+ <manvolnum>1</manvolnum>
+ <refmiscinfo class="manual">MySQL Database System</refmiscinfo>
+ <refmiscinfo class="source">MySQL</refmiscinfo>
+ <refmiscinfo class="version">¤t-series;</refmiscinfo>
+ <refmiscinfo class="refman">Generate Database Metadata</refmiscinfo>
+ </refmeta>
+
+ <refnamediv>
+ <refname>mysql_tableinfo</refname>
+
+ <refpurpose>generate database metadata</refpurpose>
+ </refnamediv>
+
+ <refsynopsisdiv>
+ <cmdsynopsis>
+ <command>mysql_tableinfo [<replaceable>options</replaceable>] <replaceable>db_name</replaceable> [<replaceable>db_like</replaceable> [<replaceable>tbl_like</replaceable>]]</command>
+ </cmdsynopsis>
+ </refsynopsisdiv>
+
+ <refsection id="mysql-tableinfo-description">
+
+ <title>Description</title>
+
+ <para>
+ <command>mysql_tableinfo</command> creates tables and
+ populates them with database metadata. It uses <literal>SHOW
+ DATABASES</literal>, <literal>SHOW TABLES</literal>,
+ <literal>SHOW TABLE STATUS</literal>, <literal>SHOW
+ COLUMNS</literal>, and <literal>SHOW INDEX</literal> to obtain
+ the metadata.
+ </para>
+
+ <para>
+ In MySQL 5.0 and up, the <literal>INFORMATION_SCHEMA</literal>
+ database contains the same kind of information in the
+ <literal>SCHEMATA</literal>, <literal>TABLES</literal>,
+ <literal>COLUMNS</literal>, and <literal>STATISTICS</literal>
+ tables. See <xref linkend="information-schema"/>.
+ </para>
+
+ <para>
+ Invoke <command>mysql_tableinfo</command> like this:
+ </para>
+
+<programlisting>
+shell> <userinput>mysql_tableinfo [<replaceable>options</replaceable>] <replaceable>db_name</replaceable> [<replaceable>db_like</replaceable> [<replaceable>tbl_like</replaceable>]]</userinput>
+</programlisting>
+
+ <para>
+ The <replaceable>db_name</replaceable> argument indicates
+ which database <command>mysql_tableinfo</command> should use
+ as the location for the metadata tables. The database will be
+ created if it does not exist. The tables will be named
+ <literal>db</literal>, <literal>tbl</literal> (or
+ <literal>tbl_status</literal>), <literal>col</literal>, and
+ <literal>idx</literal>.
+ </para>
+
+ <para>
+ If the <replaceable>db_like</replaceable> or
+ <replaceable>tbl_like</replaceable> arguments are given, they
+ are used as patterns and metadata is generated only for
+ databases or tables that match the patterns. These arguments
+ default to <literal>%</literal> if not given.
+ </para>
+
+ <para>
+ Examples:
+ </para>
+
+<programlisting>
+mysql_tableinfo info
+mysql_tableinfo info world
+mysql_tableinfo info mydb tmp%
+</programlisting>
+
+ <para>
+ Each of the commands stores information into tables in the
+ <literal>info</literal> database. The first stores information
+ for all databases and tables. The second stores information
+ for all tables in the <literal>world</literal> database. The
+ third stores information for tables in the
+ <literal>mydb</literal> database that have names matching the
+ pattern <literal>tmp%</literal>.
+ </para>
+
+ <para>
+ <command>mysql_tableinfo</command> supports the following
+ options:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>help option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>help option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--help</option>
+ </para>
+
+ <para>
+ Display a help message and exit.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>clear option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>clear option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--clear</option>
+ </para>
+
+ <para>
+ Before populating each metadata table, drop it if it
+ exists.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>clear-only option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>clear-only option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--clear-only</option>
+ </para>
+
+ <para>
+ Similar to <option>--clear</option>, but exits after
+ dropping the metadata tables to be populated.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>col option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>col option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--col</option>
+ </para>
+
+ <para>
+ Generate column metadata into the <literal>col</literal>
+ table.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>host option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>host option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--host=<replaceable>host_name</replaceable></option>,
+ <option>-h <replaceable>host_name</replaceable></option>
+ </para>
+
+ <para>
+ Connect to the MySQL server on the given host.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>idx option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>idx option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--idx</option>
+ </para>
+
+ <para>
+ Generate index metadata into the <literal>idx</literal>
+ table.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>password option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>password option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--password=<replaceable>password</replaceable></option>,
+ <option>-p<replaceable>password</replaceable></option>
+ </para>
+
+ <para>
+ The password to use when connecting to the server. Note
+ that the password value is not optional for this option,
+ unlike for other MySQL programs. You can use an option
+ file to avoid giving the password on the command line.
+ </para>
+
+ <para>
+ Specifying a password on the command line should be
+ considered insecure. See
+ <xref linkend="password-security"/>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>port option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>port option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--port=<replaceable>port_num</replaceable></option>,
+ <option>-P <replaceable>port_num</replaceable></option>
+ </para>
+
+ <para>
+ The TCP/IP port number to use for the connection.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>prefix option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>prefix option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--prefix=<replaceable>prefix_str</replaceable></option>
+ </para>
+
+ <para>
+ Add <replaceable>prefix_str</replaceable> at the beginning
+ of each metadata table name.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>quiet option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>quiet option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--quiet</option>, <option>-q</option>
+ </para>
+
+ <para>
+ Be silent except for errors.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>socket option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>socket option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--socket=<replaceable>path</replaceable></option>,
+ <option>-S <replaceable>path</replaceable></option>
+ </para>
+
+ <para>
+ The Unix socket file to use for the connection.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>tbl-status option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>tbl-status option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--tbl-status</option>
+ </para>
+
+ <para>
+ Use <literal>SHOW TABLE STATUS</literal> instead of
+ <literal>SHOW TABLES</literal>. This provides more
+ complete information, but is slower.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>user option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>user option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--user=<replaceable>user_name</replaceable></option>,
+ <option>-u <replaceable>user_name</replaceable></option>
+ </para>
+
+ <para>
+ The MySQL username to use when connecting to the server.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ </refsection>
+
+ </refentry>
+
+ </section>
+
<section id="fake-id-for-mysql-waitpid-manpage-section-wrapper">
<title>fake title for mysql_waitpid manpage section wrapper</title>
Modified: trunk/refman-5.0/client-utility-programs.xml
===================================================================
--- trunk/refman-5.0/client-utility-programs.xml 2007-03-28 16:00:49 UTC (rev 5604)
+++ trunk/refman-5.0/client-utility-programs.xml 2007-03-28 16:38:03 UTC (rev 5605)
Changed blocks: 4, Lines Added: 422, Lines Deleted: 12; 15412 bytes
@@ -374,6 +374,21 @@
<listitem>
<para>
<indexterm>
+ <primary>mysql_tableinfo</primary>
+ </indexterm>
+
+ <command>mysql_tableinfo</command>
+ </para>
+
+ <para>
+ A utility that generates database metadata.
+ <xref linkend="mysql-tableinfo"/>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
<primary>mysql_waitpid</primary>
</indexterm>
@@ -1346,7 +1361,7 @@
<command>myisamchk</command>, see
<xref linkend="myisamchk-memory"/>.
</para>
-
+
<important>
<para>
<emphasis>You must ensure that no other program is using the
@@ -1356,38 +1371,38 @@
running <command>myisamchk</command>, or to lock all tables
that <command>myisamchk</command> is being used on.
</para>
-
+
<para>
Otherwise, when you run <command>myisamchk</command>, it may
- display the following error message:
+ display the following error message:
</para>
-
+
<programlisting>
warning: clients are using or haven't closed the table properly
</programlisting>
-
+
<para>
- This means that you are trying to check a table that has been
- updated by another program (such as the
+ This means that you are trying to check a table that has
+ been updated by another program (such as the
<command>mysqld</command> server) that hasn't yet closed the
file or that has died without closing the file properly,
which can sometimes lead to the corruption of one or more
<literal>MyISAM</literal> tables.
</para>
-
+
<para>
If <command>mysqld</command> is running, you must force it
to flush any table modifications that are still buffered in
memory by using <literal>FLUSH TABLES</literal>. You should
then ensure that no one is using the tables while you are
- running <command>myisamchk</command>
+ running <command>myisamchk</command>
</para>
-
+
<para>
However, the easiest way to avoid this problem is to use
<literal>CHECK TABLE</literal> instead of
- <command>myisamchk</command> to check tables. See
- <xref linkend="check-table"/>.
+ <command>myisamchk</command> to check tables. See
+ <xref linkend="check-table"/>.
</para>
</important>
@@ -14684,6 +14699,401 @@
</section>
+ <section id="fake-id-for-mysql-tableinfo-manpage-section-wrapper">
+
+ <title>fake title for mysql_tableinfo manpage section wrapper</title>
+
+ <refentry id="mysql-tableinfo">
+
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ </indexterm>
+
+ <refmeta>
+ <refentrytitle><command>mysql_tableinfo</command></refentrytitle>
+
+ <manvolnum>1</manvolnum>
+ <refmiscinfo class="manual">MySQL Database System</refmiscinfo>
+ <refmiscinfo class="source">MySQL</refmiscinfo>
+ <refmiscinfo class="version">¤t-series;</refmiscinfo>
+ <refmiscinfo class="refman">Generate Database Metadata</refmiscinfo>
+ </refmeta>
+
+ <refnamediv>
+ <refname>mysql_tableinfo</refname>
+
+ <refpurpose>generate database metadata</refpurpose>
+ </refnamediv>
+
+ <refsynopsisdiv>
+ <cmdsynopsis>
+ <command>mysql_tableinfo [<replaceable>options</replaceable>] <replaceable>db_name</replaceable> [<replaceable>db_like</replaceable> [<replaceable>tbl_like</replaceable>]]</command>
+ </cmdsynopsis>
+ </refsynopsisdiv>
+
+ <refsection id="mysql-tableinfo-description">
+
+ <title>Description</title>
+
+ <para>
+ <command>mysql_tableinfo</command> creates tables and
+ populates them with database metadata. It uses <literal>SHOW
+ DATABASES</literal>, <literal>SHOW TABLES</literal>,
+ <literal>SHOW TABLE STATUS</literal>, <literal>SHOW
+ COLUMNS</literal>, and <literal>SHOW INDEX</literal> to obtain
+ the metadata.
+ </para>
+
+ <para>
+ In MySQL 5.0 and up, the <literal>INFORMATION_SCHEMA</literal>
+ database contains the same kind of information in the
+ <literal>SCHEMATA</literal>, <literal>TABLES</literal>,
+ <literal>COLUMNS</literal>, and <literal>STATISTICS</literal>
+ tables. See <xref linkend="information-schema"/>.
+ </para>
+
+ <para>
+ Invoke <command>mysql_tableinfo</command> like this:
+ </para>
+
+<programlisting>
+shell> <userinput>mysql_tableinfo [<replaceable>options</replaceable>] <replaceable>db_name</replaceable> [<replaceable>db_like</replaceable> [<replaceable>tbl_like</replaceable>]]</userinput>
+</programlisting>
+
+ <para>
+ The <replaceable>db_name</replaceable> argument indicates
+ which database <command>mysql_tableinfo</command> should use
+ as the location for the metadata tables. The database will be
+ created if it does not exist. The tables will be named
+ <literal>db</literal>, <literal>tbl</literal> (or
+ <literal>tbl_status</literal>), <literal>col</literal>, and
+ <literal>idx</literal>.
+ </para>
+
+ <para>
+ If the <replaceable>db_like</replaceable> or
+ <replaceable>tbl_like</replaceable> arguments are given, they
+ are used as patterns and metadata is generated only for
+ databases or tables that match the patterns. These arguments
+ default to <literal>%</literal> if not given.
+ </para>
+
+ <para>
+ Examples:
+ </para>
+
+<programlisting>
+mysql_tableinfo info
+mysql_tableinfo info world
+mysql_tableinfo info mydb tmp%
+</programlisting>
+
+ <para>
+ Each of the commands stores information into tables in the
+ <literal>info</literal> database. The first stores information
+ for all databases and tables. The second stores information
+ for all tables in the <literal>world</literal> database. The
+ third stores information for tables in the
+ <literal>mydb</literal> database that have names matching the
+ pattern <literal>tmp%</literal>.
+ </para>
+
+ <para>
+ <command>mysql_tableinfo</command> supports the following
+ options:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>help option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>help option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--help</option>
+ </para>
+
+ <para>
+ Display a help message and exit.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>clear option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>clear option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--clear</option>
+ </para>
+
+ <para>
+ Before populating each metadata table, drop it if it
+ exists.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>clear-only option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>clear-only option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--clear-only</option>
+ </para>
+
+ <para>
+ Similar to <option>--clear</option>, but exits after
+ dropping the metadata tables to be populated.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>col option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>col option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--col</option>
+ </para>
+
+ <para>
+ Generate column metadata into the <literal>col</literal>
+ table.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>host option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>host option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--host=<replaceable>host_name</replaceable></option>,
+ <option>-h <replaceable>host_name</replaceable></option>
+ </para>
+
+ <para>
+ Connect to the MySQL server on the given host.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>idx option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>idx option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--idx</option>
+ </para>
+
+ <para>
+ Generate index metadata into the <literal>idx</literal>
+ table.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>password option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>password option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--password=<replaceable>password</replaceable></option>,
+ <option>-p<replaceable>password</replaceable></option>
+ </para>
+
+ <para>
+ The password to use when connecting to the server. Note
+ that the password value is not optional for this option,
+ unlike for other MySQL programs. You can use an option
+ file to avoid giving the password on the command line.
+ </para>
+
+ <para>
+ Specifying a password on the command line should be
+ considered insecure. See
+ <xref linkend="password-security"/>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>port option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>port option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--port=<replaceable>port_num</replaceable></option>,
+ <option>-P <replaceable>port_num</replaceable></option>
+ </para>
+
+ <para>
+ The TCP/IP port number to use for the connection.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>prefix option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>prefix option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--prefix=<replaceable>prefix_str</replaceable></option>
+ </para>
+
+ <para>
+ Add <replaceable>prefix_str</replaceable> at the beginning
+ of each metadata table name.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>quiet option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>quiet option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--quiet</option>, <option>-q</option>
+ </para>
+
+ <para>
+ Be silent except for errors.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>socket option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>socket option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--socket=<replaceable>path</replaceable></option>,
+ <option>-S <replaceable>path</replaceable></option>
+ </para>
+
+ <para>
+ The Unix socket file to use for the connection.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>tbl-status option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>tbl-status option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--tbl-status</option>
+ </para>
+
+ <para>
+ Use <literal>SHOW TABLE STATUS</literal> instead of
+ <literal>SHOW TABLES</literal>. This provides more
+ complete information, but is slower.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysql_tableinfo</primary>
+ <secondary>user option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>user option</primary>
+ <secondary>mysql_tableinfo</secondary>
+ </indexterm>
+
+ <option>--user=<replaceable>user_name</replaceable></option>,
+ <option>-u <replaceable>user_name</replaceable></option>
+ </para>
+
+ <para>
+ The MySQL username to use when connecting to the server.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ </refsection>
+
+ </refentry>
+
+ </section>
+
<section id="fake-id-for-mysql-waitpid-manpage-section-wrapper">
<title>fake title for mysql_waitpid manpage section wrapper</title>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r5605 - in trunk: . refman-4.1 refman-5.0 | paul | 28 Mar |
