bk commit - mysqldoc tree (paul:1.2818)

[paul]

Below is the list of changes that have just been committed into a local
mysqldoc repository of paul. When paul does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet
  1.2818 05/04/04 11:58:41 paul@stripped +1 -0
  Merge paul@stripped:/home/bk/mysqldoc
  into kite-hub.kitebird.com:/src/extern/MySQL/bk/mysqldoc

  Docs/manual.texi
    1.2651 05/04/04 11:58:40 paul@stripped +0 -0
    Auto merged

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	paul
# Host:	kite-hub.kitebird.com
# Root:	/src/extern/MySQL/bk/mysqldoc/RESYNC

--- 1.2650/Docs/manual.texi	2005-04-04 11:14:58 -05:00
+++ 1.2651/Docs/manual.texi	2005-04-04 11:58:40 -05:00
@@ -10632,13 +10632,13 @@
 If you have tables that use these options, you should convert them before
 upgrading.  One way to do this is to dump them with @command{mysqldump},
 edit the dump file to remove the @code{RAID} options in the @code{CREATE
-TABLE} statements, and reload the dump file.  Another way to convert a table
-is to use @code{ALTER TABLE} to convert it to use a different storage
-engine.  The use @code{ALTER TABLE} to convert it back if you want to
-continue to use the table as a @code{MyISAM} table. This approach requires
-some care, however. It cannot be used if the table contains
-@code{MyISAM}-only features such as @code{FULLTEXT} indexes or columns with
-spatial data types.
+TABLE} statements, and reload the dump file.  Another possibility is to
+use @code{CREATE TABLE @var{new_tbl} ... SELECT @var{raid_tbl}} to create
+a new table from the @code{RAID} table. However, the @code{CREATE TABLE}
+part of the statement must contain sufficient information to recreate
+column attributes as well as indexes, or column attributes may be lost
+and indexes will not appear in the new table.
+@xref{CREATE TABLE,  , @code{CREATE TABLE}}.
 
 The @file{.MYD} files for @code{RAID} tables in a given database are stored
 under the database directory in subdirectories that have names consisting of