Using MySqlCheck

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

One such tool is mysqlcheck

Usage:

[[email protected]]# 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            OKDatabaseName.LeaveDetails         OK 
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: