Overview of MySQL Programs A client that imports text files into their respective tables using  LOAD DATA . See Section 4.5.5, “mysqlimport — A Data Import Program” . A client that dumps a MySQL database into a file as SQL. See Section 4.5.6, “mysqlpump — A Database Backup Program” . MySQL Shell is an advanced client and code editor for MySQL Server. See MySQL Shell 8.0. In addition to the provided SQL functionality, similar to  mysql , MySQL Shell provides scripting capabilities for JavaScript and Python and includes APIs for working with MySQL. X DevAPI enables you to work with both relational and document data, see Chapter 20,  Using MySQL as a Document Store . AdminAPI enables you to work with InnoDB Cluster, see Using MySQL AdminAPI. A client that displays information about databases, tables, columns, and indexes. See Section 4.5.7, “mysqlshow — Display Database, Table, and Column Information” . A client that is designed to emulate client load for a MySQL server and report the timing of each stage. It works as if multiple clients are accessing the server. See Section 4.5.8, “mysqlslap — A Load Emulation Client” . MySQL administrative and utility programs: An offline  InnoDB  offline file checksum utility. See Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility” . A utility that displays information about full-text indexes in  MyISAM  tables. See Section 4.6.3, “myisam_ftdump — Display Full-Text Index information” . A utility to describe, check, optimize, and repair  MyISAM  tables. See Section 4.6.4, “myisamchk — MyISAM Table-Maintenance Utility” . A utility that processes the contents of a  MyISAM  log file. See Section 4.6.5, “myisamlog — Display MyISAM Log File Contents” . A utility that compresses  MyISAM  tables to produce smaller read-only tables. See Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables” . A utility that enables you to store authentication credentials in a secure, encrypted login path file named .mylogin.cnf . See Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility” . 340 •  mysql_config_editor •  myisampack •  myisamlog •  myisamchk •  myisam_ftdump •  innochecksum •  mysqlslap •  mysqlshow •  mysqlsh •  mysqlpump