MySQL MyISAM2InnoDB

convert2inno.sql

# define schema to be updated
SET @scheme2mod="SCHEMA_XYZ";
# create queries to drop fulltext indexes, which InnoDB is no capable of
Select concat("Alter Table ",TABLE_SCHEMA,".",TABLE_NAME," DROP INDEX ",INDEX_NAME,";") as rmIdx
FROM INFORMATION_SCHEMA.STATISTICS
WHERE
	TABLE_SCHEMA=@scheme2mod
	and INDEX_TYPE="FULLTEXT"
GROUP BY rmIdx
LIMIT 0,10000;
# create queroes to modify storage engine
SELECT concat("Alter Table ",TABLE_SCHEMA,".",TABLE_NAME, " ENGINE=\"InnoDB\";") as updTbl
FROM information_schema.TABLES
WHERE
	TABLE_SCHEMA=@scheme2mod
	and ENGINE="MyISAM"
LIMIT 0,10000;

# if the storage engine modification fails with
# ERROR 1071 ...: Specified key was too long; max key length is 767 bytes
# then the indexes to be transferred are too big. an utf8-character consumes 3bytes in index.