TOPIC: Vicidial mysql repair command / goautodial mysql repair command
Description: Command to repair the corrupted database in vicidial or goautodial.
Check out my Youtube Channel for more video tutorials LINK
Below are the possible issue you will be facing once 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
Run the below command in ssh shell ie: from putty
mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
latest vicibox use
mysqlcheck -p --check asterisk
mysqlcheck -p --auto-repair asterisk
mysqlcheck -p --optimize asterisk
If above commands not repairing corrupt Table run the below command under mysql
mysql -p
mysql>use asterisk
mysql>REPAIR table table_name USE_FRM;
eg: REPAIR table vicidial_live_agents USE_FRM;
note: if you using goautodial then the password will be vicidialnow
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
Video Link for reference
Error : Incorrect file format 'vicidial_live_agents'
error : Corrupt
asterisk.vicidial_manager
Error : Incorrect file format 'vicidial_manager'
error : Corrupt
Also Check
Conclusion:
For professional Support ping me at
Skype: striker24x7
gmail: mailto:striker24x7@gmail.com