Error: Cannot Repair corrupted tables in VICIDial

Getting Error while repairing corrupted tables in vicdial
ERROR : Table Cannot Be Repaired !!!

Solution

When mySQL asterisk database table are corrupted and not able to repair normal repair command please follow the below steps:

Step1
Go to /var/lib/mysql/asterisk and you can find .MYI files for all tables

Step2
Type following:
# myisamchk -r vicidial_list.MYI

This will start fixing the index and the table will be repaired.