How do I check for corrupted databases via SSH or the command line?

Question

How do I check for corrupted databases via SSH or the command line?

Answer

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