Database Tables Lost Indexes? How to Recover?

In general, you can fix the databases with some work in myPHPAdmin. See this article (among others found via the googles) https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin

There is also this post https://www.maketecheasier.com/fix-corrupted-wordpress-database-2/ that says you can let WP repair the databases by addjine one line in your wp-config.php file:

define (WP_ALLOW_REPAIR, “true”);

…placing it at the location as specified in the above link. Note that you would probably want to do this when there is no other access to the site. Although, according to the Codex https://codex.wordpress.org/Editing_wp-config.php , scroll down to the ‘WP_ALLOW_REPAIR’ entry) , this will:

Please Note: That this define enables the functionality, The user does
not need to be logged in to access this functionality when this define
is set. This is because its main intent is to repair a corrupted
database, Users can often not login when the database is corrupt.

A backup of your database is always a good idea before you start.