MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:plavin Date:February 26 2007 3:55pm
Subject:svn commit - mysqldoc@docsrva: r5051 - trunk/administrator
View as plain text  
Author: plavin
Date: 2007-02-26 16:55:43 +0100 (Mon, 26 Feb 2007)
New Revision: 5051

Log:
Add DROP statement a requirement when backup project includes views

Modified:
   trunk/administrator/backup.xml


Modified: trunk/administrator/backup.xml
===================================================================
--- trunk/administrator/backup.xml	2007-02-26 02:43:47 UTC (rev 5050)
+++ trunk/administrator/backup.xml	2007-02-26 15:55:43 UTC (rev 5051)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 0; 872 bytes

@@ -201,6 +201,16 @@
         <guilabel>Add DROP Statements</guilabel> adds <literal>DROP TABLE
         IF EXISTS</literal> statements to the backup file.
       </para>
+      
+      <note>
+        <para>
+          If your backup project includes views then
+          you <emphasis>must</emphasis> choose this option.
+          Restoration of a view is a two step process
+          that involves creating a dummy table with the same name as the view.
+          This table must be dropped before the view can be recreated.
+        </para>
+      </note>
 
       <para>
         <guilabel>Complete INSERTs</guilabel> will produce full


Thread
svn commit - mysqldoc@docsrva: r5051 - trunk/administratorplavin26 Feb