Author: paul
Date: 2007-04-19 21:17:07 +0200 (Thu, 19 Apr 2007)
New Revision: 6008
Log:
r23761@polar: paul | 2007-04-19 12:13:44 -0500
Add warning about USE_FRM. (Salle)
Modified:
trunk/refman-4.1/sql-syntax.xml
trunk/refman-5.0/sql-syntax.xml
trunk/refman-5.1/sql-syntax.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:23738
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:19401
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:14593
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:23761
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:19401
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:14593
Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml 2007-04-19 18:28:38 UTC (rev 6007)
+++ trunk/refman-4.1/sql-syntax.xml 2007-04-19 19:17:07 UTC (rev 6008)
Changed blocks: 1, Lines Added: 16, Lines Deleted: 0; 1000 bytes
@@ -16923,6 +16923,22 @@
<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:
Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml 2007-04-19 18:28:38 UTC (rev 6007)
+++ trunk/refman-5.0/sql-syntax.xml 2007-04-19 19:17:07 UTC (rev 6008)
Changed blocks: 1, Lines Added: 16, Lines Deleted: 0; 1037 bytes
@@ -15079,6 +15079,22 @@
<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>
<literal>REPAIR TABLE</literal> statements are written to the
binary log unless the optional
Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml 2007-04-19 18:28:38 UTC (rev 6007)
+++ trunk/refman-5.1/sql-syntax.xml 2007-04-19 19:17:07 UTC (rev 6008)
Changed blocks: 2, Lines Added: 17, Lines Deleted: 1; 1428 bytes
@@ -16938,6 +16938,22 @@
<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>
<literal>REPAIR TABLE</literal> statements are written to the
binary log unless the optional
@@ -19663,7 +19679,7 @@
</para>
<para>
- This column was added in MySQL 5.1.17. See
+ This column was added in MySQL 5.1.17. See
<xref linkend="news-5-1-17"/>, for important information
if you are using the Event Scheduler and are upgrading
from MySQL 5.1.16 (or earlier) to MySQL 5.1.17 (or later).
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r6008 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 19 Apr |
