svn commit - mysqldoc@docsrva: r12484 - in trunk: . dynamic-docs/changelog refman-6.0

[paul.dubois]

Author: paul
Date: 2008-11-14 20:22:45 +0100 (Fri, 14 Nov 2008)
New Revision: 12484

Log:
 r35727@frost:  paul | 2008-11-14 13:22:09 -0500
 Document bugfix:
 Bug#33364: Online Backup: Purge statement missing
 
 Documented PURGE BACKUP LOGS statement


Modified:
   trunk/dynamic-docs/changelog/mysqld-1.xml
   trunk/refman-6.0/backup.xml
   trunk/refman-6.0/sql-syntax-server-administration.xml

Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:39854
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:35706
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:34365
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:39854
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:35727
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:34365


Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml	2008-11-14 18:37:43 UTC (rev 12483)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml	2008-11-14 19:22:45 UTC (rev 12484)
Changed blocks: 1, Lines Added: 27, Lines Deleted: 0; 836 bytes

@@ -34084,4 +34084,31 @@
 
   </logentry>
 
+  <logentry entrytype="feature">
+
+    <tags>
+      <manual type="MySQL Backup"/>
+      <manual type="PURGE BACKUP LOGS"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="33364"/>
+    </bugs>
+
+    <versions>
+      <version ver="6.0.9"/>
+    </versions>
+
+    <message>
+
+      <para>
+        A new statement, <literal>PURGE BACKUP LOGS</literal>, enables
+        the contents of the MySQL Backup logs to be culled. See
+        <xref linkend="purge-backup-logs"/>.
+      </para>
+
+    </message>
+
+  </logentry>
+
 </changelog>


Modified: trunk/refman-6.0/backup.xml
===================================================================
--- trunk/refman-6.0/backup.xml	2008-11-14 18:37:43 UTC (rev 12483)
+++ trunk/refman-6.0/backup.xml	2008-11-14 19:22:45 UTC (rev 12484)
Changed blocks: 1, Lines Added: 3, Lines Deleted: 1; 728 bytes

@@ -2013,7 +2013,9 @@
           logging to files, the server writes lines with a field for
           each column in the corresponding log table. The server also
           writes an initial line to the file at startup to indicate the
-          names of the fields.
+          names of the fields. Backup log contents can be culled with
+          the <literal role="stmt">PURGE BACKUP LOGS</literal>
+          statement. See <xref linkend="purge-backup-logs"/>.
         </para>
 
         <para>


Modified: trunk/refman-6.0/sql-syntax-server-administration.xml
===================================================================
--- trunk/refman-6.0/sql-syntax-server-administration.xml	2008-11-14 18:37:43 UTC (rev 12483)
+++ trunk/refman-6.0/sql-syntax-server-administration.xml	2008-11-14 19:22:45 UTC (rev 12484)
Changed blocks: 1, Lines Added: 68, Lines Deleted: 0; 2614 bytes

@@ -2939,6 +2939,74 @@
 
     </section>
 
+    <section id="purge-backup-logs">
+
+      <title><literal role="stmt">PURGE BACKUP LOGS</literal> Syntax</title>
+
+      <indexterm>
+        <primary>PURGE BACKUP LOGS</primary>
+      </indexterm>
+
+      <remark role="help-topic" condition="PURGE BACKUP LOGS"/>
+
+      <remark role="help-keywords">
+        PURGE BACKUP LOGS BEFORE TO
+      </remark>
+
+      <remark role="help-syntax"/>
+
+<programlisting>
+PURGE BACKUP LOGS
+    ] TO <replaceable>id</replaceable> | BEFORE <replaceable>datetime_expr</replaceable> ]
+</programlisting>
+
+      <remark role="help-description-begin"/>
+
+      <para>
+        The <literal role="stmt">PURGE BACKUP LOG</literal> statement
+        removes rows from the MySQL Backup log tables in the
+        <literal>mysql</literal> database,
+        <literal>backup_history</literal> and
+        <literal>backup_progress</literal> (see
+        <xref linkend="backup-database-restore-monitoring"/>). This
+        statement requires the <literal role="priv">SUPER</literal>
+        privilege.
+      </para>
+
+      <para>
+        With no <literal>TO</literal> or <literal>BEFORE</literal>
+        clause, the statement deletes all rows in the log tables. With a
+        <literal>TO</literal> clause, the statement deletes rows with a
+        <literal>backup_id</literal> column value less than the
+        <replaceable>id</replaceable> value. With a
+        <literal>BEFORE</literal> clause, the statement deletes rows
+        with a <literal>start_time</literal> column value less than the
+        <replaceable>datetime_expr</replaceable> value. The
+        <replaceable>datetime_expr</replaceable> argument should
+        evaluate to a <literal role="type">DATETIME</literal> value (a
+        value in <literal>'YYYY-MM-DD hh:mm:ss'</literal> format).
+      </para>
+
+      <remark role="help-description-end"/>
+
+      <para>
+        Examples:
+      </para>
+
+      <remark role="help-example"/>
+
+<programlisting>
+PURGE BACKUP LOGS TO 143;
+PURGE BACKUP LOGS BEFORE '2008-10-31 14:32:19';
+</programlisting>
+
+      <para>
+        <literal role="stmt">PURGE BACKUP LOG</literal> was added in
+        MySQL 6.0.9.
+      </para>
+
+    </section>
+
     <section id="restore">
 
       <title><literal role="stmt">RESTORE</literal> Syntax</title>