From: Dan Nelson
Date: August 24 2004 5:46pm
Subject: Re: Debating over table types
List-Archive: http://lists.mysql.com/mysql/171478
Message-Id: <20040824174618.GF36920@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Aug 24), Stuart Felenstein said:
> Right, I have set up some tables with text columns that will need
> full text searching, In those cases I chose myisam.  Is there any
> danger in changing table types on the fly ? Not including the loss of
> any foreign keys that may have been set up (innodb to myisam). I'm
> wondering more about data corruption ?

During testing I've converted tables from MyISAM to Innodb and back
with no problems.

-- 
	Dan Nelson
	dnelson@stripped