Author: plavin
Date: 2007-07-24 17:38:13 +0200 (Tue, 24 Jul 2007)
New Revision: 7188
Log:
Document bug# 28524, skip-add-drop-table
Modified:
trunk/refman-5.0/client-utility-programs.xml
trunk/refman-5.0/releasenotes-es-5.0.xml
trunk/refman-5.1/client-utility-programs.xml
trunk/refman-5.1/news-5.1.xml
Modified: trunk/refman-5.0/client-utility-programs.xml
===================================================================
--- trunk/refman-5.0/client-utility-programs.xml 2007-07-23 20:35:20 UTC (rev 7187)
+++ trunk/refman-5.0/client-utility-programs.xml 2007-07-24 15:38:13 UTC (rev 7188)
Changed blocks: 1, Lines Added: 9, Lines Deleted: 0; 1036 bytes
@@ -10651,6 +10651,15 @@
<option>--skip-disable-keys</option>, and
<option>--skip-add-locks</option> options.
</para>
+
+ <para>
+ <emphasis>Note</emphasis>: Prior to release 5.0.48,
+ this option did not create valid SQL if the database dump contained
+ views. The recreation of views requires the creation and removal of temporary tables
+ and this option suppressed the removal of those temporary tables. As a workaround
+ use <option>--compress</option> with the <option>--add-drop-table</option>
+ option and then manually adjust the dump file.
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-5.0/releasenotes-es-5.0.xml
===================================================================
--- trunk/refman-5.0/releasenotes-es-5.0.xml 2007-07-23 20:35:20 UTC (rev 7187)
+++ trunk/refman-5.0/releasenotes-es-5.0.xml 2007-07-24 15:38:13 UTC (rev 7188)
Changed blocks: 1, Lines Added: 13, Lines Deleted: 1; 1121 bytes
@@ -80,9 +80,21 @@
</remark>
<itemizedlist>
-
+
<listitem>
<para>
+ Using the <option>--skip-add-drop-table </option>option
+ with <command>mysqldump</command> generated incorrect
+ SQL if the database included any views. The recreation of views
+ requires the creation and removal of temporary tables. This option
+ suppressed the removal of those temporary tables. The same applied
+ to <option>--compact</option> since this option also
+ invokes <option>--skip-add-drop-table</option>. (Bug #28524)
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<literal>NDB Cluster</literal>: The output from
<command>ndb_config</command>
<option>--config-file=<replaceable>file</replaceable></option>
Modified: trunk/refman-5.1/client-utility-programs.xml
===================================================================
--- trunk/refman-5.1/client-utility-programs.xml 2007-07-23 20:35:20 UTC (rev 7187)
+++ trunk/refman-5.1/client-utility-programs.xml 2007-07-24 15:38:13 UTC (rev 7188)
Changed blocks: 1, Lines Added: 9, Lines Deleted: 0; 1044 bytes
@@ -10840,6 +10840,15 @@
<option>--skip-disable-keys</option>, and
<option>--skip-add-locks</option> options.
</para>
+
+ <para>
+ <emphasis>Note</emphasis>: Prior to release 5.1.21,
+ this option did not create valid SQL if the database dump contained
+ views. The recreation of views requires the creation and removal of temporary tables
+ and this option suppressed the removal of those temporary tables. As a workaround
+ use <option>--compress</option> with the <option>--add-drop-table</option>
+ option and then manually adjust the dump file.
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-5.1/news-5.1.xml
===================================================================
--- trunk/refman-5.1/news-5.1.xml 2007-07-23 20:35:20 UTC (rev 7187)
+++ trunk/refman-5.1/news-5.1.xml 2007-07-24 15:38:13 UTC (rev 7188)
Changed blocks: 1, Lines Added: 12, Lines Deleted: 0; 907 bytes
@@ -80,6 +80,18 @@
</remark>
<itemizedlist>
+
+ <listitem>
+ <para>
+ Using the <option>--skip-add-drop-table </option>option
+ with <command>mysqldump</command> generated incorrect
+ SQL if the database included any views. The recreation of views
+ requires the creation and removal of temporary tables. This option
+ suppressed the removal of those temporary tables. The same applied
+ to <option>--compact</option> since this option also
+ invokes <option>--skip-add-drop-table</option>. (Bug #28524)
+ </para>
+ </listitem>
<listitem>
<para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r7188 - in trunk: refman-5.0 refman-5.1 | plavin | 24 Jul |
