How to Fix a Broken WordPress Database

1. Log in to the cPanel interface offered by your Web-hosting provider. The cPanel interface is one of the most ubiquitous management interfaces for Web-hosting customers, so chances are this is what your provider uses. If your provider uses an alternative to cPanel, contact customer support and ask how to access your site administrative options.
2. Connect to your database using the PHPmyAdmin interface. PHPmyAdmin is a standard administrator interface for managing databases graphically, and it is offered by a majority of hosting providers. If your provider does not offer PHPmyAdmin, contact them for a recommended alternative.

3. Select your WordPress database from the left column of the PHPmyAdmin interface. You will need to know which one of the databases is your WordPress database, but typically, a WordPress database will contain the initials 'wp' somewhere in the name. If you have any doubts, the WordPress database name for your site is contained within the 'wp-config.php' file, which by default is found in the base directory of your WordPress installation.
4. Look in the main window of the PHPmyAdmin interface, just below the list of tables, for a link that reads 'Check tables having overhead.' Click this link and then select the 'Repair table' option from the 'With selected' drop-down menu just to the left.
5. Verify to ensure that the message, 'Your SQL query has been executed successfully' is returned after you repair the tables. Also, check to see if your WordPress blog is functioning as expected after this repair.