check_mysql has determined that there are corrupted database tables

Linux/31 Dec, 16/1419/0
Linux

check_mysql has determined that there are corrupted database tables

 

I received the below email from my WHM server.

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

Database Error
munin_innodb /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
leechprotect /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
cphulkd /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
modsec /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
roundcube /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
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
horde /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
whmxfer /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
mysql /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

We recommend that you repair these tables with WHM’s Repair a MySQL/MariaDB Database interface at: https://server.example.com:2087/scripts/repairmysqllist If the repair fails, contact cPanel Support for further assistance.

Corrupt Database Tables” notifications are currently configured to have an importance of “High”. You can change the importance or disable this type of notification in WHM’s Contact Manager
=================
 
check_mysql-corrupted-database
 
 
FIX:

Error shows that some of the mysQL database tables on your server is crashed and it should be repaired. Do the below steps to repair the corrupted database tables.

1. Log into your server via SSH as root user

2. Run the below command to repair the database

mysqlcheck -r leechprotect
mysqlcheck -r roundcube

The above command will repair a single database.

3. Run the below command to repair all databases on your server

mysqlcheck -r -A

Leave a Reply