What Is "mysqlcheck"

Q

What Is "mysqlcheck"? - MySQL FAQs - Administrator Tools for Managing MySQL Server

✍: 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.

2007-05-11, 4901👍, 0💬