Author: jstephens
Date: 2007-05-17 06:41:38 +0200 (Thu, 17 May 2007)
New Revision: 6508
Log:
Moved misplaced warning about USE_FRM (Thanks, JimW!)
Modified:
trunk/refman-4.1/sql-syntax.xml
Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml 2007-05-16 23:54:20 UTC (rev 6507)
+++ trunk/refman-4.1/sql-syntax.xml 2007-05-17 04:41:38 UTC (rev 6508)
Changed blocks: 2, Lines Added: 16, Lines Deleted: 16; 1816 bytes
@@ -13501,6 +13501,22 @@
this information is also stored in the
<filename>.MYI</filename> file.
</para>
+
+ <caution>
+ <para>
+ Do not use <literal>USE_FRM</literal> if your table was
+ created by a different version of the MySQL server than the
+ one you are currently running. Doing so risks the loss of
+ all rows in the table. It is particularly dangerous to use
+ <literal>USE_FRM</literal> after the server returns this
+ message:
+ </para>
+
+<programlisting>
+Table upgrade required. Please do
+"REPAIR TABLE `<replaceable>tbl_name</replaceable>`" to fix it!
+</programlisting>
+ </caution>
<para>
Before MySQL 4.1.1, <literal>REPAIR TABLE</literal> statements
@@ -17015,22 +17031,6 @@
<remark role="help-description-end"/>
- <caution>
- <para>
- Do not use <literal>USE_FRM</literal> if your table was
- created by a different version of the MySQL server than the
- one you are currently running. Doing so risks the loss of
- all rows in the table. It is particularly dangerous to use
- <literal>USE_FRM</literal> after the server returns this
- message:
- </para>
-
-<programlisting>
-Table upgrade required. Please do
-"REPAIR TABLE `<replaceable>tbl_name</replaceable>`" to fix it!
-</programlisting>
- </caution>
-
<para>
<literal>SHOW TABLE STATUS</literal> returns the following
fields:
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r6508 - trunk/refman-4.1 | jon | 17 May |
