KB-2381 How to fix a corrupted database table index using phpMyAdmin

Purpose

A corrupted index can make the associated table inaccessible. This can cause any queries, applications, or automated processes that rely on the table to fail until the index is repaired. This article outlines how to repair the affected index.

Instructions

1. Open the phpMyAdmin interface.
2. Using the index definition from the table, drop and recreate the affected index using the following commands.
   
   1. Check the table to confirm the affected index: CHECK TABLE <table_name>;





   2. Identify the affected index and column information: SHOW CREATE TABLE <table_name>;
      
      
      
      
   3. Drop the affected index: ALTER TABLE <table_name> DROP INDEX <index_name>;




   4. Recreate the affected index: ALTER TABLE <table_name> ADD INDEX <index_name>(cols);




   5. Confirm the issue was resolved: CHECK TABLE <table_name>;

      
      

Affected Versions

• This article applies to all versions of Appian Cloud.

Last Reviewed: April 2026