Check for FULLTEXT INDEX in mySQL database

When converting from MyISAM to InnoDB;

It is important if running an older version of MySQL to first check for FULLTEXT INDEX as full-text indexing is not supported by InnoDB in older databases.

To run a check, execute the following query;

SELECT TABLE_SCHEMA, TABLE_NAME
FROM information_schema.statistics
WHERE index_type LIKE 'FULLTEXT%' 

Additionally, to convert multiple tables at once, do;

SELECT CONCAT('ALTER TABLE ',TABLE_NAME,' ENGINE=InnoDB;') 

FROM INFORMATION_SCHEMA.TABLES

WHERE ENGINE = 'MyISAM' AND table_schema = 'mydb';

You may need to use the options to show Full text in the results to avoid lines being truncated, also watch out from some dodgy table names, like group.