Friday, October 22, 2010

mysql check and repair

1.mysqlcheck databaseName tableName 

            Checks the specified table in the specified database. 

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

3.mysqlcheck -A  

            Checks all tables in all databases. 

4.mysqlcheck -a databaseName tableName 

            Analyzes the specified table in the specified database. 

5.mysqlcheck -r databaseName tableName 

          Repairs the specified table in the specified database.

6.mysqlcheck -r databaseName 

         Checks all tables in the specified database. 

7.mysqlcheck -r 

         Repair all Mysql databases

No comments:

Post a Comment