How do I check and repair my database?
You will need to recall your webhosts information and enter your site management provided by the webhost - look for phpmyadmin. In C Panel this is in the link My SQL databases.
Go to the MySQL Manager in your control panel
- Click on the phpMyAdmin link at the bottom
- Select the database you wish to check or repair
- Click on the Select All link
- Pull down the With Selected: drop down menu and
choose Check Table or Repair Table
Visual tutorial here
This Q&A was found on XOOPS Web Application System : https://xoops.org/modules/smartfaq/faq.php?faqid=654