No vicidial list after database repair

[scopor]

Hello all, I am having the following problem. My vicidial list is empty. This happens after getting "your session is disabled logout please contact your administrator", which was caused by power outage. Agents could not have logged in. I have ran mysqlcheck -u cron -p --auto-repair and also mysql>repair table table_name use_frm;. Tables Vicidial_live_agents and vicdial_lists were among the tables that were corrupted. I can now log agents in successfully however the lists and custom fields are all gone. Any ideas as to how to get this back? I don't have a backup of mysql

My config is as follows:

Vicibox 6 i686-6.xx | Vicidial VERSION: 2.10-446a BUILD: 140625-1931.|Asterisk 1.8.28.2-64.7.x86_64| Single Server| No Digium/Sangoma Hardware| No Extra Software After installation| Dual Intel Xeon 3.0

I did a search online for missing vicidial list but I am not sure if anyone ever had the issue as I didn't find any match.

Thanks.

[scopor]

Any ideas anyone?????

[boybawang]

you may need to do a deeper database repair, first shutdown the mysql process then do a myisamchk -r /var/lib/mysql/asterisk/*.MYI