MySQL Forums
Forum List  »  MyISAM

Re: MyISAM FULLTEXT Index
Posted by: Rick James
Date: January 13, 2014 01:06PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
3339
January 12, 2014 06:30AM
Re: MyISAM FULLTEXT Index
1832
January 13, 2014 01:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.