List:Commits« Previous MessageNext Message »
From:jon.stephens Date:September 10 2010 9:04am
Subject:svn commit - mysqldoc@docsrva: r22667 - in trunk: dynamic-docs/changelog dynamic-docs/command-optvars refman-5.1
View as plain text  
Author: jstephens
Date: 2010-09-10 11:04:21 +0200 (Fri, 10 Sep 2010)
New Revision: 22667

Log:

Documented fix for Cluster BUG#56691 (ref. BUG#34325)

--add-drop-trigger option for mysqldump (backport from 5.6)



Modified:
   trunk/dynamic-docs/changelog/mysqld-2.xml
   trunk/dynamic-docs/command-optvars/mysqldump.xml
   trunk/refman-5.1/mysql-cluster-overview.xml
   trunk/refman-5.1/programs-client-core.xml


Modified: trunk/dynamic-docs/changelog/mysqld-2.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-2.xml	2010-09-10 03:04:53 UTC (rev 22666)
+++ trunk/dynamic-docs/changelog/mysqld-2.xml	2010-09-10 09:04:21 UTC (rev 22667)
Changed blocks: 1, Lines Added: 34, Lines Deleted: 0; 1155 bytes

@@ -6,6 +6,40 @@
 ]>
 <changelog>
 
+  <logentry entrytype="feature">
+
+    <tags>
+      <highlight type="cluster"/>
+      <manual type="mysqldump"/>
+      <manual type="--add-drop-trigger"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="55691"/>
+      <seealsobug bugid="34325"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.1.47-ndb-6.3.38"/>
+      <version ver="5.1.47-ndb-7.0.19"/>
+      <version ver="5.1.47-ndb-7.1.8"/>
+    </versions>
+
+    <message>
+
+      <para>
+        <command>mysqldump</command> as supplied with MySQL Cluster now
+        has an <option role="mysqldump">--add-drop-trigger</option>
+        option which adds a
+        <literal role="stmt" condition="drop-trigger">DROP TRIGGER IF
+        EXISTS</literal> statement before each dumped trigger
+        definition.
+      </para>
+
+    </message>
+
+  </logentry>
+
   <logentry entrytype="bug">
 
     <tags>


Modified: trunk/dynamic-docs/command-optvars/mysqldump.xml
===================================================================
--- trunk/dynamic-docs/command-optvars/mysqldump.xml	2010-09-10 03:04:53 UTC (rev 22666)
+++ trunk/dynamic-docs/command-optvars/mysqldump.xml	2010-09-10 09:04:21 UTC (rev 22667)
Changed blocks: 1, Lines Added: 4, Lines Deleted: 0; 570 bytes

@@ -145,6 +145,10 @@
     </types>
 
     <versions>
+      <manual version="5.1"/>
+      <introduced version="5.1.47-ndb-6.3.38"/>
+      <introduced version="5.1.47-ndb-7.0.19"/>
+      <introduced version="5.1.47-ndb-7.1.8"/>
       <manual version="5.6"/>
     </versions>
 


Modified: trunk/refman-5.1/mysql-cluster-overview.xml
===================================================================
--- trunk/refman-5.1/mysql-cluster-overview.xml	2010-09-10 03:04:53 UTC (rev 22666)
+++ trunk/refman-5.1/mysql-cluster-overview.xml	2010-09-10 09:04:21 UTC (rev 22667)
Changed blocks: 8, Lines Added: 86, Lines Deleted: 31; 6779 bytes

@@ -1322,13 +1322,13 @@
             <xref linkend="mysql-cluster-ndbinfo"/>.
           </para>
         </listitem>
-        
+
         <listitem>
           <formalpara>
-            
+
             <title>New <literal role="stmt">CHANGE MASTER TO</literal> option for circular
               replication</title>
-            
+
             <para>
               Beginning with MySQL Cluster NDB 7.1.0, the
               <literal role="stmt">CHANGE MASTER TO</literal> statement

@@ -1338,11 +1338,11 @@
               to be ignored. (Log rotation and log deletion events are
               preserved.)
             </para>
-            
+
           </formalpara>
-          
+
           <para>
-            See <xref linkend="change-master-to"/>, as well as 
+            See <xref linkend="change-master-to"/>, as well as
             <xref linkend="show-slave-status"/>, for more information.
           </para>
         </listitem>

@@ -1722,6 +1722,24 @@
           </formalpara>
         </listitem>
 
+        <listitem>
+          <formalpara>
+
+            <title><option role="mysqldump">--add-drop-trigger</option> option for
+              <command>mysqldump</command></title>
+
+            <para>
+              Beginning with MySQL Cluster NDB 7.1.8, this option can be
+              used to force all <literal role="stmt">CREATE
+              TRIGGER</literal> statements in
+              <command>mysqldump</command> output to be preceded by a
+              <literal role="stmt" condition="drop-trigger">DROP TRIGGER
+              IF EXISTS</literal> statement.
+            </para>
+
+          </formalpara>
+        </listitem>
+
       </itemizedlist>
 
     </section>

@@ -2286,9 +2304,9 @@
             </para>
 
           </formalpara>
-          
+
           <para>
-            See <xref linkend="change-master-to"/>, as well as 
+            See <xref linkend="change-master-to"/>, as well as
             <xref linkend="show-slave-status"/>, for more information.
           </para>
         </listitem>

@@ -2558,6 +2576,24 @@
           </formalpara>
         </listitem>
 
