*Title: Fixing Crashed or Corrupt MySQL Tables
*Slug: mysql-table-crash

================================================================

activeCollab uses a <a href="http://www.mysql.com/">MySQL</a> database to store your data. Occasionally, MySQL tables can crash or get corrupted for various reason. When something like that happens, you will get crash reports stating that the query failed because of missing file or invalid information in one of the files. Exact error messages may vary. For instance:

<{code}>Query failed with message 'Incorrect information in file: './db_name/ac_user_sessions.frm''<{/code}>

If you receive such a crash report, try repairing the table by using the <a href="http://www.phpmyadmin.net/home_page/index.php">phpMyAdmin</a> tool:

<{step num=1}>Log in to the phpMyAdmin and navigate to the database where activeCollab is installed<{/step}>
<{step num=2}>Select the table that crashed by clicking on check-box in front of its name and select the Repair table option from drop-down at the bottom of the tables list.<{/step}>

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