dcsimg
 

Submitted by: M S Sridhar(sridhar.ms@gmail.com)

Tuesday Aug 28th 2018 by M S Sridhar

Language: SQL, Expertise: Intermediate - 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 
Home
Mobile Site | Full Site
Copyright 2018 © QuinStreet Inc. All Rights Reserved