Author: paul
Date: 2006-09-27 20:43:39 +0200 (Wed, 27 Sep 2006)
New Revision: 3484
Log:
r14099@polar: paul | 2006-09-27 13:46:48 -0500
mysqldump --routines requires SELECT for mysql.proc.
Modified:
trunk/refman-5.0/client-utility-programs.xml
trunk/refman-5.1/client-utility-programs.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:14097
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:8680
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:14099
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:8680
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-27 18:26:46 UTC (rev 3483)
+++ trunk/refman-5.0/client-utility-programs.xml 2006-09-27 18:43:39 UTC (rev 3484)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 8; 1654 bytes
@@ -10849,14 +10849,16 @@
<para>
Dump stored routines (functions and procedures) from the
- dumped databases. The output generated by using
- <option>--routines</option> contains <literal>CREATE
- PROCEDURE</literal> and <literal>CREATE FUNCTION</literal>
- statements to re-create the routines. However, these
- statements do not include attributes such as the routine
- creation and modification timestamps. This means that when
- the routines are reloaded, they will be created with the
- timestamps equal to the reload time.
+ dumped databases. Use of this option requires the
+ <literal>SELECT</literal> privilege for the
+ <literal>mysql.proc</literal> table. The output generated
+ by using <option>--routines</option> contains
+ <literal>CREATE PROCEDURE</literal> and <literal>CREATE
+ FUNCTION</literal> statements to re-create the routines.
+ However, these statements do not include attributes such
+ as the routine creation and modification timestamps. This
+ means that when the routines are reloaded, they will be
+ created with the timestamps equal to the reload time.
</para>
<para>
Modified: trunk/refman-5.1/client-utility-programs.xml
===================================================================
--- trunk/refman-5.1/client-utility-programs.xml 2006-09-27 18:26:46 UTC (rev 3483)
+++ trunk/refman-5.1/client-utility-programs.xml 2006-09-27 18:43:39 UTC (rev 3484)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 8; 1654 bytes
@@ -10785,14 +10785,16 @@
<para>
Dump stored routines (functions and procedures) from the
- dumped databases. The output generated by using
- <option>--routines</option> contains <literal>CREATE
- PROCEDURE</literal> and <literal>CREATE FUNCTION</literal>
- statements to re-create the routines. However, these
- statements do not include attributes such as the routine
- creation and modification timestamps. This means that when
- the routines are reloaded, they will be created with the
- timestamps equal to the reload time.
+ dumped databases. Use of this option requires the
+ <literal>SELECT</literal> privilege for the
+ <literal>mysql.proc</literal> table. The output generated
+ by using <option>--routines</option> contains
+ <literal>CREATE PROCEDURE</literal> and <literal>CREATE
+ FUNCTION</literal> statements to re-create the routines.
+ However, these statements do not include attributes such
+ as the routine creation and modification timestamps. This
+ means that when the routines are reloaded, they will be
+ created with the timestamps equal to the reload time.
</para>
<para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r3484 - in trunk: . refman-5.0 refman-5.1 | paul | 27 Sep |
