dcsimg
 

Tip: Using MySqlCheck

Tuesday Aug 28th 2018 by Sridhar M S

Learn more about this MySQL utility that provides for verifying and taking corrective actions in case of failures.

MySQL provides many utilities for verifying and taking corrective actions in case of failures.

One such tool is mysqlcheck

Usage:

[root@mypc]# mysqlcheck -h -u -p --analyze --databases ;

The above command with option --analyze will analyze and share the details.

Output: (Considering the table names to be Employee, LeaveDetails)
DatabaseName.Employee            OK
DatabaseName.LeaveDetails         OK 

 

Visit the DevX Tip Bank

 

Home
Mobile Site | Full Site