+        <listitem>
+          <formalpara>
+
+            <title><option role="mysqldump">--add-drop-trigger</option> option for
+              <command>mysqldump</command></title>
+
+            <para>
+              Beginning with MySQL Cluster NDB 7.0.19, this option can
+              be used to force all <literal role="stmt">CREATE
+              TRIGGER</literal> statements in
+              <command>mysqldump</command> output to be preceded by a
+              <literal role="stmt" condition="drop-trigger">DROP TRIGGER
+              IF EXISTS</literal> statement.
+            </para>
+
+          </formalpara>
+        </listitem>
+
       </itemizedlist>
 
     </section>

@@ -3225,27 +3261,28 @@
 
             </formalpara>
           </listitem>
-          
+
           <listitem>
             <formalpara>
-              
+
               <title>New <literal role="stmt">CHANGE MASTER TO</literal> option for circular
                 replication</title>
-              
+
               <para>
                 Beginning with MySQL Cluster NDB 6.3.31, the
-                <literal role="stmt">CHANGE MASTER TO</literal> statement
-                supports an <literal>IGNORE_SERVER_IDS</literal> option
-                which takes a comma-separated list of server IDs and
-                causes events originating from the corresponding servers
-                to be ignored. (Log rotation and log deletion events are
+                <literal role="stmt">CHANGE MASTER TO</literal>
+                statement supports an
+                <literal>IGNORE_SERVER_IDS</literal> option which takes
+                a comma-separated list of server IDs and causes events
+                originating from the corresponding servers to be
+                ignored. (Log rotation and log deletion events are
                 preserved.)
               </para>
-              
+
             </formalpara>
-            
+
             <para>
-              See <xref linkend="change-master-to"/>, as well as 
+              See <xref linkend="change-master-to"/>, as well as
               <xref linkend="show-slave-status"/>, for more information.
             </para>
           </listitem>

@@ -3431,6 +3468,24 @@
             </para>
           </listitem>
 
+          <listitem>
+            <formalpara>
+
+              <title><option role="mysqldump">--add-drop-trigger</option> option for
+                <command>mysqldump</command></title>
+
+              <para>
+                Beginning with MySQL Cluster NDB 6.3.38, this option can
+                be used to force all <literal role="stmt">CREATE
+                TRIGGER</literal> statements in
+                <command>mysqldump</command> output to be preceded by a
+                <literal role="stmt" condition="drop-trigger">DROP
+                TRIGGER IF EXISTS</literal> statement.
+              </para>
+
+            </formalpara>
+          </listitem>
+
         </itemizedlist>
       </para>
 

@@ -3851,28 +3906,28 @@
               added in MySQL Cluster NDB 6.2.19.
             </para>
           </listitem>
-          
-          
+
           <listitem>
             <formalpara>
-              
+
               <title>New <literal role="stmt">CHANGE MASTER TO</literal> option for circular
                 replication</title>
-              
+
               <para>
                 Beginning with MySQL Cluster NDB 6.2.19, the
-                <literal role="stmt">CHANGE MASTER TO</literal> statement
-                supports an <literal>IGNORE_SERVER_IDS</literal> option
-                which takes a comma-separated list of server IDs and
-                causes events originating from the corresponding servers
-                to be ignored. (Log rotation and log deletion events are
+                <literal role="stmt">CHANGE MASTER TO</literal>
+                statement supports an
+                <literal>IGNORE_SERVER_IDS</literal> option which takes
+                a comma-separated list of server IDs and causes events
+                originating from the corresponding servers to be
+                ignored. (Log rotation and log deletion events are
                 preserved.)
               </para>
-              
+
             </formalpara>
-            
+
             <para>
-              See <xref linkend="change-master-to"/>, as well as 
+              See <xref linkend="change-master-to"/>, as well as
               <xref linkend="show-slave-status"/>, for more information.
             </para>
           </listitem>


Modified: trunk/refman-5.1/programs-client-core.xml
===================================================================
--- trunk/refman-5.1/programs-client-core.xml	2010-09-10 03:04:53 UTC (rev 22666)
+++ trunk/refman-5.1/programs-client-core.xml	2010-09-10 09:04:21 UTC (rev 22667)
Changed blocks: 1, Lines Added: 32, Lines Deleted: 0; 1535 bytes

@@ -5969,6 +5969,38 @@
         </listitem>
 
         <listitem>
+          <para id="option_mysqldump_add-drop-trigger">
+            <indexterm>
+              <primary>mysqldump</primary>
+              <secondary>add-drop-trigger option</secondary>
+            </indexterm>
+
+            <indexterm>
+              <primary>add-drop-trigger option</primary>
+              <secondary>mysqldump</secondary>
+            </indexterm>
+
+            <option role="mysqldump">--add-drop-trigger</option>
+          </para>
+
+          <para>
+            Add a <literal role="stmt">DROP TRIGGER</literal> statement
+            before each <literal role="stmt">CREATE TRIGGER</literal>
+            statement.
+          </para>
+
+          <note>
+            <para>
+              This option is supported only by
+              <command>mysqldump</command> as supplied with MySQL
+              Cluster NDB 6.3.38, MySQL Cluster NDB 7.0.19, MySQL
+              Cluster NDB 7.1.8, and later MySQL Cluster release. It is
+              not available when using MySQL &current-series;.
+            </para>
+          </note>
+        </listitem>
+
+        <listitem>
           <para id="option_mysqldump_add-locks">
             <indexterm>
               <primary>mysqldump</primary>


Thread
svn commit - mysqldoc@docsrva: r22667 - in trunk: dynamic-docs/changelog dynamic-docs/command-optvars refman-5.1jon.stephens10 Sep