How to check for corrupted databases

Introduction

This article provides the procedure to use the mysqlcheck utility to check your databases for corruption.

Procedure

1. Access the server's command line as the 'root' user via SSH or "Terminal" in WHM.
2. Run mysqlcheck and pipe the output to grep to display only corrupt databases.

   mysqlcheck -cA | grep -v OK