From: Date: September 6 2007 3:07pm
Subject: svn commit - mysqldoc@docsrva: r7724 - trunk/refman-5.1
List-Archive: http://lists.mysql.com/commits/33813
Message-Id: <200709061307.l86D7PUk024011@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Author: jstephens
Date: 2007-09-06 15:07:24 +0200 (Thu, 06 Sep 2007)
New Revision: 7724

Log:

Documented issues with stored routines in >=5.1.21 -> <=5.0.46
downgrades.

Fixes Docs Bug#30660 (Thanks, Omer & Leith!)



Modified:
   trunk/refman-5.1/installing.xml


Modified: trunk/refman-5.1/installing.xml
===================================================================
--- trunk/refman-5.1/installing.xml	2007-09-06 13:04:27 UTC (rev 7723)
+++ trunk/refman-5.1/installing.xml	2007-09-06 13:07:24 UTC (rev 7724)
Changed blocks: 1, Lines Added: 28, Lines Deleted: 0; 1437 bytes

@@ -13253,6 +13253,34 @@
           </formalpara>
         </listitem>
 
+        <listitem>
+          <formalpara>
+
+            <title>Stored routines</title>
+
+            <para>
+              MySQL 5.1.21 added a number of new columns to the
+              <literal>mysql.proc</literal> table in which stored
+              routine definitions are stored. If you are downgrading
+              from MySQL 5.1.21 or later to MySQL 5.0, you cannot import
+              the MySQL 5.1 routine definitions into MySQL 5.0.46 or
+              earlier using the dump of <literal>mysql.proc</literal>
+              created by <command>mysqldump</command> (such as when
+              using the <option>--all-databases</option> option).
+              Instead, you should run <command>mysqldump
+              <option>--routines</option></command> prior to performing
+              the downgrade and run the stored routines DDL statements
+              following the downgrade.
+            </para>
+
+          </formalpara>
+
+          <para>
+            See Bug #11986, Bug #30029, and Bug #30660, for more
+            information.
+          </para>
+        </listitem>
+
       </itemizedlist>
 
     </section>