Teacher SiliconIndia replied to prabeen patraMonday, November 23, 2009
Hi Prabeen,
"mysqlcheck" is a command-line interface for administrators to check and repair tables. Here are some sample commands supported by "mysqlcheck":
"mysqlcheck databaseName tableName" - Checks the specified table in the specified database.
"mysqlcheck databaseName" - Checks all tables in the specified database.
"mysqlcheck --all-databases" - Checks all tables in all databases.
"mysqlcheck --analyze databaseName tableName" - Analyzes the specified table in the specified database.
"mysqlcheck --repair databaseName tableName" - Repairs the specified table in the specified database.