Fixing Crashed or Corrupt MySQL Tables

MySQL is like any other software running in a complex environment. It is known for its stability, but sometimes database tables may crash or get corrupted because of a number of reasons.

When something like this happens, you will get crash reports with information that a query failed because of a missing file or because of invalid information in one of the files. Exact error messages may vary and the following is just one example:

Query failed with message 'Incorrect information in file: './db_name/ac_user_sessions.frm''

The first step that you should take if you start receiving such crash reports is to try to repair the table. Here's how you can do that with phpMyAdmin:

1. Log into your phpMyAdmin and navigate to the database where you have activeCollab installed;
2. Select the table that crashed by clicking on the checkbox in front of its name, and than select Repair table option from the drop-down at the bottom of the tables list:

If the Repair command fails to resolve the problem, you should contact your hosting provider or system administrator for assistance.