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

Let me give you a brief account of which commands can be used to display parameter settings using mysqladmin. Have you known about similar topics before? If you are interested, let's take a look at this article. I believe it is more or less helpful for you to read which commands can display parameter settings using mysqladmin.

Use the mysqladmin command

When using the mysqladmin command, the following command displays parameter settings.

Mysqladmin-p variables | grep log_queries_not_using_indexes

The command to set the root password is as follows.

Mysqladmin-u root-p password "new password"

The following command displays the state variable, and the-r parameter is generally used to display the increment value during the execution of the command.

Mysqladmin extended-status-uroot-r-I 10

-r: displays the difference between the current state variable and the last run command state variable

-I: the interval between repeated execution of the command.

The following command displays the currently connected thread.

Mysqladmin-uroot-pnemo1234admin processlist

The following command can be used to shut down the database.

Mysqladmin shutdown

Use the mysqldump command

Backup database

Mysqldump-uroot-- hex-blob db_name > db_name.sql

The commands to add compression are as follows

Mysqldump-uroot-- hex-blob db_name > db_name.sql.gz

You can also use the following mysql command to recover the data.

Mysql < db_name.sql

What do you think of the use of mysqladmin commands to display parameter settings for this article, and whether it has gained anything? If you want to know more about it, you can continue to follow our industry information section.

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.