Using mysqlcheck in MySql

mysqlcheck is a command-line interface for administrators to check and repair tables. Here are some 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.
Share Article/Example:
  • DotNetKicks
  • DZone
  • StumbleUpon
  • Print
  • Add to favorites
  • Digg
  • del.icio.us
  • Twitter
  • Facebook
  • LinkedIn
  • Posterous
  • Slashdot

 

 
eXTReMe Tracker