Shulou(Shulou.com)05/31 Report--

This article mainly introduces the use of MySQL database mysqlcheck, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

The knowledge about the use of MySQL database mysqlcheck is the main content of this article. We all know that mysqlcheck comes with mysql that can check and repair MyISAM tables, and it can also optimize and analyze tables. The function of mysqlcheck is similar to myisamchk, but its work is different. The following editor to explain the MySQL database mysqlcheck how to use?

How to use MySQL Database mysqlcheck

The main difference is that mysqlcheck must be used when the mysqld server is running, while myisamchk is applied when the server is not running. The advantage of using mysqlcheck is that there is no need to stop the server to check or repair the table. Failure to repair with myisamchk is irreversible.

1. If you need to check and repair all database tables, you can use:

# mysqlcheck-A-o-r-p#Enterpassword:database1OKdatabase2OK

two。 If you need to repair the specified database with

# mysqlcheck-A-o-rDatabase_NAME-p

How to use MySQL Database mysqlcheck

3. If you fix it with a different user name

# mysqlcheck-A-o-r-p-uadmin#Enterpassword:database1OKdatabase2OK

Where admin is the specified mysql user account.

4. If you use the specified mysql.sock to enter the database and repair

# mysqlcheck-A-o-r-p-S/tmp/mysql.sock#Enterpassword:database1OKdatabase2OK

Here / tmp/mysql.sock is the path where the specified mysql.sock is stored.

Thank you for reading this article carefully. I hope the article "how to use MySQL Database mysqlcheck" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.