Chapter 4 MySQL Programs第4章 MySQL程序

Table of Contents目录

4.1 Overview of MySQL ProgramsMySQL程序概述
4.2 Using MySQL Programs使用MySQL程序
4.2.1 Invoking MySQL Programs调用MySQL程序
4.2.2 Specifying Program Options指定程序选项
4.2.3 Command Options for Connecting to the Server用于连接到服务器的命令选项
4.2.4 Connecting to the MySQL Server Using Command Options使用命令选项连接到MySQL服务器
4.2.5 Connecting to the Server Using URI-Like Strings or Key-Value Pairs使用类似URI的字符串或键值对连接到服务器
4.2.6 Connecting to the Server Using DNS SRV Records使用DNS SRV记录连接到服务器
4.2.7 Connection Transport Protocols连接传输协议
4.2.8 Connection Compression Control连接压缩控制
4.2.9 Setting Environment Variables设置环境变量
4.3 Server and Server-Startup Programs服务器和服务器启动程序
4.3.1 mysqld — The MySQL ServerMySQL服务器
4.3.2 mysqld_safe — MySQL Server Startup ScriptMySQL服务器启动脚本
4.3.3 mysql.server — MySQL Server Startup ScriptMySQL服务器启动脚本
4.3.4 mysqld_multi — Manage Multiple MySQL Servers管理多个MySQL服务器
4.4 Installation-Related Programs安装相关程序
4.4.1 comp_err — Compile MySQL Error Message File编译MySQL错误消息文件
4.4.2 mysql_secure_installation — Improve MySQL Installation Security提高MySQL安装安全性
4.4.3 mysql_ssl_rsa_setup — Create SSL/RSA Files创建SSL/RSA文件
4.4.4 mysql_tzinfo_to_sql — Load the Time Zone Tables加载时区表
4.4.5 mysql_upgrade — Check and Upgrade MySQL Tables检查并升级MySQL表
4.5 Client Programs客户端程序
4.5.1 mysql — The MySQL Command-Line ClientMySQL命令行客户端
4.5.2 mysqladmin — A MySQL Server Administration ProgramMySQL服务器管理程序
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 mysqlpump — A Database Backup Program数据库备份程序
4.5.7 mysqlshow — Display Database, Table, and Column Information显示数据库、表和列信息
4.5.8 mysqlslap — A Load Emulation Client负载模拟客户端
4.6 Administrative and Utility Programs行政和公用事业计划
4.6.1 ibd2sdi — InnoDB Tablespace SDI Extraction UtilityInnoDB表空间SDI提取实用程序
4.6.2 innochecksum — Offline InnoDB File Checksum Utility脱机InnoDB文件校验和实用程序
4.6.3 myisam_ftdump — Display Full-Text Index information显示全文索引信息
4.6.4 myisamchk — MyISAM Table-Maintenance UtilityMyISAM表格维护实用程序
4.6.5 myisamlog — Display MyISAM Log File Contents显示MyISAM日志文件内容
4.6.6 myisampack — Generate Compressed, Read-Only MyISAM Tables生成压缩的只读MyISAM
4.6.7 mysql_config_editor — MySQL Configuration UtilityMySQL配置实用程序
4.6.8 mysql_migrate_keyring — Keyring Key Migration Utility密钥环密钥迁移实用程序
4.6.9 mysqlbinlog — Utility for Processing Binary Log Files用于处理二进制日志文件的实用程序
4.6.10 mysqldumpslow — Summarize Slow Query Log Files汇总慢速查询日志文件
4.7 Program Development Utilities程序开发实用程序
4.7.1 mysql_config — Display Options for Compiling Clients用于编译客户端的显示选项
4.7.2 my_print_defaults — Display Options from Option Files显示选项文件中的选项
4.8 Miscellaneous Programs杂项计划
4.8.1 lz4_decompress — Decompress mysqlpump LZ4-Compressed Output解压泵LZ4压缩输出
4.8.2 perror — Display MySQL Error Message Information显示MySQL错误消息信息
4.8.3 zlib_decompress — Decompress mysqlpump ZLIB-Compressed Output解压缩mysqlpump ZLIB压缩输出
4.9 Environment Variables环境变量
4.10 Unix Signal Handling in MySQLMySQL中的Unix信号处理

This chapter provides a brief overview of the MySQL command-line programs provided by Oracle Corporation. 本章简要概述了甲骨文集团提供的MySQL命令行程序。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.最后,本章对各个程序进行了更详细的描述,包括它们识别的选项。

4.1 Overview of MySQL Programs
4.2 Using MySQL Programs
4.3 Server and Server-Startup Programs
4.4 Installation-Related Programs
4.5 Client Programs
4.6 Administrative and Utility Programs
4.7 Program Development Utilities
4.8 Miscellaneous Programs
4.9 Environment Variables
4.10 Unix Signal Handling in MySQL