check_mysql has determined that there are corrupted database tables

Discussions related with hosting control panels used, which include cPanel, Plesk, Directadmin etc..

Moderator: Staff

Post Reply
chris ben
Posts: 0
Joined: Fri Sep 16, 2016 10:09 am

check_mysql has determined that there are corrupted database tables

Post by chris ben »

I am getting the below alert from the server. Please help.

check_mysql has determined that there are corrupted database tables
cPanel & WHM has determined that the following database tables are corrupt:

Database Error
eximstats /usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect


Martin
Posts: 36
Joined: Fri Sep 16, 2016 10:34 am

Re: check_mysql has determined that there are corrupted database tables

Post by Martin »

Login to server via SSH and run the below command to repair the db

mysqlcheck -r eximstats

mysqlcheck -r -A (to repair all dbs)

=============================
Martin
Linux Support Engineer.
Nixtree Solutions
Managed Full Server Backups
https://www.nixtree.com/managed-backups.php
Follow us on : https://twitter.com/nixtree


If you are looking for assistance in server management, please get in touch with our support.
Post Reply