Corrupt vicidial_live_agents table

[Alfio]

Hi, I have some problems with my Vicidial server, the vicidial_live_agents table got corrupt and stop dialing, I tried the repair methods of the tables and i got:

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

Repairing tables
asterisk.vicidial_live_agents
Error : Incorrect file format 'vicidial_live_agents'
error : Corrupt

I also stop mysql and ran:
myisamchk --recover vicidial_live_agents.MYI
myisamchk -o vicidial_live_agents.MYI

And i Got this error:

myisamchk: error: 'vicidial_live_agents.MYD' is not a MyISAM-table



What else can i do to try to fix this problem?

Thanks in advanced.




- ViciBox v.8.0.1
Asterisk 11.25.1-vici
VERSION: 2.14-669a
BUILD: 180411-1647
CPU i5, 8gb DDR, No digium or sangoma Hardware
I have Cepstral Installed.

[mflorell]

You could always try dropping the table and recreating it.

[farhan.nazim]

You could always try dropping the table and recreating it.

First login database
mysql -u root -p
Sample:Use This Command # repair table table_name use_frm;

# use asterisk;


like # repair table vicidial_live_agents table use_frm;

Enjoy

[carpenox]

farhan, thx, i had a database that wouldnt repair with msisamchk but the command you said worked except i had to take out the second "table" and use: repair table vicidial_manager use_frm;

was the second table a typo or suppsoed to be there?