MySQL to find all tables with footer with full text in them

Question

I need to start the repair in all the tables in all my databases on my MySQL5 server because I updated the MySQL full text search file.

Is there a request or command to accomplish this?

+7

Treffynnon Feb 04 '11 at 13:46

source share

1 answer

ircmaxell · Accepted Answer · 2011-02-04T13:50:21+0000

Yes, you just need to query the INFORMATION_SCHEMA table . STATISTICS :

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