All installation and configuration problems and questions
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
by Alfio » Thu Jul 26, 2018 8:14 am
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.
-
Alfio
-
- Posts: 22
- Joined: Mon May 26, 2008 10:46 am
by mflorell » Thu Jul 26, 2018 2:00 pm
You could always try dropping the table and recreating it.
-
mflorell
- Site Admin
-
- Posts: 18387
- Joined: Wed Jun 07, 2006 2:45 pm
- Location: Florida
-
by farhan.nazim » Wed Nov 06, 2019 3:25 am
mflorell wrote: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
-
farhan.nazim
-
- Posts: 4
- Joined: Fri Jul 12, 2019 7:47 am
by carpenox » Sun May 17, 2020 5:47 pm
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?
Alma Linux 9.4 | SVN Version: 3890 | DB Schema Version: 1721 | Asterisk 18.21.1 | PHP8
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
GC: https://join.skype.com/ujkQ7i5lV78O | DC: https://discord.gg/DVktk6smbh
-
carpenox
-
- Posts: 2428
- Joined: Wed Apr 08, 2020 2:02 am
- Location: St Petersburg, FL
-
Return to Support
Who is online
Users browsing this forum: Google [Bot] and 121 guests