mysqlcheck Utility
mysqlcheck is a table maintenance and repair program for MySQL.
The mysqlcheck client checks, repairs, optimizes, and analyzes tables. It is available as of MySQL 3.23.38. mysqlcheck is
similar in function to myisamchk, but works differently. The main operational difference is that mysqlcheck must be used when
the mysqld server is running, whereas myisamchk should be used when it is not. The benefit of using mysqlcheck is that you do
not have to stop MySQL to check or repair your tables.
Usage
To use mysqlcheck, connect to the VPS v2/v3 server via SSH,
su to root, and run a command similar to the following:
# mysqlcheck -u root -p --all-databases
This will check all databases. You can specify a single database if you do not want to check all by using a command similar to
the following:
# mysqlcheck -u root -p db_name
Replace db_name with the name of the database you want to check. Also omit the -p option if there is no password currently
setup for the MySQL root login. There are many options that can be used with the mysqlcheck command. Please see the
documentation section for more information.
Documentation
|
