13

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

Is there a query or command I can run to do this?

Treffynnon
  • 21,365
  • 6
  • 65
  • 98

1 Answers1

24

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

SELECT TABLE_SCHEMA, TABLE_NAME
FROM information_schema.statistics
WHERE index_type LIKE 'FULLTEXT%'
Janne Annala
  • 25,928
  • 8
  • 31
  • 41
ircmaxell
  • 163,128
  • 34
  • 264
  • 314
  • 2
    Thanks that does the trick. I have added an additional parameter to the select portion of the query `CONCAT('REPAIR TABLE \`', TABLE_SCHEMA, '\`.\`', TABLE_NAME, '\` QUICK;')` – Treffynnon Feb 04 '11 at 13:56