I have a very interesting problem with a Multisite configuration.
Two of the sites in my Network have lost their indexes in all database tables related to the sites.
I cannot update these sites because they've totally lost their indexes. How can I recover from this? Is there a way I can restore/rebuild the indexes for each of the tables in the database?
This happened to another site in the past. I was lucky enough to be able to run a repair/optimize on the tables and it seemed to correct itself. However, I've tried the same process on these particular sites, and the problem still persists.
Any advice on what I should do here?
- MariaDB: 10.0.28
- Engine: MyISAM
- Charset: utf8
- Collation: utf8_general_ci
Note: Each site in the network was once upon a time in a standalone installation. I've migrated them all into Multsite. They functioned just fine both pre-migration and post-migration. WordPress has been updated about 3-4 times since the migration. Several plugins updated as well.