The mysqlcheck utility is useful for validating the integrity of SQL databases.
On both Fedora and CentOS, this utility can be found in /usr/bin
The physical databases are found in /var/lib/mysql
To check the integrity of a database, run the command shown below:
$ mysqlcheck -u <db_user> -B <db_name> -p<password>
The login credentials can be found in /etc/passwd, and database specific login credentials are known only to NeatClubs top level administrators and are stored in our central site summaries
(some information in the screenshot below is removed for security reasons)
