Re: MyISAM FULLTEXT Index

[Rick James]

On unix, I would do
mysqldump --no-data | grep -i FULLTEXT

On any OS (and with a new enough MySQL), one could do:

SELECT  TABLE_SCHEMA AS db_name,
        TABLE_NAME
    FROM  information_schema.STATISTICS
    WHERE  INDEX_TYPE = 'FULLTEXT'

(It may take some time, depending on number of tables.)

For conversion tips:
http://mysql.rjweb.org/doc.php/myisam2innodb



Edited 1 time(s). Last edit at 01/13/2014 01:06PM by Rick James.