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

Below, I would like to tell you briefly about the detailed installation method of executable program commands under the directory bin in mysql. Have you known about similar topics before? If you are interested, let's take a look at this article. I believe that the detailed installation method of the executable program commands under the directory bin in mysql will help you more or less.

Innochecksum:-- offline innodb data file checksum check

Msql2mysql: used to convert applications written by mSQL into MySQL.

Integrity of the myisamchk:MyISAM table and fix detected errors.

Myisam_ftdump: after creating a full-text index, you can use myisam_ftdump to view the contents of the index under the command line: myisam_ftdump

Myisamlog: displaying the contents of the MyISAM log file

Myisampack: articles related to generating compressed, read-only MyISAM tables recommend compressing mysql

My_print_defaults: output default parameter

Mysql:MySQL 's SQL interpreter. You can execute SQL here, ending with a semicolon or\ g.

Mysqlaccess: the interface for managing users, which can be seen as a shortcut to SQL's GRANT command.

The management interface program of mysqladmin:mysql.

Mysqlbinlog: generate bin logs

Mysqlbug: report of mysqlbug

Mysqlcheck: a data integrity verification tool that is very similar to myisamchk, except that it can be used when MySQL is running

A relatively simple testing framework for mysql_client_test:c language

Mysql_config: viewing mysql compilation parameters

Mysql_convert_table_format: storage engine for converting tables

Mysqld_multi: a mysqld process that can manage connections between multiple frames listening to different Unix socket files and TCP/IP ports

Mysqld_safe: CVM process manager. It is used to start the mysqld CVM process and restart it when it crashes.

Mysqldump: dump the state or database collection of the MySQL database to a text file so that the database can be restored later

Mysqldumpslow:mysql comes with a tool to view slow logs.

Mysql_find_rows: reads a file that contains SQL statements and extracts statements that match a given regular expression

Mysql_fix_extensions: the MyISAM (ISAM) table file will be extended in a canonical form

Mysql_fix_privilege_tables: it is a command under mysql to solve the problem of privilege upgrade.

Mysqlhotcopy: is a Perl script originally written and provided by Tim Bunce. It uses LOCK TABLES, FLUSH TABLES, and cp or scp to quickly back up the database

Mysqlimport:mysql is a very effective tool for loading (or importing) data.

Mysql_install_db: the purpose of the script is to generate a new MySQL authorization table

Mysql_secure_installation: support to improve the security of mysql

Mysql_setpermission: is a Perl script originally contributed by Luuk de Boer. It sets permissions in the MySQL authorization table interactively

Mysql_show:show tables or show tables from database_name; show databases;, etc.

Mysqlsla: there is a stress testing tool

Mysqltest:MySQL Test Suite is a set of powerful testers launched by MySQL AB for the public.

Mysqltest_embedded: similar to mysqltest, but building an embedded CVM that supports libmysqld.

Mysql_tzinfo_to_sql: in the mysql database that loads the time zone table

Mysql_upgrade: upgrading mysql

Mysql_waitpid: ends with the process of stopping the signal and waiting

Mysql_zap: kills a process that matches a pattern

Perror: MYSQL is a very useful tool, it can help users find error messages

Replace: string replacement tool

Resolveip: the hostname of the utility resolves to an IP address

Resolve_stack_dump: resolved numeric stack dump symbols

What do you think of the detailed installation method of executable program commands under the directory bin in mysql? what do you think of this article? 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.