Vicidial mysql repair command / goautodial mysql repair command
below are the possible issue faced 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
Run the below command as ssh shell ie: from putty
mysqlcheck -u root -p –auto-repair –check –optimize –all-databases
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.