MySQL - Explain the concept of "mysqlcheck" command-line interface

Explain the concept of "mysqlcheck" command-line interface.

Mysqlcheck is used for Admin’s to check and repair the mysql tables.

Following are the options:-

1. "mysqlcheck databaseName tableName" - Checks the specified table in the specified database.

2. "mysqlcheck databaseName" - Checks all tables in the specified database.

3. "mysqlcheck --all-databases" - Checks all tables in all databases.

4. "mysqlcheck --analyze databaseName tableName" - Analyzes the specified table in the specified database.

5. "mysqlcheck --repair databaseName tableName" - Repairs the specified table in the specified database.
MySQL - What Is "mysqladmin"?
What is mysqladmin? - Mysqlcheck is used to perform administrative tasks.......
MySQL - Purpose of "mysqldump" command-line interface
Purpose of mysqldump command-line interface - Mysqldump is used by administrators or end users to export data from the server to files.......
MySQL - What is "mysqlshow"?
What is mysqlshow? - Mysqlshow is typically used by end users to see information on tables and columns......
Post your comment

Related Content

Follow us

▲