How to repair crashed mysql table in vicidial

vicidial mysql repair command

Topic : How to repair crashed mysql table in vicidial

vicidial mysql repair command

Check out my Youtube Channel for more video tutorials


vicidial mysql repair command

  Overview: Vicidial mysql repair command

In this blog post i have give the commands to repair the corrupted database in vicidial based servers like vicibox goautodial scratch vicidial installation
VICIdial is an enterprise class, open source, contact center suite in use by many large call centers around the world. VICIdial has a full featured predictive dialer. It is capable of inbound, outbound, and blended phone call handling.

Vicidial software uses below software's for its operation.

mysql/mariadb - database

Apache - webserver

Asterisk - Telephony

  Root cause for Vicidial Database Corrupt

Often Vicidial Database will be crashed due to many reasons which i have listed below.

1. Server Over Load
2. Server Improper Shutdown
3. Server Low Disk Space
Impact of Database corrupt in vicidial

  Impact in Vicidial while db/mysql corrupted

1. your session has been disabled
2. Autodial calls not landing to Agents.
3. realtime report not updating properly
4. agent error
5. Time sync error

  Vicidial database repair command

    For Latest Vicibox run the below commands

mysqlcheck -p --check asterisk
mysqlcheck -p --auto-repair asterisk
mysqlcheck -p --optimize asterisk

If the above command failed to Repair a particular table, identify the corrupted table and run the below command.

mysql -p
mysql>use asterisk
mysql>REPAIR table table_name USE_FRM;
eg: REPAIR table vicidial_live_agents USE_FRM;

Note: by default mysql root password is not set in vicibox, that is just press enter after mysql -p, if not working use mysql -ucront -p with password 1234

    For Goautodial/ Vicidial scratch installs run below command

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
note: if you using goautodial then the password will be goautodial, if not working then use below command, which uses default vicidial mysql credentials

mysqlcheck -u cron -p --auto-repair --check --optimize --all-databases
password will be : 1234
note: the default password of vicidial mysql logins.

  you might receive below error while running above command

Error:: mysqlcheck doesnt't support multiple contradicting commands.
Run the below commands
mysqlcheck -u root -p --auto-repair --all-databases
mysqlcheck -u root -p --optimize --all-databases

         Sample mysql check command output

Error : Incorrect file format 'vicidial_live_agents'
error : Corrupt
asterisk.vicidial_manager
Error : Incorrect file format 'vicidial_manager'
error : Corrupt

  Conclusion:

To avoid the Database Crash , avoid overload in server limit the agent login's and dial limit as per server spec , use proper UPS to avoid improper server shutdown,
use the linux command shutdown -h now to shutdown the server instead of pressing power button directly.


For professional Support ping me at
Skype: striker24x7
Next Post Previous Post
4 Comments
  • Anonymous
    Anonymous November 17, 2020 at 10:11 PM

    mysqlcheck -u cron -p --auto-repair --all-databases
    pass:1234
    mysqlcheck -u cron -p --check --all-databases
    pass:1234
    mysqlcheck -u cron -p --optimize --all-databases
    pass:1234
    /usr/share/astguiclient/AST_DB_optimize.pl --debug

  • AnilKumar
    AnilKumar December 11, 2020 at 12:15 PM

    Hello Sir, As per your documentation, i have installed vicidial with asterisk 13 in centos . Sir, I am unable to get full administrator details and not able to access php my admin too sir. I searched your blog related maria DB commands, I have not found that stuff in your blog sir. Any solution for this sir?

  • Unknown
    Unknown June 19, 2021 at 9:27 AM

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

  • rheymzkilove
    rheymzkilove February 18, 2022 at 9:51 PM

    working thanks

Add Comment
comment url