MySQL installation directory bin below executable program commands in detail

innochecksum:--offline InnoDB data file checksum check

Msql2mysql: Used to convert an app written by mSQL to MySQL.

Myisamchk:myisam the integrity of the table and fix the detected errors.

Myisam_ftdump: After you create a full-text index, you can use Myisam_ftdump to view the contents of the index under the command line: Myisam_ftdump <table_name> <index_num>

Myisamlog: Display MyISAM log file contents

Myisampack: Generate compressed, read-only MyISAM table related articles recommended compression MySQL

My_print_defaults: Output Default parameters

SQL interpreter for Mysql:mysql. You can execute SQL here, ending with a semicolon or \g.

Mysqlaccess: Manages the user's interface as a shortcut to the SQL Grant command.

Mysqladmin:mysql the Management interface program.

Mysqlbinlog: Generate bin Log

Mysqlbug:mysqlbug's report

Mysqlcheck: Data integrity Verification tool similar to Myisamchk, the main difference is that this tool can be used in MySQL runtime

A relatively simple test framework for MYSQL_CLIENT_TEST:C languages,

Mysql_config: View MySQL compilation parameters

Mysql_convert_table_format: Conversion table's storage engine

Mysqld_multi: A mysqld process that can manage multiple frames to listen to different UNIX socket files and TCP/IP port connections

Mysqld_safe: Server Process Manager. Used to start the MYSQLD server process and restart when it crashes.

Mysqldump: Dumps the State or database collection of the MySQL database to a text file so that the database can be recovered later

Mysqldumpslow:mysql comes with a tool to view slow logs

Mysql_find_rows: Reads a file that contains a SQL statement and extracts a statement that matches a given regular expression

Mysql_fix_extensions: Will extend the MyISAM table (ISAM) Table file in canonical form

Mysql_fix_privilege_tables, is a MySQL command, is to resolve issues in the privilege escalation

Mysqlhotcopy: is a Perl script that was originally written and provided by Tim Bunce. It uses lock TABLES, FLUSH TABLES, and CP or SCP to quickly back up the database

A very effective tool for loading (or importing) data from Mysqlimport:mysql

MYSQL_INSTALL_DB: The purpose of the script is to generate a new MySQL authorization form

Mysql_secure_installation: Support for improved MySQL security

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

Mysql_show:show tables or show tables from database_name; show databases; such as

Mysqlsla: There is a stress test tool

Mysqltest:mysql test suite is a powerful set of testers for the mass launch of MySQL AB.

Mysqltest_embedded: Similar to Mysqltest, but an embedded server that is built with support for LIBMYSQLD.

Mysql_tzinfo_to_sql: Loading the time zone table in the MySQL database

Mysql_upgrade: Upgrading MySQL

Mysql_waitpid: Ends with a stop signal and a wait process

Mysql_zap: Kills a process that matches a pattern

Perror: is a useful tool for MySQL to help users find error messages

Replace: string Substitution tool

RESOLVEIP: The host name of the utility resolves to an IP address

Resolve_stack_dump: Fixed a digital stack dump symbol

MySQL installation directory bin below executable program commands in detail