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?
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%'
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With