Author: paul
Date: 2006-02-08 19:22:28 +0100 (Wed, 08 Feb 2006)
New Revision: 1245
Log:
r7233@frost: paul | 2006-02-08 12:12:37 -0600
Add mysqldump options.
Modified:
trunk/
trunk/refman-4.1/client-utility-programs.xml
trunk/refman-5.0/client-utility-programs.xml
trunk/refman-5.1/client-utility-programs.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:7232
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2927
+ b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:7233
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2927
Modified: trunk/refman-4.1/client-utility-programs.xml
===================================================================
--- trunk/refman-4.1/client-utility-programs.xml 2006-02-08 18:22:13 UTC (rev 1244)
+++ trunk/refman-4.1/client-utility-programs.xml 2006-02-08 18:22:28 UTC (rev 1245)
@@ -7138,21 +7138,31 @@
<listitem>
<para>
- <option>--comments[={0|1}]</option>
+ <option>--character-sets-dir=<replaceable>path</replaceable></option>
</para>
<para>
- If set to <literal>0</literal>, suppresses additional
- information in the dump file such as program version,
- server version, and host. <option>--skip-comments</option>
- has the same effect as <option>--comments=0</option>. The
- default value is <literal>1</literal>, which includes the
- extra information. Added in MySQL 4.0.17.
+ The directory where character sets are installed. See
+ <xref linkend="character-sets"/>.
</para>
</listitem>
<listitem>
<para>
+ <option>--comments</option>, <option>-i</option>
+ </para>
+
+ <para>
+ Write additional information in the dump file such as
+ program version, server version, and host. . This option
+ is enabled by default. To suppress additional, use
+ <option>--skip-comments</option>. This option was added in
+ MySQL 4.0.17.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<option>--compact</option>
</para>
@@ -7435,6 +7445,31 @@
<listitem>
<para>
+ <option>--ignore-table=<replaceable>db_name.tbl_name</replaceable></option>
+ </para>
+
+ <para>
+ Do not dump the given table, which must be specified using
+ both the database and table names. To ignore multiple
+ tables, use this option multiple times. This option was
+ added in MySQL 4.1.9.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <option>--insert-ignore</option>
+ </para>
+
+ <para>
+ Write <literal>INSERT</literal> statements with the
+ <literal>IGNORE</literal> option. This option was added in
+ MySQL 4.1.12.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<option>--lock-all-tables</option>, <option>-x</option>
</para>
@@ -7511,6 +7546,18 @@
<listitem>
<para>
+ <option>--no-autocommit</option>
+ </para>
+
+ <para>
+ Enclose the <literal>INSERT</literal> statements for each
+ dumped table within <literal>SET AUTOCOMMIT=0</literal>
+ and <literal>COMMIT</literal> statements.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<option>--no-create-db</option>, <option>-n</option>
</para>
@@ -7572,6 +7619,21 @@
<listitem>
<para>
+ <option>--order-by-primary</option>
+ </para>
+
+ <para>
+ Sorts each table's rows by its primary key, or its first
+ unique index, if such an index exists. This is useful when
+ dumping a <literal>MyISAM</literal> table to be loaded
+ into an <literal>InnoDB</literal> table, but will make the
+ dump itself take considerably longer. This option was
+ added in MySQL 4.1.8.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<option>--password[=<replaceable>password</replaceable>]</option>,
<option>-p[<replaceable>password</replaceable>]</option>
</para>
Modified: trunk/refman-5.0/client-utility-programs.xml
===================================================================
--- trunk/refman-5.0/client-utility-programs.xml 2006-02-08 18:22:13 UTC (rev 1244)
+++ trunk/refman-5.0/client-utility-programs.xml 2006-02-08 18:22:28 UTC (rev 1245)
@@ -7250,21 +7250,30 @@
<listitem>
<para>
- <option>--comments[={0|1}]</option>
+ <option>--character-sets-dir=<replaceable>path</replaceable></option>
</para>
<para>
- If set to <literal>0</literal>, suppresses additional
- information in the dump file such as program version,
- server version, and host. <option>--skip-comments</option>
- has the same effect as <option>--comments=0</option>. The
- default value is <literal>1</literal>, which includes the
- extra information.
+ The directory where character sets are installed. See
+ <xref linkend="character-sets"/>.
</para>
</listitem>
<listitem>
<para>
+ <option>--comments</option>, <option>-i</option>
+ </para>
+
+ <para>
+ Write additional information in the dump file such as
+ program version, server version, and host. . This option
+ is enabled by default. To suppress additional, use
+ <option>--skip-comments</option>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<option>--compact</option>
</para>
@@ -7532,6 +7541,29 @@
<listitem>
<para>
+ <option>--ignore-table=<replaceable>db_name.tbl_name</replaceable></option>
+ </para>
+
+ <para>
+ Do not dump the given table, which must be specified using
+ both the database and table names. To ignore multiple
+ tables, use this option multiple times.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <option>--insert-ignore</option>
+ </para>
+
+ <para>
+ Write <literal>INSERT</literal> statements with the
+ <literal>IGNORE</literal> option.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<option>--lock-all-tables</option>, <option>-x</option>
</para>
@@ -7606,6 +7638,18 @@
<listitem>
<para>
+ <option>--no-autocommit</option>
+ </para>
+
+ <para>
+ Enclose the <literal>INSERT</literal> statements for each
+ dumped table within <literal>SET AUTOCOMMIT=0</literal>
+ and <literal>COMMIT</literal> statements.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<option>--no-create-db</option>, <option>-n</option>
</para>
@@ -7666,6 +7710,20 @@
<listitem>
<para>
+ <option>--order-by-primary</option>
+ </para>
+
+ <para>
+ Sorts each table's rows by its primary key, or its first
+ unique index, if such an index exists. This is useful when
+ dumping a <literal>MyISAM</literal> table to be loaded
+ into an <literal>InnoDB</literal> table, but will make the
+ dump itself take considerably longer.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<option>--password[=<replaceable>password</replaceable>]</option>,
<option>-p[<replaceable>password</replaceable>]</option>
</para>
Modified: trunk/refman-5.1/client-utility-programs.xml
===================================================================
--- trunk/refman-5.1/client-utility-programs.xml 2006-02-08 18:22:13 UTC (rev 1244)
+++ trunk/refman-5.1/client-utility-programs.xml 2006-02-08 18:22:28 UTC (rev 1245)
@@ -7294,21 +7294,30 @@
<listitem>
<para>
- <option>--comments[={0|1}]</option>
+ <option>--character-sets-dir=<replaceable>path</replaceable></option>
</para>
<para>
- If set to <literal>0</literal>, suppresses additional
- information in the dump file such as program version,
- server version, and host. <option>--skip-comments</option>
- has the same effect as <option>--comments=0</option>. The
- default value is <literal>1</literal>, which includes the
- extra information.
+ The directory where character sets are installed. See
+ <xref linkend="character-sets"/>.
</para>
</listitem>
<listitem>
<para>
+ <option>--comments</option>, <option>-i</option>
+ </para>
+
+ <para>
+ Write additional information in the dump file such as
+ program version, server version, and host. . This option
+ is enabled by default. To suppress additional, use
+ <option>--skip-comments</option>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<option>--compact</option>
</para>
@@ -7575,6 +7584,29 @@
<listitem>
<para>
+ <option>--ignore-table=<replaceable>db_name.tbl_name</replaceable></option>
+ </para>
+
+ <para>
+ Do not dump the given table, which must be specified using
+ both the database and table names. To ignore multiple
+ tables, use this option multiple times.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <option>--insert-ignore</option>
+ </para>
+
+ <para>
+ Write <literal>INSERT</literal> statements with the
+ <literal>IGNORE</literal> option.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<option>--lock-all-tables</option>, <option>-x</option>
</para>
@@ -7649,6 +7681,18 @@
<listitem>
<para>
+ <option>--no-autocommit</option>
+ </para>
+
+ <para>
+ Enclose the <literal>INSERT</literal> statements for each
+ dumped table within <literal>SET AUTOCOMMIT=0</literal>
+ and <literal>COMMIT</literal> statements.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<option>--no-create-db</option>, <option>-n</option>
</para>
@@ -7709,6 +7753,20 @@
<listitem>
<para>
+ <option>--order-by-primary</option>
+ </para>
+
+ <para>
+ Sorts each table's rows by its primary key, or its first
+ unique index, if such an index exists. This is useful when
+ dumping a <literal>MyISAM</literal> table to be loaded
+ into an <literal>InnoDB</literal> table, but will make the
+ dump itself take considerably longer.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<option>--password[=<replaceable>password</replaceable>]</option>,
<option>-p[<replaceable>password</replaceable>]</option>
</para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r1245 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 8 Feb |
