{"id":241,"date":"2016-07-29T05:44:30","date_gmt":"2016-07-29T05:44:30","guid":{"rendered":"http:\/\/symbioticindia.in\/docu\/?p=241"},"modified":"2016-07-29T05:44:30","modified_gmt":"2016-07-29T05:44:30","slug":"vicidial-mysql-repair-cmd-db-repair-command","status":"publish","type":"post","link":"http:\/\/symbioticindia.in\/docu\/2016\/07\/29\/vicidial-mysql-repair-cmd-db-repair-command\/","title":{"rendered":"vicidial mysql repair cmd db repair command"},"content":{"rendered":"<div>Vicidial mysql repair command \u00a0\/ goautodial mysql repair command<\/div>\n<div><\/div>\n<div><\/div>\n<div>below are the possible issue faced while db\/mysql corrupted<\/div>\n<div>1. your session has been disabled<\/div>\n<div>2. Autodial calls not landing to Agents.<\/div>\n<div>3. realtime report not updating properly<\/div>\n<div>4. agent error<\/div>\n<div><\/div>\n<div>Run the below command as ssh shell ie: from putty<\/div>\n<div><\/div>\n<div>mysqlcheck -u root -p &#8211;auto-repair &#8211;check &#8211;optimize &#8211;all-databases<\/div>\n<div><\/div>\n<div>note: if you using goautodial then the password will be vicidialnow<\/div>\n<div><\/div>\n<div>mysqlcheck -u cron -p &#8211;auto-repair &#8211;check &#8211;optimize &#8211;all-databases<\/div>\n<div><\/div>\n<div>password will be : 1234<\/div>\n<div>note: the default password of vicidial mysql logins.<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Vicidial mysql repair command \u00a0\/ 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 &#8211;auto-repair ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"http:\/\/symbioticindia.in\/docu\/2016\/07\/29\/vicidial-mysql-repair-cmd-db-repair-command\/\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,25,23],"tags":[],"class_list":["post-241","post","type-post","status-publish","format-standard","hentry","category-asterisk","category-goautodial","category-vicidial"],"_links":{"self":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/241","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/comments?post=241"}],"version-history":[{"count":1,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/241\/revisions"}],"predecessor-version":[{"id":242,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/posts\/241\/revisions\/242"}],"wp:attachment":[{"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/media?parent=241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/categories?post=241"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/symbioticindia.in\/docu\/wp-json\/wp\/v2\/tags?post=241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}