Shulou(Shulou.com)06/02 Report--

This article will explain in detail about the use of linux mysqlcheck command to check and repair MyISAM table, Xiaobian think quite practical, so share to everyone as a reference, I hope you can read this article after harvest.

Use the mysqlcheck command to check and repair MyISAM tables. It can optimize and analyze tables. mysqlcheck functions like myisamchk, but works differently. The main difference is that mysqlcheck must be used when the mysql server is running, whereas myisamchk applies when the server is not running. The advantage of using mysqlcheck is that you do not need to stop the server to check or repair tables.

Syntax format: mysqlcheck [parameter] [database] [table]

Common parameters:

Reference Example

Check and repair all tables in database www:

[root@linuxcool ~]# mysqlcheck www

Check and repair table1 in database www:

[root@linuxcool ~]# mysqlcheck www table1

mysqlcheck operation on mysql library:

mysqlcheck mysql -uroot -p about using linux mysqlcheck command to check and repair MyISAM table shared here, I hope the above content can be of some help to everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.