The world's most popular open source database
MySQL 5.6 Reference Manual :: 4 MySQL Programs
Section Navigation [Toggle]
- Preface and Legal Notices
- 1 General Information
- 2 Installing and Upgrading MySQL
- 3 Tutorial
- 4 MySQL Programs
- 5 MySQL Server Administration
- 6 Security
- 7 Backup and Recovery
- 8 Optimization
- 9 Language Structure
- 10 Globalization
- 11 Data Types
- 12 Functions and Operators
- 13 SQL Statement Syntax
- 14 The InnoDB Storage Engine
- 15 Alternative Storage Engines
- 16 High Availability and Scalability
- 17 Replication
- 18 MySQL Cluster NDB 7.3 and MySQL Cluster NDB 7.4
- 19 Partitioning
- 20 Stored Programs and Views
- 21 INFORMATION_SCHEMA Tables
- 22 MySQL Performance Schema
- 23 Connectors and APIs
- 24 Extending MySQL
- 25 MySQL Enterprise Edition
- 26 MySQL Workbench
- A MySQL 5.6 Frequently Asked Questions
- B Errors, Error Codes, and Common Problems
- C MySQL Release Notes
- D Restrictions and Limits
- MySQL Glossary
- E Licenses for Third-Party Components
- General Index
- C Function Index
- Command Index
- Function Index
- INFORMATION_SCHEMA Index
- Join Types Index
- Operator Index
- Option Index
- Privileges Index
- SQL Modes Index
- Statement/Syntax Index
- Status Variable Index
- System Variable Index
Table of Contents [+/-]
- 4.1 Overview of MySQL Programs
- 4.2 Using MySQL Programs [+/-]
- 4.2.1 Invoking MySQL Programs
- 4.2.2 Connecting to the MySQL Server
- 4.2.3 Specifying Program Options
- 4.2.4 Using Options on the Command Line
- 4.2.5 Program Option Modifiers
- 4.2.6 Using Option Files
- 4.2.7 Command-Line Options that Affect Option-File Handling
- 4.2.8 Using Options to Set Program Variables
- 4.2.9 Option Defaults, Options Expecting Values, and the = Sign
- 4.2.10 Setting Environment Variables
- 4.3 MySQL Server and Server-Startup Programs [+/-]
- 4.4 MySQL Installation-Related Programs [+/-]
- 4.4.1 comp_err — Compile MySQL Error Message File
- 4.4.2 mysqlbug — Generate Bug Report
- 4.4.3 mysql_install_db — Initialize MySQL Data Directory
- 4.4.4 mysql_plugin — Configure MySQL Server Plugins
- 4.4.5 mysql_secure_installation — Improve MySQL Installation Security
- 4.4.6 mysql_tzinfo_to_sql — Load the Time Zone Tables
- 4.4.7 mysql_upgrade — Check and Upgrade MySQL Tables
- 4.5 MySQL Client Programs [+/-]
- 4.5.1 mysql — The MySQL Command-Line Tool
- 4.5.2 mysqladmin — Client for Administering a MySQL Server
- 4.5.3 mysqlcheck — A Table Maintenance Program
- 4.5.4 mysqldump — A Database Backup Program
- 4.5.5 mysqlimport — A Data Import Program
- 4.5.6 mysqlshow — Display Database, Table, and Column Information
- 4.5.7 mysqlslap — Load Emulation Client
- 4.6 MySQL Administrative and Utility Programs [+/-]
- 4.6.1 innochecksum — Offline InnoDB File Checksum Utility
- 4.6.2 myisam_ftdump — Display Full-Text Index information
- 4.6.3 myisamchk — MyISAM Table-Maintenance Utility
- 4.6.4 myisamlog — Display MyISAM Log File Contents
- 4.6.5 myisampack — Generate Compressed, Read-Only MyISAM Tables
- 4.6.6 mysql_config_editor — MySQL Configuration Utility
- 4.6.7 mysqlaccess — Client for Checking Access Privileges
- 4.6.8 mysqlbinlog — Utility for Processing Binary Log Files
- 4.6.9 mysqldumpslow — Summarize Slow Query Log Files
- 4.6.10 mysqlhotcopy — A Database Backup Program
- 4.6.11 mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
- 4.6.12 mysql_find_rows — Extract SQL Statements from Files
- 4.6.13 mysql_fix_extensions — Normalize Table File Name Extensions
- 4.6.14 mysql_setpermission — Interactively Set Permissions in Grant Tables
- 4.6.15 mysql_waitpid — Kill Process and Wait for Its Termination
- 4.6.16 mysql_zap — Kill Processes That Match a Pattern
- 4.7 MySQL Program Development Utilities [+/-]
- 4.8 Miscellaneous Programs [+/-]
This chapter provides a brief overview of the MySQL command-line programs provided by Oracle Corporation. It also discusses the general syntax for specifying options when you run these programs. Most programs have options that are specific to their own operation, but the option syntax is similar for all of them. Finally, the chapter provides more detailed descriptions of individual programs, including which options they recognize.
User Comments