Author: paul
Date: 2006-09-26 22:11:14 +0200 (Tue, 26 Sep 2006)
New Revision: 3467
Log:
r14061@polar: paul | 2006-09-26 14:46:49 -0500
Document --flush-privileges option for mysqldump. (Bug#21424)
Modified:
trunk/refman-5.0/client-utility-programs.xml
trunk/refman-5.0/news-5.0.xml
trunk/refman-5.1/client-utility-programs.xml
trunk/refman-5.1/news-5.1.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:14058
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:8616
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:10466
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:14061
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:8616
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:10466
Modified: trunk/refman-5.0/client-utility-programs.xml
===================================================================
--- trunk/refman-5.0/client-utility-programs.xml 2006-09-26 19:20:23 UTC (rev 3466)
+++ trunk/refman-5.0/client-utility-programs.xml 2006-09-26 20:11:14 UTC (rev 3467)
Changed blocks: 1, Lines Added: 26, Lines Deleted: 0; 1426 bytes
@@ -10274,6 +10274,32 @@
<para>
<indexterm>
<primary>mysqldump</primary>
+ <secondary>flush-privileges option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>flush-privileges option</primary>
+ <secondary>mysqldump</secondary>
+ </indexterm>
+
+ <option>--flush-privileges</option>
+ </para>
+
+ <para>
+ Emit a <literal>FLUSH PRIVILEGES</literal> statement after
+ dumping the <literal>mysql</literal> database. This option
+ should be used any time the dump contains the
+ <literal>mysql</literal> database and any other database
+ that depends on the data in the <literal>mysql</literal>
+ database for proper restoration. This option was added in
+ MySQL 5.0.26.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysqldump</primary>
<secondary>force option</secondary>
</indexterm>
Modified: trunk/refman-5.0/news-5.0.xml
===================================================================
--- trunk/refman-5.0/news-5.0.xml 2006-09-26 19:20:23 UTC (rev 3466)
+++ trunk/refman-5.0/news-5.0.xml 2006-09-26 20:11:14 UTC (rev 3467)
Changed blocks: 1, Lines Added: 14, Lines Deleted: 0; 935 bytes
@@ -210,6 +210,20 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ <command>mysqldump</command> now has a
+ <option>--flush-privileges</option> option. It causes
+ <command>mysqldump</command> to emit a <literal>FLUSH
+ PRIVILEGES</literal> statement after dumping the
+ <literal>mysql</literal> database. This option should be used
+ any time the dump contains the <literal>mysql</literal>
+ database and any other database that depends on the data in
+ the <literal>mysql</literal> database for proper restoration.
+ (Bug #21424)
+ </para>
+ </listitem>
+
</itemizedlist>
<para>
Modified: trunk/refman-5.1/client-utility-programs.xml
===================================================================
--- trunk/refman-5.1/client-utility-programs.xml 2006-09-26 19:20:23 UTC (rev 3466)
+++ trunk/refman-5.1/client-utility-programs.xml 2006-09-26 20:11:14 UTC (rev 3467)
Changed blocks: 2, Lines Added: 32, Lines Deleted: 3; 2396 bytes
@@ -10190,6 +10190,32 @@
<para>
<indexterm>
<primary>mysqldump</primary>
+ <secondary>flush-privileges option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>flush-privileges option</primary>
+ <secondary>mysqldump</secondary>
+ </indexterm>
+
+ <option>--flush-privileges</option>
+ </para>
+
+ <para>
+ Emit a <literal>FLUSH PRIVILEGES</literal> statement after
+ dumping the <literal>mysql</literal> database. This option
+ should be used any time the dump contains the
+ <literal>mysql</literal> database and any other database
+ that depends on the data in the <literal>mysql</literal>
+ database for proper restoration. This option was added in
+ MySQL 5.1.12.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <indexterm>
+ <primary>mysqldump</primary>
<secondary>force option</secondary>
</indexterm>
@@ -11358,23 +11384,26 @@
<xref linkend="backup"/>, and
<xref linkend="backup-strategy-example"/>.
</para>
-
+
<indexterm>
<primary>mysqldump</primary>
<secondary>views</secondary>
</indexterm>
+
<indexterm>
<primary>mysqldump</primary>
<secondary>problems</secondary>
</indexterm>
+
<indexterm>
<primary>mysqldump</primary>
<secondary>workarounds</secondary>
</indexterm>
+
<para>
If you encounter problems backing up views, please read the
- section that covers restrictions on views which describes
- a workaround for backing up views when this fails due to
+ section that covers restrictions on views which describes a
+ workaround for backing up views when this fails due to
insufficient privileges. See
<xref linkend="view-restrictions"/>.
</para>
Modified: trunk/refman-5.1/news-5.1.xml
===================================================================
--- trunk/refman-5.1/news-5.1.xml 2006-09-26 19:20:23 UTC (rev 3466)
+++ trunk/refman-5.1/news-5.1.xml 2006-09-26 20:11:14 UTC (rev 3467)
Changed blocks: 1, Lines Added: 14, Lines Deleted: 0; 935 bytes
@@ -638,6 +638,20 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ <command>mysqldump</command> now has a
+ <option>--flush-privileges</option> option. It causes
+ <command>mysqldump</command> to emit a <literal>FLUSH
+ PRIVILEGES</literal> statement after dumping the
+ <literal>mysql</literal> database. This option should be used
+ any time the dump contains the <literal>mysql</literal>
+ database and any other database that depends on the data in
+ the <literal>mysql</literal> database for proper restoration.
+ (Bug #21424)
+ </para>
+ </listitem>
+
</itemizedlist>
<para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r3467 - in trunk: . refman-5.0 refman-5.1 | paul | 26 Sep |