svn commit - mysqldoc@docsrva: r1337 - in trunk: . refman-5.1 refman-common

[paul]

Author: paul
Date: 2006-02-15 20:29:46 +0100 (Wed, 15 Feb 2006)
New Revision: 1337

Log:
 r3153@kite-hub:  paul | 2006-02-15 13:28:05 -0600
 Document RENAME DATABASE. (WL#757)


Modified:
   trunk/
   trunk/refman-5.1/sql-syntax.xml
   trunk/refman-common/news-5.1.xml
   trunk/refman-common/titles.en.ent


Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:7578
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:3151
   + b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:7578
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:3153

Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2006-02-15 18:33:13 UTC (rev 1336)
+++ trunk/refman-5.1/sql-syntax.xml	2006-02-15 19:29:46 UTC (rev 1337)
@@ -3649,6 +3649,53 @@
 
     </section>
 
+    <section id="rename-database">
+
+      <title>&title-rename-database;</title>
+
+      <indexterm type="function">
+        <primary>RENAME DATABASE</primary>
+      </indexterm>
+
+      <remark role="help-topic" condition="RENAME DATABASE"/>
+
+      <remark role="help-keywords">
+        SCHEMA
+      </remark>
+
+      <remark role="help-syntax"/>
+
+<programlisting>
+RENAME {DATABASE | SCHEMA} <replaceable>db_name</replaceable> TO
<replaceable>new_db_name</replaceable>;
+</programlisting>
+
+      <remark role="help-description-begin"/>
+
+      <para>
+        This statement renames a database. It requires the
+        <literal>ALTER</literal> and <literal>DROP</literal>
privileges
+        for the database, and the <literal>CREATE</literal> privilege
+        for the new database. <literal>RENAME SCHEMA</literal> is a
+        synonym for <literal>RENAME DATABASE</literal>.
+      </para>
+
+      <para>
+        When the server receives this statement, it creates the new
+        database. Then it moves tables and other database objects such
+        as triggers to the new database. It also updates the
+        <literal>Db</literal> column in the system tables for objects
+        such as stored routines and events. Finally, the server drops
+        the old database.
+      </para>
+
+      <remark role="help-description-end"/>
+
+      <para>
+        This statement was added in MySQL 5.1.7.
+      </para>
+
+    </section>
+
     <section id="rename-table">
 
       <title>&title-rename-table;</title>

Modified: trunk/refman-common/news-5.1.xml
===================================================================
--- trunk/refman-common/news-5.1.xml	2006-02-15 18:33:13 UTC (rev 1336)
+++ trunk/refman-common/news-5.1.xml	2006-02-15 19:29:46 UTC (rev 1337)
@@ -83,6 +83,12 @@
 
       <listitem>
         <para>
+          Added the <literal>RENAME DATABASE</literal> statement.
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           Attempting to read pre-5.1.6 partitioned tables with a MySQL
           5.1.7 (or later) server now generates a suitable warning
           message. (Bug #16695)

Modified: trunk/refman-common/titles.en.ent
===================================================================
--- trunk/refman-common/titles.en.ent	2006-02-15 18:33:13 UTC (rev 1336)
+++ trunk/refman-common/titles.en.ent	2006-02-15 19:29:46 UTC (rev 1337)
@@ -1430,6 +1430,7 @@
 <!ENTITY title-release-philosophy "Release Philosophy&#x2014;No Known Bugs in
Releases">
 <!ENTITY title-remote-connection "Establishing a Remote Connection to System A from
System B">
 <!ENTITY title-removing-users "Removing User Accounts from MySQL">
+<!ENTITY title-rename-database "<literal>RENAME DATABASE</literal>
Syntax">
 <!ENTITY title-rename-table "<literal>RENAME TABLE</literal> Syntax">
 <!ENTITY title-rename-user "<literal>RENAME USER</literal> Syntax">
 <!ENTITY title-repair "How to Repair Tables">