What Is "mysqlcheck" Command in MySQL

Q

What Is "mysqlcheck" in MySQL?

✍: FYIcenter.com

A

"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.

To know about "mysqlcheck", read other parts of this FAQ collection.

 

Administrator Tools for Managing MySQL Server

⇒⇒MySQL Database Tutorials

2016-10-16, 209👍, 0💬