This happened today when trying to view the front end of a site.

1.  I  tried to access the wp-admin.

2. A message came up saying one or more tables needed to be repaired.

3. I followed instructions for adding define(‘WP_ALLOW_REPAIR’, true);  to the config.php file.

4.  I tried again to load wp-admin and was offered the choice to have it attempt database repair.

5.  It failed.

6.  I went to phpMyAdmin and selected the wp_options table and initiated repair.

7.  Happy Ending.   All is well again.

 

A recently launched Joomla 2.5 site was down this morning with the following error:

Table ‘./xxxx_suffix/xxxx_session’ is marked as crashed and should be repaired SQL=INSERT INTO `xxxx_session` (`session_id`, `client_id`, `time`) VALUES (’87b1b689ed654ea16833779add58ee44′, 0, ‘1342450283’)

Repairing a database table is not difficult,  but the error causes panic for the clients and I am not always sitting at my computer….

I created a ScreenSteps tutorial on how to handle an error like this and share it.

How to repair SQL database table