Bug #10635 Loss of data when converting from InnoDB to MERGE
Submitted: 13 May 2005 20:30 Modified: 13 May 2005 20:56
Reporter: [ name withheld ] Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Administrator Severity:S1 (Critical)
Version:1.0.20 OS:Windows (Windows XP SP2/Server 2003)
Assigned to: CPU Architecture:Any

[13 May 2005 20:30] [ name withheld ] 
Description:
Tried to convert from a large (1.3GB) table from InnoDB to Merge using Administrator.  It converted the table to Merge, but all data was lost.  It appears that the InnoDB file still contained the data because it was still over 1.3 GBs.  I am using MySQL Server 4.1.11.

How to repeat:
Get a table into InnoDB with data, then try to convert it to MERGE.  May need to be a large table.

Suggested fix:
None.
[13 May 2005 20:56] MySQL Verification Team 
You can't convert an InnoDB table to Merge:

http://dev.mysql.com/doc/mysql/en/merge-storage-engine.html

A MERGE table is a collection of identical MyISAM tables that can be used as one. ``Identical'' means that all tables have identical column and index information.