DMA Radius : How to repair "Incorrect key file for table ‘./conntrack/xxxx@xxxxxx@xxxxxx.MYI’"

DMA Radius : How to repair "Incorrect key file for table
Some times if your production server goes down due to power failure you might face below error while accessing “Connection Tracking Reports” in Radius manager.

Incorrect key file for table ‘./conntrack/2017@002d06@002d04.MYI’. try to repair it

Follow below mentioned steps to resolve issue.

How to repair table[Ubuntu]?

Go to database folder
cd /var/lib/mysql/conntrack
service mysql stop
myisamchk -r -v -f 2017\@002d06\@002d04.MYI
service mysql start
# don’t forgot to change table name

How to repair table[Centos]?

Go to database folder
cd /var/lib/mysql/conntrack
service mysqld stop
myisamchk -r -v -f 2017\@002d06\@002d04.MYI
service mysqld start
# don’t forgot to change table name

Comments