Using MySqlCheck
August 28, 2018
2:08 pm
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