Author: plavin
Date: 2007-04-02 16:53:44 +0200 (Mon, 02 Apr 2007)
New Revision: 5686
Log:
Add more mysqldump functions
Modified:
trunk/dynamic-docs/command-optvars/mysqldump.xml
Modified: trunk/dynamic-docs/command-optvars/mysqldump.xml
===================================================================
--- trunk/dynamic-docs/command-optvars/mysqldump.xml 2007-04-02 14:37:01 UTC (rev 5685)
+++ trunk/dynamic-docs/command-optvars/mysqldump.xml 2007-04-02 14:53:44 UTC (rev 5686)
Changed blocks: 6, Lines Added: 70, Lines Deleted: 48; 7842 bytes
@@ -661,14 +661,15 @@
<manual version="5.1"/>
</versions>
</option>
- <option command="mysqldump" section="server" id="">
- <xrefto id="option_mysqldump_"/>
- <name></name>
+ <option command="mysqldump" section="server" id="hex-blob">
+ <xrefto id="option_mysqldump_hex-blob"/>
+ <name>hex-blob</name>
<shortdescription lang="en">
-
+ Dump binary columns using hexadecimal notation
+ (for example, 'abc' becomes 0x616263)
</shortdescription>
<types>
- <optype class="cmdline" format="--"/>
+ <optype class="cmdline" format="--hex-blob"/>
<optype class="mycnf"/>
</types>
<versions>
@@ -677,30 +678,31 @@
<manual version="5.1"/>
</versions>
</option>
- <option command="mysqldump" section="server" id="">
- <xrefto id="option_mysqldump_"/>
- <name></name>
+ <option command="mysqldump" section="server" id="ignore-table">
+ <xrefto id="option_mysqldump_ignore-table"/>
+ <name>ignore-table</name>
<shortdescription lang="en">
-
+ Do not dump the given table
</shortdescription>
<types>
- <optype class="cmdline" format="--"/>
+ <optype class="cmdline" format="--ignore-table=db_name.tbl_name"/>
<optype class="mycnf"/>
- </types>
+ </types>
+ <values vartype="string" platform="all"/>
<versions>
<manual version="4.1"/>
<manual version="5.0"/>
<manual version="5.1"/>
</versions>
</option>
- <option command="mysqldump" section="server" id="">
- <xrefto id="option_mysqldump_"/>
- <name></name>
+ <option command="mysqldump" section="server" id="insert-ignore">
+ <xrefto id="option_mysqldump_insert-ignore"/>
+ <name>insert-ignore</name>
<shortdescription lang="en">
-
+ Write INSERT statements with the IGNORE option
</shortdescription>
<types>
- <optype class="cmdline" format="--"/>
+ <optype class="cmdline" format="--insert-ignore"/>
<optype class="mycnf"/>
</types>
<versions>
@@ -709,30 +711,36 @@
<manual version="5.1"/>
</versions>
</option>
- <option command="mysqldump" section="server" id="">
- <xrefto id="option_mysqldump_"/>
- <name></name>
+ <option command="mysqldump" section="server" id="lines-terminated-by">
+ <xrefto id="option_mysqldump_lines-terminated-by"/>
+ <name>lines-terminated-by</name>
<shortdescription lang="en">
-
+ This option is used with the -T option and has the same meaning
+ as the corresponding clause for LOAD DATA INFILE
</shortdescription>
+ <seealso xref="tab"/>
<types>
- <optype class="cmdline" format="--"/>
+ <optype class="cmdline" format="--lines-terminated-by=string"/>
<optype class="mycnf"/>
- </types>
+ </types>
+ <values vartype="string" platform="all"/>
<versions>
<manual version="4.1"/>
<manual version="5.0"/>
<manual version="5.1"/>
</versions>
</option>
- <option command="mysqldump" section="server" id="">
- <xrefto id="option_mysqldump_"/>
- <name></name>
+ <option command="mysqldump" section="server" id="lock-all-tables">
+ <xrefto id="option_mysqldump_lock-all-tables"/>
+ <name>lock-all-tables</name>
<shortdescription lang="en">
-
+ Lock all tables across all databases
</shortdescription>
+ <seealso xref="single-transaction"/>
+ <seealso xref="lock-tables"/>
<types>
- <optype class="cmdline" format="--"/>
+ <optype class="cmdline" format="--lock-all-tables"/>
+ <optype class="cmdline" format="-x"/>
<optype class="mycnf"/>
</types>
<versions>
@@ -741,14 +749,16 @@
<manual version="5.1"/>
</versions>
</option>
- <option command="mysqldump" section="server" id="">
- <xrefto id="option_mysqldump_"/>
- <name></name>
+ <option command="mysqldump" section="server" id="lock-tables">
+ <xrefto id="option_mysqldump_lock-tables"/>
+ <name>lock-tables</name>
<shortdescription lang="en">
-
+ Lock all tables before dumping them
</shortdescription>
+ <seealso xref="lock-all-tables"/>
+ <seealso xref="single-transaction"/>
<types>
- <optype class="cmdline" format="--"/>
+ <optype class="cmdline" format="--lock-tables"/>
<optype class="mycnf"/>
</types>
<versions>
@@ -757,30 +767,39 @@
<manual version="5.1"/>
</versions>
</option>
- <option command="mysqldump" section="server" id="">
- <xrefto id="option_mysqldump_"/>
- <name></name>
+ <option command="mysqldump" section="replication" id="master-data">
+ <xrefto id="option_mysqldump_master-data"/>
+ <name>master-data</name>
<shortdescription lang="en">
-
+ Write the binary log filename and position to the output
</shortdescription>
+ <seealso xref="lock-all-tables"/>
+ <seealso xref="single-transaction"/>
+ <seealso xref="lock-tables"/>
<types>
- <optype class="cmdline" format="--"/>
+ <optype class="cmdline" format="--master-data[=value]"/>
<optype class="mycnf"/>
- </types>
+ </types>
+ <values vartype="numeric" platform="all">
+ <choice value="1"/>
+ <choice value="2"/>
+ <value default="2"/>
+ </values>
<versions>
<manual version="4.1"/>
<manual version="5.0"/>
<manual version="5.1"/>
</versions>
</option>
- <option command="mysqldump" section="server" id="">
- <xrefto id="option_mysqldump_"/>
- <name></name>
+ <option command="mysqldump" section="server" id="no-autocommit">
+ <xrefto id="option_mysqldump_no-autocommit"/>
+ <name>no-autocommit</name>
<shortdescription lang="en">
-
+ Enclose the INSERT statements for each dumped
+ table within SET AUTOCOMMIT=0 and COMMIT statements
</shortdescription>
<types>
- <optype class="cmdline" format="--"/>
+ <optype class="cmdline" format="--no-autocommit"/>
<optype class="mycnf"/>
</types>
<versions>
@@ -789,14 +808,17 @@
<manual version="5.1"/>
</versions>
</option>
- <option command="mysqldump" section="server" id="">
- <xrefto id="option_mysqldump_"/>
- <name></name>
+ <option command="mysqldump" section="server" id="no-create-db">
+ <xrefto id="option_mysqldump_no-create-db"/>
+ <name>no-create-db</name>
<shortdescription lang="en">
-
+ This option suppresses the CREATE DATABASE statements
</shortdescription>
+ <seealso xref="all-databases"/>
+ <seealso xref="databases"/>
<types>
- <optype class="cmdline" format="--"/>
+ <optype class="cmdline" format="--no-create-db"/>
+ <optype class="cmdline" format="-n"/>
<optype class="mycnf"/>
</types>
<versions>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r5686 - trunk/dynamic-docs/command-optvars | plavin | 2 Apr |
