Option Index

Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y

Symbols

[index top]

--

Section 1.8.2.5, “'--' as the Start of a Comment”
Section 4.8.2, “replace — A String-Replacement Utility”

-#

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.8.2, “replace — A String-Replacement Utility”
Section 5.1.3, “Server Command Options”
Section 23.4.3, “The DBUG Package”

/opt/mysql/server-

Section 2.5.4, “Installing MySQL on Linux Using Debian Packages”

-1

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

-?

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.8.2, “replace — A String-Replacement Utility”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 5.1.3, “Server Command Options”
Section 4.2.3.1, “Using Options on the Command Line”

A

[index top]

-A

Section 4.5.1.1, “mysql Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.3.4, “Other myisamchk Options”

-a

Section 7.6.4, “MyISAM Table Optimization”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.6.3.4, “Other myisamchk Options”

--abort-slave-event-count

Section 17.1.4.3, “Replication Slave Options and Variables”

--add-drop-database

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 7.4.1, “Dumping Data in SQL Format with mysqldump

--add-drop-table

Section 4.5.4, “mysqldump — A Database Backup Program”

--add-drop-trigger

Section 4.5.4, “mysqldump — A Database Backup Program”

--add-locks

Section 4.5.4, “mysqldump — A Database Backup Program”

--addtodest

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--all

Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”

--all-databases

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 7.4.1, “Dumping Data in SQL Format with mysqldump
Section 9.2.3, “Mapping of Identifiers to File Names”
Section 2.10.4, “Rebuilding or Repairing Tables or Indexes”
Section 7.4.2, “Reloading SQL-Format Backups”
Section 2.10.1.2, “Upgrading from MySQL 5.6 to 5.7”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”

--all-in-1

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--all-tablespaces

Section 4.5.4, “mysqldump — A Database Backup Program”

--allow-keywords

Section 4.5.4, “mysqldump — A Database Backup Program”

--allow-mismatches

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”

--allow-suspicious-udfs

Section 5.1.3, “Server Command Options”
Section 23.3.2.6, “User-Defined Function Security Precautions”

--allowold

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--analyze

Section 4.6.3.1, “myisamchk General Options”
Section 7.6.4, “MyISAM Table Optimization”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.6.3.4, “Other myisamchk Options”

--ansi

Section 1.8, “MySQL Standards Compliance”
Section 5.1.3, “Server Command Options”

--apply-slave-statements

Section 4.5.4, “mysqldump — A Database Backup Program”

--audit-log

Section 6.3.13.5, “Audit Log Plugin Options and Variables”
Section 6.3.13.1, “Installing the Audit Log Plugin”

--auto-generate-sql

Section 4.5.7, “mysqlslap — Load Emulation Client”

--auto-generate-sql-add-autoincrement

Section 4.5.7, “mysqlslap — Load Emulation Client”

--auto-generate-sql-execute-number

Section 4.5.7, “mysqlslap — Load Emulation Client”

--auto-generate-sql-guid-primary

Section 4.5.7, “mysqlslap — Load Emulation Client”

--auto-generate-sql-load-type

Section 4.5.7, “mysqlslap — Load Emulation Client”

--auto-generate-sql-secondary-indexes

Section 4.5.7, “mysqlslap — Load Emulation Client”

--auto-generate-sql-unique-query-number

Section 4.5.7, “mysqlslap — Load Emulation Client”

--auto-generate-sql-unique-write-number

Section 4.5.7, “mysqlslap — Load Emulation Client”

--auto-generate-sql-write-number

Section 4.5.7, “mysqlslap — Load Emulation Client”

--auto-rehash

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”
Section 14.13.24, “Configuring Non-Persistent Optimizer Statistics Parameters”

--auto-repair

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--auto-vertical-output

Section 4.5.1.1, “mysql Options”

--autocommit

Section 5.1.4, “Server System Variables”

B

[index top]

-B

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”

-b

Section 4.5.1.1, “mysql Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.6.3.4, “Other myisamchk Options”
Section 5.1.3, “Server Command Options”

--back_log

Section 2.6, “Installing MySQL on Solaris and OpenSolaris”

--backup

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”

--base64-output

Section 4.6.7.2, “mysqlbinlog Row Event Display”
Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 17.1.3.1, “GTID Concepts”
Section 17.1.2.2, “Usage of Row-Based Logging and Replication”

--basedir

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 2.9.1, “Postinstallation Procedures for Unix-like Systems”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 2.9.1.3, “Starting and Troubleshooting the MySQL Server”
Section 1.4, “What Is New in MySQL 5.7”

basedir

Section 2.3.5.2, “Creating an Option File”
Section 2.9.1.2, “Starting and Stopping MySQL Automatically”
Section 2.3.6, “Troubleshooting a Microsoft Windows MySQL Server Installation”

--batch

Section 4.5.1.3, “mysql Logging”
Section 4.5.1.1, “mysql Options”

--big-tables

Section 5.1.3, “Server Command Options”

--binary-mode

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--bind-address

Section 4.5.1.1, “mysql Options”
Section C.5.2.2, “Can't connect to [local] MySQL server
Section 6.2.7, “Causes of Access-Denied Errors”
Section 5.1.9.2, “Configuring the MySQL Server to Permit IPv6 Connections”
Section 5.1.9.4, “Connecting Using IPv6 Nonlocal Host Addresses”
Section 5.1.9.3, “Connecting Using the IPv6 Local Host Address”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 5.1.9, “IPv6 Support”
Section 5.1.9.5, “Obtaining an IPv6 Address from a Broker”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--binlog-checksum

Section 17.1.4.4, “Binary Logging Options and Variables”

--binlog-do-db

Section 17.1.4.4, “Binary Logging Options and Variables”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 17.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 17.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.2.4, “The Binary Log”

--binlog-format

Section 5.2.4.1, “Binary Logging Formats”
Section 17.1.4.4, “Binary Logging Options and Variables”
Section 5.1.3, “Server Command Options”
Section 5.2.4.2, “Setting The Binary Log Format”

--binlog-ignore-db

Section 17.1.4.4, “Binary Logging Options and Variables”
Section 17.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 17.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.2.4, “The Binary Log”

--binlog-row-event-max-size

Section 17.1.4.4, “Binary Logging Options and Variables”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.2.4.2, “Setting The Binary Log Format”

--binlog-rows-query-log-events

Section 17.1.4.4, “Binary Logging Options and Variables”

--binlog_format

Section 17.1.2.2, “Usage of Row-Based Logging and Replication”

--block-search

Section 4.6.3.4, “Other myisamchk Options”

--bootstrap

Section 5.1.3, “Server Command Options”

--builddir

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

C

[index top]

-C

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 5.1.3, “Server Command Options”

-c

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”

--cflags

Section 2.8.5, “Dealing with Problems Compiling MySQL”
Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

--character-set-client-handshake

Section 5.1.3, “Server Command Options”
Section 10.1.14.7.1, “The cp932 Character Set”

--character-set-filesystem

Section 5.1.3, “Server Command Options”

--character-set-server

Section 10.5, “Character Set Configuration”
Section 10.1.5, “Configuring the Character Set and Collation for Applications”
Section 17.4.1.3, “Replication and Character Sets”
Section 10.1.3.1, “Server Character Set and Collation”
Section 5.1.3, “Server Command Options”

--character-sets-dir

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section C.5.2.17, “Can't initialize character set
Section 10.5, “Character Set Configuration”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 5.1.3, “Server Command Options”

--character_set_server

Section 2.8.4, “MySQL Source-Configuration Options”

--charset

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

--check

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--check-only-changed

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--check-upgrade

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”

--checkpoint

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--chroot

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 5.1.3, “Server Command Options”

CMAKE_BUILD_TYPE

Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_C_FLAGS

Section 23.4.1.1, “Compiling MySQL for Debugging”
Section 2.8.5, “Dealing with Problems Compiling MySQL”
Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_C_FLAGS_build_type

Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_C_FLAGS_RELWITHDEBINFO

Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_CXX_FLAGS

Section 23.4.1.1, “Compiling MySQL for Debugging”
Section 2.8.5, “Dealing with Problems Compiling MySQL”
Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_CXX_FLAGS_build_type

Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_CXX_FLAGS_RELWITHDEBINFO

Section 2.8.4, “MySQL Source-Configuration Options”

CMAKE_INSTALL_PREFIX

Section 23.2.4.3, “Compiling and Installing Plugin Libraries”
Section 2.8.3, “Installing MySQL Using a Development Source Tree”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”

CMAKE_PREFIX_PATH

Section 2.8.4, “MySQL Source-Configuration Options”

--collation-server

Section 10.5, “Character Set Configuration”
Section 10.1.5, “Configuring the Character Set and Collation for Applications”
Section 17.4.1.3, “Replication and Character Sets”
Section 10.1.3.1, “Server Character Set and Collation”
Section 5.1.3, “Server Command Options”

--collation_server

Section 2.8.4, “MySQL Source-Configuration Options”

--column-names

Section 4.5.1.1, “mysql Options”
Section 4.2.3.2, “Program Option Modifiers”

--column-type-info

Section 4.5.1.1, “mysql Options”

--columns

Section 4.5.5, “mysqlimport — A Data Import Program”

--comments

Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”

--commit

Section 4.5.7, “mysqlslap — Load Emulation Client”

--comp

Section 4.2.3, “Specifying Program Options”
Section 1.4, “What Is New in MySQL 5.7”

--compact

Section 4.5.4, “mysqldump — A Database Backup Program”

--compatible

Section 4.5.4, “mysqldump — A Database Backup Program”

COMPILATION_COMMENT

Section 5.1.4, “Server System Variables”

--complete-insert

Section 4.5.4, “mysqldump — A Database Backup Program”

--compr

Section 4.2.3, “Specifying Program Options”
Section 1.4, “What Is New in MySQL 5.7”

--compress

Section 4.5.1.1, “mysql Options”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 6.3.11.1, “Basic SSL Concepts”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.2.3, “Specifying Program Options”
Section 1.4, “What Is New in MySQL 5.7”

--concurrency

Section 4.5.7, “mysqlslap — Load Emulation Client”

--config-file

Section 4.7.2, “my_print_defaults — Display Options from Option Files”

--connect-expired-password

Section 4.5.1.1, “mysql Options”

--console

Section 14.19, “InnoDB Troubleshooting”
Section 14.5.1, “Creating the InnoDB Tablespace”
Section 14.15.2, “Enabling InnoDB Monitors”
Section C.5.4.1.1, “Resetting the Root Password: Windows Systems”
Section 5.1.3, “Server Command Options”
Section 2.3.5.4, “Starting the Server for the First Time”
Section 5.2.2, “The Error Log”

--core-file

Section 23.4.1.4, “Debugging mysqld under gdb
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--core-file-size

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.1.3, “Server Command Options”

--correct-checksum

Section 4.6.3.3, “myisamchk Repair Options”

--count

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”

--create

Section 4.5.7, “mysqlslap — Load Emulation Client”

--create-options

Section 4.5.4, “mysqldump — A Database Backup Program”

--create-schema

Section 4.5.7, “mysqlslap — Load Emulation Client”

--cross-bootstrap

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

--csv

Section 4.5.7, “mysqlslap — Load Emulation Client”

--cxxflags

Section 2.8.5, “Dealing with Problems Compiling MySQL”
Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

D

[index top]

-D

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section C.5.2.17, “Can't initialize character set
Section 10.3, “Adding a Character Set”
Section 2.1.2.2, “Choosing a Distribution Format”
Section 23.4.1.1, “Compiling MySQL for Debugging”
Section 22.7.1, “Compiling Programs with libmysqld
Section 23.4.2, “Debugging a MySQL Client”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 2.8.2, “Installing MySQL Using a Standard Source Distribution”
Section 2.8.4, “MySQL Source-Configuration Options”
Chapter 18, Partitioning
Section 21.2.1, “Performance Schema Build Configuration”
Section 14.18.3.1, “Prerequisites for the InnoDB memcached Plugin”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 15.5, “The ARCHIVE Storage Engine”
Section 15.6, “The BLACKHOLE Storage Engine”
Section 15.9, “The EXAMPLE Storage Engine”
Section 15.8, “The FEDERATED Storage Engine”
Section 5.4, “Tracing mysqld Using DTrace”
Section C.5.4.2, “What to Do If MySQL Keeps Crashing”

-d

Section 4.6.3.1, “myisamchk General Options”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.6.3.4, “Other myisamchk Options”
Section 5.1.4, “Server System Variables”

--data-file-length

Section 4.6.3.3, “myisamchk Repair Options”

--database

Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--databases

Section 7.4.5.2, “Copy a Database from one Server to Another”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 7.4.1, “Dumping Data in SQL Format with mysqldump
Section 7.4.5.1, “Making a Copy of a Database”
Section 2.10.4, “Rebuilding or Repairing Tables or Indexes”
Section 7.4.2, “Reloading SQL-Format Backups”

--datadir

Section 2.3.5.2, “Creating an Option File”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 2.9.1, “Postinstallation Procedures for Unix-like Systems”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 5.3.1, “Setting Up Multiple Data Directories”
Section 2.9.1.3, “Starting and Troubleshooting the MySQL Server”
Section 4.2.3.3, “Using Option Files”
Section 1.4, “What Is New in MySQL 5.7”

datadir

Section 2.3.5.2, “Creating an Option File”
Section 2.4.1, “General Notes on Installing MySQL on Mac OS X”
Section 2.9.1.2, “Starting and Stopping MySQL Automatically”
Section 2.3.6, “Troubleshooting a Microsoft Windows MySQL Server Installation”
Section E.10.6, “Windows Platform Limitations”

--debug

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 23.4.1.1, “Compiling MySQL for Debugging”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 2.9.1.3, “Starting and Troubleshooting the MySQL Server”
Section 2.3.5.5, “Starting MySQL from the Windows Command Line”
Section 23.4.3, “The DBUG Package”

--debug-check

Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”

--debug-info

Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”

--debug-sync-timeout

Section 2.8.4, “MySQL Source-Configuration Options”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--default-auth

Section 4.5.1.1, “mysql Options”
Section 22.8.14, “C API Client Plugin Functions”
Section 23.2.4.2.3, “Client Plugin Descriptors”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 6.3.8, “Pluggable Authentication”
Section 6.3.9.2, “The Old Native Authentication Plugin”
Section 6.3.9.1, “The Native Authentication Plugin”
Section 23.2.4.9.3, “Using the Authentication Plugins”

--default-authentication-plugin

Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--default-character-set

Section 4.5.1.1, “mysql Options”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 10.5, “Character Set Configuration”
Section 10.1.5, “Configuring the Character Set and Collation for Applications”
Section 10.1.4, “Connection Character Sets and Collations”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.1.5, “Executing SQL Statements from a Text File”
Section 5.1.4, “Server System Variables”
Section 4.5.1.6.2, “Unicode Support on Windows”
Section 6.3.1, “User Names and Passwords”

--default-storage-engine

Section 14.12, “InnoDB Startup Options and System Variables”
Section 5.1.3, “Server Command Options”
Section 15.1, “Setting the Storage Engine”
Section 14.1.3, “Turning Off InnoDB”

default-storage-engine

Section 15.1, “Setting the Storage Engine”

--default-time-zone

Section 10.6, “MySQL Server Time Zone Support”
Section 17.4.1.30, “Replication and Time Zones”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--default-tmp-storage-engine

Section 14.12, “InnoDB Startup Options and System Variables”
Section 5.1.3, “Server Command Options”
Section 14.1.3, “Turning Off InnoDB”

--default.key_buffer_size

Section 5.1.5.1, “Structured System Variables”

DEFAULT_CHARSET

Section 10.1.5, “Configuring the Character Set and Collation for Applications”
Section 10.1.3.1, “Server Character Set and Collation”

DEFAULT_COLLATION

Section 10.1.5, “Configuring the Character Set and Collation for Applications”
Section 10.1.3.1, “Server Character Set and Collation”

--defaults-extra-file

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.2.3.4, “Command-Line Options that Affect Option-File Handling”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.1.3, “Server Command Options”
Section 4.2.3.3, “Using Option Files”

--defaults-file

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 14.3, “InnoDB Configuration”
Section 4.2.3.4, “Command-Line Options that Affect Option-File Handling”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 22.7.3, “Options with the Embedded Server”
Section C.5.4.1.1, “Resetting the Root Password: Windows Systems”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.3, “Server Command Options”
Section 5.3.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 5.3.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 2.3.5.7, “Starting MySQL as a Windows Service”

--defaults-group-suffix

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.2.3.4, “Command-Line Options that Affect Option-File Handling”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 2.11, “Environment Variables”
Section 5.1.3, “Server Command Options”

--delay-key-write

Section 15.2.1, “MyISAM Startup Options”
Section 8.10.5, “External Locking”
Section 5.1.3, “Server Command Options”
Section C.5.4.2, “What to Do If MySQL Keeps Crashing”

--delay_key_write

Section 5.1.5, “Using System Variables”

--delete

Section 4.5.5, “mysqlimport — A Data Import Program”

--delete-master-logs

Section 4.5.4, “mysqldump — A Database Backup Program”

--delimiter

Section 4.5.1.1, “mysql Options”
Section 4.5.7, “mysqlslap — Load Emulation Client”

--demangle

Section 23.4.1.5, “Using a Stack Trace”

--des-key-file

Section 13.7.6.3, “FLUSH Syntax”
Section 12.13, “Encryption and Compression Functions”
Section 5.1.3, “Server Command Options”

--description

Section 4.6.3.4, “Other myisamchk Options”

--detach

Section 4.5.7, “mysqlslap — Load Emulation Client”

--disable

Section 4.2.3.2, “Program Option Modifiers”

--disable-auto-rehash

Section 4.5.1.1, “mysql Options”
Section 14.13.24, “Configuring Non-Persistent Optimizer Statistics Parameters”

--disable-keys

Section 4.5.4, “mysqldump — A Database Backup Program”

--disable-log-bin

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--disable-named-commands

Section 4.5.1.1, “mysql Options”

--disable-plugin_name

Section 5.1.8.1, “Installing and Uninstalling Plugins”

--disable-ssl

Section 6.3.11.4, “SSL Command Options”
Section 6.3.11.3, “Using SSL Connections”

--disconnect-slave-event-count

Section 17.1.4.3, “Replication Slave Options and Variables”

--dryrun

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--dump

Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”

--dump-date

Section 4.5.4, “mysqldump — A Database Backup Program”

--dump-slave

Section 4.5.4, “mysqldump — A Database Backup Program”

E

[index top]

-E

Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.4, “mysqldump — A Database Backup Program”

-e

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 13.2.7, “LOAD XML Syntax”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 7.6.2, “How to Check MyISAM Tables for Errors”
Section 4.6.3.5, “Obtaining Table Information with myisamchk
Section 4.2.3.1, “Using Options on the Command Line”

--embedded

Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

--enable-cleartext-plugin

Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 6.3.9.5, “The Cleartext Client-Side Authentication Plugin”

--enable-named-pipe

Section C.5.2.2, “Can't connect to [local] MySQL server
Section 4.2.2, “Connecting to the MySQL Server”
Section 2.3.5.3, “Selecting a MySQL Server Type”
Section 5.1.3, “Server Command Options”

--enable-plugin_name

Section 5.1.8.1, “Installing and Uninstalling Plugins”

--end-page

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”

--enforce-gtid-consistency

Section 17.1.4.5, “Global Transaction ID Options and Variables”
Section 17.1.3.4, “Restrictions on Replication with GTIDs”
Section 17.1.3.2, “Setting Up Replication Using GTIDs”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”

--engine

Section 4.5.7, “mysqlslap — Load Emulation Client”

event-scheduler

Section 19.4.2, “Event Scheduler Configuration”

--event-scheduler

Section 19.4.2, “Event Scheduler Configuration”
Section 5.1.3, “Server Command Options”

--events

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 7.4.5.3, “Dumping Stored Programs”
Section 7.4.5.4, “Dumping Table Definitions and Content Separately”
Section 2.10.1.2, “Upgrading from MySQL 5.6 to 5.7”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”

--example

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--exclude-gtids

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--execute

Section 4.5.1.3, “mysql Logging”
Section 4.5.1.1, “mysql Options”
Section 4.2.3.1, “Using Options on the Command Line”

--exit-info

Section 5.1.3, “Server Command Options”

--extend-check

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.3.3, “myisamchk Repair Options”

--extended

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--extended-insert

Section 4.5.4, “mysqldump — A Database Backup Program”

--external-locking

Section 15.2.1, “MyISAM Startup Options”
Section 8.10.5, “External Locking”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 8.11.1, “System Factors and Startup Parameter Tuning”

--extra-file

Section 4.7.2, “my_print_defaults — Display Options from Option Files”

F

[index top]

-F

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.2, “mysql Commands”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”

-f

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 23.4.1.5, “Using a Stack Trace”

--fast

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--federated

Section 15.8, “The FEDERATED Storage Engine”

--fields-enclosed-by

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump

--fields-escaped-by

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump

--fields-optionally-enclosed-by

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump

--fields-terminated-by

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump

--fields-xxx

Section 4.5.4, “mysqldump — A Database Backup Program”

--fix-db-names

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--fix-table-names

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--flush

Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section C.5.4.2, “What to Do If MySQL Keeps Crashing”

--flush-logs

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 7.3.1, “Establishing a Backup Policy”
Section 5.2, “MySQL Server Logs”

--flush-privileges

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 2.10.1.2, “Upgrading from MySQL 5.6 to 5.7”

--flush_time

Section 23.1.1, “MySQL Threads”

--flushlog

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--force

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 23.1.2, “The MySQL Test Suite”
Section 3.5, “Using mysql in Batch Mode”

--force-if-open

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--force-read

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

G

[index top]

-G

Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”

-g

Section 23.4.1.1, “Compiling MySQL for Debugging”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”

--gdb

Section 23.4.1.4, “Debugging mysqld under gdb
Section 5.1.3, “Server Command Options”

--general-log

Section 5.1.3, “Server Command Options”

--general_log

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The General Query Log”

--general_log_file

Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The General Query Log”

--gtid-mode

Section 17.1.4.5, “Global Transaction ID Options and Variables”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.1.3.4, “Restrictions on Replication with GTIDs”
Section 17.1.3.2, “Setting Up Replication Using GTIDs”
Section 2.10.1, “Upgrading MySQL”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”

H

[index top]

-H

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”

-h

Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.2.1, “Invoking MySQL Programs”
Section 5.1.3, “Server Command Options”
Section 1.2, “Typographical and Syntax Conventions”
Section 4.2.3.1, “Using Options on the Command Line”

--header_file

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

--HELP

Section 4.6.3.1, “myisamchk General Options”

--help

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.1, “Overview of MySQL Programs”
Section 2.9.1, “Postinstallation Procedures for Unix-like Systems”
Section 5.1.3, “Server Command Options”
Section 2.9.1.3, “Starting and Troubleshooting the MySQL Server”
Section 8.11.2, “Tuning Server Parameters”
Chapter 3, Tutorial
Section 4.2.3.3, “Using Option Files”
Section 4.2.3.1, “Using Options on the Command Line”

--hex-blob

Section 4.5.4, “mysqldump — A Database Backup Program”

--hexdump

Section 4.6.7.1, “mysqlbinlog Hex Dump Format”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--histignore

Section 4.5.1.3, “mysql Logging”
Section 4.5.1.1, “mysql Options”
Section 1.4, “What Is New in MySQL 5.7”

--host

Section 4.5.1.1, “mysql Options”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 5.1.9.2, “Configuring the MySQL Server to Permit IPv6 Connections”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.2.3.6, “Option Defaults, Options Expecting Values, and the = Sign”
Section 5.1.3, “Server Command Options”
Section 1.2, “Typographical and Syntax Conventions”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 5.3.4, “Using Client Programs in a Multiple-Server Environment”
Section 4.2.3.3, “Using Option Files”
Section 4.2.3.1, “Using Options on the Command Line”

host

Section 4.5.1.1, “mysql Options”
Section 4.2.3.4, “Command-Line Options that Affect Option-File Handling”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.2.3.3, “Using Option Files”

--html

Section 4.5.1.1, “mysql Options”

I

[index top]

-I

Section 22.8.4.1, “Building C API Client Programs”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.8.2, “replace — A String-Replacement Utility”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”

-i

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 7.6.2, “How to Check MyISAM Tables for Errors”
Section 2.5.3, “Installing MySQL on Linux Using RPM Packages”
Section 23.4.1.3, “Using pdb to create a Windows crashdump”

--i-am-a-dummy

Section 4.5.1.1, “mysql Options”
Section 4.5.1.6.4, “Using the --safe-updates Option”

--idempotent

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--ignore

Section 4.5.5, “mysqlimport — A Data Import Program”

--ignore-builtin-innodb

Section 14.12, “InnoDB Startup Options and System Variables”

--ignore-db-dir

Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--ignore-error

Section 4.5.4, “mysqldump — A Database Backup Program”

--ignore-lines

Section 4.5.5, “mysqlimport — A Data Import Program”

--ignore-spaces

Section 4.5.1.1, “mysql Options”

--ignore-table

Section 4.5.4, “mysqldump — A Database Backup Program”

--in_file

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

--include

Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

--include-gtids

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--include-master-host-port

Section 4.5.4, “mysqldump — A Database Backup Program”

--info

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”

--information

Section 4.6.3.2, “myisamchk Check Options”

--init-command

Section 4.5.1.1, “mysql Options”
Section 17.4.1.27, “Replication of Server-Side Help Tables”

--init-file

Section 21.2.3, “Performance Schema Runtime Configuration”
Section C.5.4.1.2, “Resetting the Root Password: Unix Systems”
Section C.5.4.1.1, “Resetting the Root Password: Windows Systems”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 15.3, “The MEMORY Storage Engine”

--init_connect

Section 10.1.5, “Configuring the Character Set and Collation for Applications”

--innodb

Section 14.12, “InnoDB Startup Options and System Variables”
Section 14.1.3, “Turning Off InnoDB”

innodb-status-file

Section 14.15.2, “Enabling InnoDB Monitors”

--innodb-status-file

Section 14.12, “InnoDB Startup Options and System Variables”

--innodb-xxx

Section 5.1.3, “Server Command Options”

--innodb_adaptive_hash_index

Section 14.12, “InnoDB Startup Options and System Variables”

--innodb_file_per_table

Section 14.5.3, “Enabling and Disabling File-Per-Table Mode”
Section 5.1.3, “Server Command Options”

innodb_file_per_table

Section 17.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 5.1.3, “Server Command Options”

--innodb_rollback_on_timeout

Section 14.19.4, “InnoDB Error Handling”
Section 14.12, “InnoDB Startup Options and System Variables”

--innodb_support_xa

Section 5.2.4, “The Binary Log”

--insert-ignore

Section 4.5.4, “mysqldump — A Database Backup Program”

--install

Section 4.2.3.4, “Command-Line Options that Affect Option-File Handling”
Section 5.1.3, “Server Command Options”
Section 5.3.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 2.3.5.7, “Starting MySQL as a Windows Service”

--install-manual

Section 5.1.3, “Server Command Options”
Section 5.3.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 2.3.5.7, “Starting MySQL as a Windows Service”

--iterations

Section 4.5.7, “mysqlslap — Load Emulation Client”

J

[index top]

-j

Section 4.5.1.1, “mysql Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--join

Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”

K

[index top]

-K

Section 4.5.4, “mysqldump — A Database Backup Program”

-k

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”

--keep_files_on_create

Section 13.1.14, “CREATE TABLE Syntax”

--keepold

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--key_buffer_size

Section 5.1.3, “Server Command Options”

--keys

Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”

--keys-used

Section 4.6.3.3, “myisamchk Repair Options”

L

[index top]

-L

Section 4.5.1.1, “mysql Options”
Section 22.8.4.1, “Building C API Client Programs”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 2.12.3, “Problems Using the Perl DBI/DBD Interface”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL

-l

Section 4.6.3.3, “myisamchk Repair Options”
Section 22.8.7.40, “mysql_library_end()
Section 22.8.4.1, “Building C API Client Programs”
Section 22.8.13, “C API Embedded Server Function Descriptions”
Section 22.8.6, “C API Function Overview”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”

--language

Section 5.1.3, “Server Command Options”

--large-pages

Section 8.11.4.2, “Enabling Large Page Support”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--lc-messages

Section 5.1.3, “Server Command Options”

--lc-messages-dir

Section 5.1.3, “Server Command Options”

--ldata

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

--ledir

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--length

Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”

--libmysqld-libs

Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

--libs

Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

--libs_r

Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

--line-numbers

Section 4.5.1.1, “mysql Options”

--lines-terminated-by

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump

--local

Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL

--local-infile

Section 4.5.1.1, “mysql Options”
Section 13.2.7, “LOAD XML Syntax”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL

--local-load

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--local-service

Section 5.1.3, “Server Command Options”
Section 2.3.5.7, “Starting MySQL as a Windows Service”

--lock-all-tables

Section 4.5.4, “mysqldump — A Database Backup Program”

--lock-tables

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”

--log

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--log-bin

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 13.4.1.1, “PURGE BINARY LOGS Syntax”
Section 7.3.3, “Backup Strategy Summary”
Section 19.7, “Binary Logging of Stored Programs”
Section 17.1.4.4, “Binary Logging Options and Variables”
Section 7.2, “Database Backup Methods”
Section 7.3.1, “Establishing a Backup Policy”
Section 17.1.4.5, “Global Transaction ID Options and Variables”
Section 17.4.5, “How to Report Replication Bugs or Problems”
Section C.5.8, “Known Issues in MySQL”
Section 7.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 17.3.6, “Switching Masters During Failover”
Section 5.2.4, “The Binary Log”
Section 17.4.4, “Troubleshooting Replication”
Section 17.4.3, “Upgrading a Replication Setup”
Section 7.3.2, “Using Backups for Recovery”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”

--log-bin-index

Section 17.1.4.4, “Binary Logging Options and Variables”
Section 5.2.4, “The Binary Log”

--log-bin-trust-function-creators

Section 19.7, “Binary Logging of Stored Programs”
Section 17.1.4.4, “Binary Logging Options and Variables”

--log-bin-use-v1-row-events

Section 17.1.4.4, “Binary Logging Options and Variables”

--log-error

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.2.3.6, “Option Defaults, Options Expecting Values, and the = Sign”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.3, “Server Command Options”
Section 5.2.6, “Server Log Maintenance”
Section 2.3.5.5, “Starting MySQL from the Windows Command Line”
Section 2.3.5.4, “Starting the Server for the First Time”
Section 5.2.2, “The Error Log”

--log-isam

Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 5.1.3, “Server Command Options”

--log-output

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.3, “Server Command Options”
Section 5.2.3, “The General Query Log”
Section 5.2.5, “The Slow Query Log”

--log-queries-not-using-indexes

Section 5.1.3, “Server Command Options”

--log-raw

Section 6.1.2.3, “Passwords and Logging”
Section 5.1.3, “Server Command Options”
Section 5.2.3, “The General Query Log”

--log-short-format

Section 17.1.4.4, “Binary Logging Options and Variables”
Section 5.1.3, “Server Command Options”
Section 5.2.5, “The Slow Query Log”

--log-slave-updates

Section 17.1.4.5, “Global Transaction ID Options and Variables”
Section 17.4.5, “How to Report Replication Bugs or Problems”
Section 17.3.5, “Improving Replication Performance”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.3.6, “Switching Masters During Failover”
Section 5.2.4, “The Binary Log”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”

--log-slow-admin-statements

Section 5.1.3, “Server Command Options”

--log-slow-slave-statements

Section 17.1.4.3, “Replication Slave Options and Variables”

--log-tc

Section 5.1.3, “Server Command Options”

--log-tc-size

Section 5.1.3, “Server Command Options”
Section 5.1.6, “Server Status Variables”

--log-warnings

Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.7”

--login-path

Section 4.5.1.1, “mysql Options”
Section 4.2.3.4, “Command-Line Options that Affect Option-File Handling”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.2.3.3, “Using Option Files”

--loose

Section 4.2.3.2, “Program Option Modifiers”

--loose-opt_name

Section 4.2.3.3, “Using Option Files”

--low-priority

Section 4.5.5, “mysqlimport — A Data Import Program”

--low-priority-updates

Section 13.2.5, “INSERT Syntax”
Section 8.10.3, “Concurrent Inserts”
Section 5.1.3, “Server Command Options”
Section 8.10.2, “Table Locking Issues”

--lower-case-table-names

Section 9.2.2, “Identifier Case Sensitivity”

M

[index top]

-m

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--malloc-lib

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--master-connect-retry

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-data

Section 17.1.1.5, “Creating a Data Snapshot Using mysqldump
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 7.3.1, “Establishing a Backup Policy”
Section 5.2, “MySQL Server Logs”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”

--master-host

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-info-file

Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.2.2.2, “Slave Status Logs”

--master-info-repository

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 14.12, “InnoDB Startup Options and System Variables”
Section 17.2.2, “Replication Relay and Status Logs”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.1.1.8, “Setting Up Replication with Existing Data”
Section 17.2.2.2, “Slave Status Logs”

--master-password

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-port

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-retry-count

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”
Section 17.1.4.3, “Replication Slave Options and Variables”

--master-ssl

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-ssl-ca

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-ssl-capath

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-ssl-cert

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-ssl-cipher

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-ssl-key

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-user

Section 17.1.4.3, “Replication Slave Options and Variables”

--master-verify-checksum

Section 17.1.4.4, “Binary Logging Options and Variables”

--max

Section 4.2.3.5, “Using Options to Set Program Variables”

--max-binlog-dump-events

Section 17.1.4.4, “Binary Logging Options and Variables”

--max-binlog-size

Section 17.1.4.3, “Replication Slave Options and Variables”

--max-record-length

Section 4.6.3.3, “myisamchk Repair Options”
Section 13.7.2.5, “REPAIR TABLE Syntax”

--max-relay-log-size

Section 17.1.4.3, “Replication Slave Options and Variables”

--max-seeks-for-key

Section 8.2.1.20, “How to Avoid Full Table Scans”
Section C.5.6, “Optimizer-Related Issues”

--max_a

Section 4.2.3.5, “Using Options to Set Program Variables”

--max_join_size

Section 4.5.1.6.4, “Using the --safe-updates Option”

--maximum

Section 4.2.3.2, “Program Option Modifiers”

--maximum-query_cache_size

Section 4.2.3.2, “Program Option Modifiers”
Section 8.9.3.3, “Query Cache Configuration”
Section 5.1.5, “Using System Variables”

--maximum-var_name

Section 5.1.3, “Server Command Options”
Section 5.1.5, “Using System Variables”

--medium-check

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--memlock

Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 14.5.8, “Using Raw Disk Partitions for the Shared Tablespace”

--method

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--min-examined-row-limit

Section 5.1.3, “Server Command Options”

--my-plugin

Section 5.1.8.1, “Installing and Uninstalling Plugins”

--my-print-defaults

Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”

--my_plugin

Section 5.1.8.1, “Installing and Uninstalling Plugins”

--myisam-block-size

Section 8.9.2.5, “Key Cache Block Size”
Section 5.1.3, “Server Command Options”

--myisam-recover

Section 5.1.3, “Server Command Options”

--myisam-recover-options

Section 15.2.1, “MyISAM Startup Options”
Section 8.6.1, “Optimizing MyISAM Queries”
Section 8.2.5, “Other Optimization Tips”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section C.5.2.19, “Table-Corruption Issues”
Section 15.2, “The MyISAM Storage Engine”
Section 23.4.1.6, “Using Server Logs to Find Causes of Errors in mysqld

--myisam_sort_buffer_size

Section 4.6.3.6, “myisamchk Memory Usage”

MYSQL_MAINTAINER_MODE

Section 2.8.5, “Dealing with Problems Compiling MySQL”

MYSQL_TCP_PORT

Section 2.8.3, “Installing MySQL Using a Development Source Tree”
Section 2.8.4, “MySQL Source-Configuration Options”

MYSQL_UNIX_ADDR

Section C.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
Section 2.8.3, “Installing MySQL Using a Development Source Tree”
Section 2.8.4, “MySQL Source-Configuration Options”

--mysqladmin

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--mysqld

Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--mysqld-version

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

N

[index top]

-N

Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”

-n

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”

--name_file

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

--named-commands

Section 4.5.1.1, “mysql Options”

--ndb

Section 4.8.1, “perror — Explain Error Codes”

net_retry_count

Section 17.2.1, “Replication Implementation Details”

net_write_timeout

Section 17.2.1, “Replication Implementation Details”

--new

Section 4.2.3.3, “Using Option Files”

--nice

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--no-auto-rehash

Section 4.5.1.1, “mysql Options”

--no-autocommit

Section 4.5.4, “mysqldump — A Database Backup Program”

--no-beep

Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

--no-check

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”

--no-create-db

Section 4.5.4, “mysqldump — A Database Backup Program”

--no-create-info

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 7.4.5.4, “Dumping Table Definitions and Content Separately”

--no-data

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 7.4.5.4, “Dumping Table Definitions and Content Separately”

--no-defaults

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 4.2.3.4, “Command-Line Options that Affect Option-File Handling”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.1.3, “Server Command Options”

--no-drop

Section 4.5.7, “mysqlslap — Load Emulation Client”

--no-log

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--no-set-names

Section 4.5.4, “mysqldump — A Database Backup Program”

--no-symlinks

Section 4.6.3.3, “myisamchk Repair Options”

--no-tablespaces

Section 4.5.4, “mysqldump — A Database Backup Program”

--noindices

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--number-char-cols

Section 4.5.7, “mysqlslap — Load Emulation Client”

--number-int-cols

Section 4.5.7, “mysqlslap — Load Emulation Client”

--number-of-queries

Section 4.5.7, “mysqlslap — Load Emulation Client”

--numeric-dump-file

Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”

O

[index top]

-O

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 2.8.4, “MySQL Source-Configuration Options”

-o

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 22.7.1, “Compiling Programs with libmysqld
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 8.11.3, “Optimizing Disk I/O”

--offset

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--old-alter-table

Section 5.1.3, “Server Command Options”

--old-style-user-limits

Section 5.1.3, “Server Command Options”
Section 6.3.4, “Setting Account Resource Limits”

--old_server

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

ON

Section 3.3.4.9, “Using More Than one Table”

--one-database

Section 4.5.1.1, “mysql Options”

--only-print

Section 4.5.7, “mysqlslap — Load Emulation Client”

open-files-limit

Section C.5.2.7, “Too many connections

--open-files-limit

Section C.5.2.18, “'File' Not Found and Similar Errors”
Section 14.12, “InnoDB Startup Options and System Variables”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 5.1.3, “Server Command Options”

--opt

Section 8.5.4, “Bulk Data Loading for InnoDB Tables”
Section 4.5.4, “mysqldump — A Database Backup Program”

--opt_name

Section 4.2.3.3, “Using Option Files”

--optimize

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--order-by-primary

Section 4.5.4, “mysqldump — A Database Backup Program”

--out_dir

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

--out_file

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

P

[index top]

-P

Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.2.1, “Invoking MySQL Programs”
Section 5.1.3, “Server Command Options”

-p

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 6.3.2, “Adding User Accounts”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 4.2.1, “Invoking MySQL Programs”
Section C.5.2.5, “Password Fails When Entered Interactively”
Section 2.9.2, “Securing the Initial MySQL Accounts”
Section 2.3.5.7, “Starting MySQL as a Windows Service”
Section 2.3.5.5, “Starting MySQL from the Windows Command Line”
Section 2.3.5.8, “Testing The MySQL Installation”
Section 2.3.7, “Upgrading MySQL on Windows”
Section 6.3.1, “User Names and Passwords”
Section 4.2.3.1, “Using Options on the Command Line”
Section 2.3.8, “Windows Postinstallation Procedures”

--page

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”

--page-type-dump

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”

--page-type-summary

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”

--pager

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”

--parallel-recover

Section 4.6.3.3, “myisamchk Repair Options”

--partition

Section 5.1.3, “Server Command Options”

password

Section 4.5.1.1, “mysql Options”
Section 4.2.3.4, “Command-Line Options that Affect Option-File Handling”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.2.3.3, “Using Option Files”

--password

Section 4.5.1.1, “mysql Options”
Section 6.3.2, “Adding User Accounts”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 7.3, “Example Backup and Recovery Strategy”
Section 4.2.1, “Invoking MySQL Programs”
Section C.5.2.5, “Password Fails When Entered Interactively”
Section 6.3.8, “Pluggable Authentication”
Section 6.3.9.7, “The Test Authentication Plugin”
Section 6.3.1, “User Names and Passwords”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 4.2.3.1, “Using Options on the Command Line”

--performance-schema-consumer-consumer_name

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-stages-current

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-stages-history

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-stages-history-long

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-statements-current

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-statements-history

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-statements-history-long

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-transactions-current

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-transactions-history

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-transactions-history-long

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-waits-current

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-waits-history

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-events-waits-history-long

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-global-instrumentation

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-statements-digest

Section 21.11, “Performance Schema Command Options”

--performance-schema-consumer-thread-instrumentation

Section 21.11, “Performance Schema Command Options”

--performance-schema-instrument

Section 21.11, “Performance Schema Command Options”
Section 21.2.2, “Performance Schema Startup Configuration”

--performance-schema-xxx

Section 5.1.3, “Server Command Options”

--performance_schema_max_mutex_classes

Section 21.5, “Performance Schema Status Monitoring”

--performance_schema_max_mutex_instances

Section 21.5, “Performance Schema Status Monitoring”

pid-file

Section 2.9.1.2, “Starting and Stopping MySQL Automatically”

--pid-file

Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--pipe

Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 2.3.5.8, “Testing The MySQL Installation”

--plugin

Section 5.1.3, “Server Command Options”

--plugin-dir

Section 4.5.1.1, “mysql Options”
Section 22.8.14.3, “mysql_load_plugin()
Section 22.8.14, “C API Client Plugin Functions”
Section 23.2.4.2.3, “Client Plugin Descriptors”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 6.3.8, “Pluggable Authentication”
Section E.9, “Restrictions on Pluggable Authentication”
Section 23.2.4.9.3, “Using the Authentication Plugins”
Section 23.2.4.11.2, “Using Your Own Protocol Trace Plugins”

--plugin-ini

Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”

--plugin-innodb_file_per_table

Section 5.1.3, “Server Command Options”

--plugin-load

Section 13.7.3.3, “INSTALL PLUGIN Syntax”
Section 6.3.13.5, “Audit Log Plugin Options and Variables”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 5.1.8.1, “Installing and Uninstalling Plugins”
Section 6.3.13.1, “Installing the Audit Log Plugin”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 6.1.2.6.1, “Password Validation Plugin Installation”
Section 6.1.2.6.2, “Password Validation Plugin Options and Variables”
Section 6.3.8, “Pluggable Authentication”
Section 23.2.2, “Plugin API Components”
Section 23.2.4.2, “Plugin Data Structures”
Section 5.1.3, “Server Command Options”
Section 23.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
Section 23.2, “The MySQL Plugin API”
Section 23.2.4.9.3, “Using the Authentication Plugins”

--plugin-load-add

Section 5.1.8.1, “Installing and Uninstalling Plugins”
Section 5.1.3, “Server Command Options”

--plugin-sql-mode

Section 5.1.3, “Server Command Options”

--plugin-xxx

Section 5.1.3, “Server Command Options”

--plugin_dir

Section 2.8.4, “MySQL Source-Configuration Options”
Section 23.2.2, “Plugin API Components”

--plugin_name

Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 5.1.8.1, “Installing and Uninstalling Plugins”

--plugindir

Section 4.7.1, “mysql_config — Display Options for Compiling Clients”

--port

Section 4.5.1.1, “mysql Options”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.1, “mysql_config — Display Options for Compiling Clients”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.2.1, “Invoking MySQL Programs”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 2.9.1.3, “Starting and Troubleshooting the MySQL Server”
Section 5.3.4, “Using Client Programs in a Multiple-Server Environment”

--port-open-timeout

Section 5.1.3, “Server Command Options”

--post-query

Section 4.5.7, “mysqlslap — Load Emulation Client”

--post-system

Section 4.5.7, “mysqlslap — Load Emulation Client”

--pre-query

Section 4.5.7, “mysqlslap — Load Emulation Client”

--pre-system

Section 4.5.7, “mysqlslap — Load Emulation Client”

--print-defaults

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.2.3.4, “Command-Line Options that Affect Option-File Handling”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.1.3, “Server Command Options”
Section 2.10.1, “Upgrading MySQL”

--prompt

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”

--protocol

Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 2.3.5.4, “Starting the Server for the First Time”
Section 2.3.5.8, “Testing The MySQL Installation”
Section 5.3.4, “Using Client Programs in a Multiple-Server Environment”

Q

[index top]

-Q

Section 4.5.4, “mysqldump — A Database Backup Program”

-q

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”

--query

Section 4.5.7, “mysqlslap — Load Emulation Client”

--query-cache-size

Section 8.10.5, “External Locking”

--quick

Section 4.6.3.6, “myisamchk Memory Usage”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section C.5.2.8, “Out of memory
Section 4.5.1, “mysql — The MySQL Command-Line Tool”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 7.6.1, “Using myisamchk for Crash Recovery”
Section 4.2.3.3, “Using Option Files”

--quiet

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--quote-names

Section 4.5.4, “mysqldump — A Database Backup Program”

R

[index top]

-R

Section 7.6.4, “MyISAM Table Optimization”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.3.4, “Other myisamchk Options”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”

-r

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 23.3.2, “Adding a New User-Defined Function”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 5.1.3, “Server Command Options”

--random-passwords

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 2.9.1, “Postinstallation Procedures for Unix-like Systems”

--raw

Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”

--read-from-remote-master

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”

--read-from-remote-server

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.7.4, “Specifying the mysqlbinlog Server ID”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”

--read-only

Section 4.6.3.2, “myisamchk Check Options”
Section 17.1.4.3, “Replication Slave Options and Variables”

--reconnect

Section 4.5.1.1, “mysql Options”

--record_log_pos

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--recover

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.3.6, “myisamchk Memory Usage”
Section 4.6.3.3, “myisamchk Repair Options”

--regexp

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--relative

Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

--relay-log

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 17.3.5, “Improving Replication Performance”
Section 17.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
Section 4.2.3.6, “Option Defaults, Options Expecting Values, and the = Sign”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.2.2.1, “The Slave Relay Log”

--relay-log-index

Section 17.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.2.2.1, “The Slave Relay Log”

--relay-log-info-file

Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.2.2.2, “Slave Status Logs”

--relay-log-info-repository

Section 14.12, “InnoDB Startup Options and System Variables”
Section 17.2.2, “Replication Relay and Status Logs”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.2.2.2, “Slave Status Logs”

--relay-log-purge

Section 17.1.4.3, “Replication Slave Options and Variables”

--relay-log-recovery

Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”
Section 17.2.2, “Replication Relay and Status Logs”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.1.12, “The Shutdown Process”

--relay-log-space-limit

Section 17.1.4.3, “Replication Slave Options and Variables”

--remove

Section 5.1.3, “Server Command Options”
Section 5.3.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 2.3.5.7, “Starting MySQL as a Windows Service”

--repair

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--replace

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”

--replicate-*

Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 17.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 17.2.3.3, “Replication Rule Application”
Section 17.1.4.3, “Replication Slave Options and Variables”

--replicate-*-db

Section 17.2.3.3, “Replication Rule Application”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section E.1, “Restrictions on Stored Programs”

--replicate-*-table

Section 17.2.3.3, “Replication Rule Application”

--replicate-do-db

Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 17.1.4.4, “Binary Logging Options and Variables”
Section 17.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 17.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 17.3.4, “Replicating Different Databases to Different Slaves”
Section 17.4.1.25, “Replication and Reserved Words”
Section 17.4.1.22, “Replication and Temporary Tables”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.2.4, “The Binary Log”
Section 17.1.2.2, “Usage of Row-Based Logging and Replication”

--replicate-do-table

Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”
Section 17.2.3.2, “Evaluation of Table-Level Replication Options”
Section 17.4.1.25, “Replication and Reserved Words”
Section 17.4.1.15, “Replication and System Functions”
Section 17.4.1.22, “Replication and Temporary Tables”
Section 17.2.3.3, “Replication Rule Application”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 15.6, “The BLACKHOLE Storage Engine”
Section 17.1.2.2, “Usage of Row-Based Logging and Replication”

--replicate-ignore-db

Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 17.1.4.4, “Binary Logging Options and Variables”
Section 17.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 17.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 17.4.1.25, “Replication and Reserved Words”
Section 17.4.1.15, “Replication and System Functions”
Section 17.2.3.3, “Replication Rule Application”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.2.4, “The Binary Log”
Section 17.1.2.2, “Usage of Row-Based Logging and Replication”

--replicate-ignore-table

Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”
Section 17.2.3.2, “Evaluation of Table-Level Replication Options”
Section 17.4.1.25, “Replication and Reserved Words”
Section 17.4.1.22, “Replication and Temporary Tables”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 15.6, “The BLACKHOLE Storage Engine”
Section 17.1.2.2, “Usage of Row-Based Logging and Replication”

--replicate-rewrite-db

Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 17.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.1.2.2, “Usage of Row-Based Logging and Replication”

--replicate-same-server-id

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 17.1.4, “Replication and Binary Logging Options and Variables”
Section 17.1.4.3, “Replication Slave Options and Variables”

--replicate-wild-do-table

Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”
Section 17.2.3.2, “Evaluation of Table-Level Replication Options”
Section 17.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 17.3.4, “Replicating Different Databases to Different Slaves”
Section 17.4.1.22, “Replication and Temporary Tables”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section E.1, “Restrictions on Stored Programs”

--replicate-wild-ignore-table

Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”
Section 17.2.3.2, “Evaluation of Table-Level Replication Options”
Section 17.4.1.22, “Replication and Temporary Tables”
Section 17.1.4.3, “Replication Slave Options and Variables”

replication-ignore-table

Section 17.4.1.35, “Replication and Views”

--replication-rewrite-db

Section 17.1.4.3, “Replication Slave Options and Variables”

--report-host

Section 13.7.5.32, “SHOW SLAVE HOSTS Syntax”
Section 17.1.5.1, “Checking Replication Status”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”

--report-password

Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”

--report-port

Section 13.7.5.32, “SHOW SLAVE HOSTS Syntax”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”

--report-user

Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”

--resetmaster

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--resetslave

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--result-file

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”

--rewrite-db

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 1.4, “What Is New in MySQL 5.7”

--routines

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 7.4.5.3, “Dumping Stored Programs”
Section 7.4.5.4, “Dumping Table Definitions and Content Separately”
Section 2.10.1.2, “Upgrading from MySQL 5.6 to 5.7”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”

--rpm

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

S

[index top]

-S

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”
Section 7.6.4, “MyISAM Table Optimization”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.6.3.4, “Other myisamchk Options”

-s

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.8.2, “replace — A String-Replacement Utility”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 7.6.2, “How to Check MyISAM Tables for Errors”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 5.1.3, “Server Command Options”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”

--safe-recover

Section 4.6.3.1, “myisamchk General Options”
Section 4.6.3.6, “myisamchk Memory Usage”
Section 4.6.3.3, “myisamchk Repair Options”

--safe-updates

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”
Section 4.5.1.6.4, “Using the --safe-updates Option”

--safe-user-create

Section 5.1.3, “Server Command Options”

--secure-auth

Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 6.3.9.3, “Migrating Away from Pre-4.1 Password Hashing and the mysql_old_password Plugin”
Section 6.1.2.4, “Password Hashing in MySQL”
Section 5.1.3, “Server Command Options”

--secure-file-priv

Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 2.9.1, “Postinstallation Procedures for Unix-like Systems”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--select_limit

Section 4.5.1.6.4, “Using the --safe-updates Option”

server-id

Section 17.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
Section 17.1, “Replication Configuration”
Section 17.1.4.2, “Replication Master Options and Variables”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.1.1.1, “Setting the Replication Master Configuration”
Section 17.1.1.2, “Setting the Replication Slave Configuration”
Section 17.1.1.8, “Setting Up Replication with Existing Data”

--server-id

Section 13.7.5.32, “SHOW SLAVE HOSTS Syntax”
Section 17.1.4.4, “Binary Logging Options and Variables”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 17.1.4, “Replication and Binary Logging Options and Variables”
Section 5.1.4, “Server System Variables”
Section 17.4.4, “Troubleshooting Replication”

--server-public-key-path

Section 4.5.1.1, “mysql Options”
Section 6.3.9.4, “The SHA-256 Authentication Plugin”

--service-startup-timeout

Section 4.3.3, “mysql.server — MySQL Server Startup Script”

--set-auto-increment

Section 4.6.3.4, “Other myisamchk Options”

--set-character-set

Section 4.6.3.3, “myisamchk Repair Options”

--set-charset

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”

--set-collation

Section 4.6.3.3, “myisamchk Repair Options”

--set-gtid-purged

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”

--shared-memory

Section 4.2.2, “Connecting to the MySQL Server”
Section 5.1.3, “Server Command Options”
Section 5.3.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 2.3.5.4, “Starting the Server for the First Time”

--shared-memory-base-name

Section 22.8.7.50, “mysql_options()
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.3, “Server Command Options”
Section 5.3.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 5.3.4, “Using Client Programs in a Multiple-Server Environment”

--short-form

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--show-slave-auth-info

Section 17.1.4.3, “Replication Slave Options and Variables”

--show-table-type

Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”

--show-warnings

Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

--sigint-ignore

Section 4.5.1.1, “mysql Options”

--silent

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”

--single-transaction

Section 14.16, “InnoDB Backup and Recovery”
Section 7.2, “Database Backup Methods”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 7.3.1, “Establishing a Backup Policy”

--skip

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.2.3.2, “Program Option Modifiers”
Section 5.1.3, “Server Command Options”

--skip-add-drop-table

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-add-locks

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-auto-rehash

Section 14.19.3, “Troubleshooting InnoDB Data Dictionary Operations”

--skip-character-set-client-handshake

Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 10.1.14.7.1, “The cp932 Character Set”

--skip-column-names

Section 4.5.1.1, “mysql Options”

--skip-comments

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-concurrent-insert

Section 5.1.3, “Server Command Options”

--skip-database

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--skip-disable-keys

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-dump-date

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-engine_name

Section 13.7.5.15, “SHOW ENGINES Syntax”

--skip-event-scheduler

Section 5.1.3, “Server Command Options”

--skip-events

Section 7.4.5.3, “Dumping Stored Programs”

--skip-extended-insert

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-external-locking

Section 8.10.5, “External Locking”
Section 8.12.5.2, “General Thread States”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 8.11.1, “System Factors and Startup Parameter Tuning”
Section C.5.4.2, “What to Do If MySQL Keeps Crashing”

--skip-grant-tables

Section 13.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 13.7.3.3, “INSTALL PLUGIN Syntax”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 23.3.2.5, “Compiling and Installing User-Defined Functions”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 19.4.2, “Event Scheduler Configuration”
Section 5.1.8.1, “Installing and Uninstalling Plugins”
Section 6.3.8, “Pluggable Authentication”
Section 2.9.1.1, “Problems Running mysql_install_db
Section C.5.4.1.3, “Resetting the Root Password: Generic Instructions”
Section 5.1.3, “Server Command Options”
Section 2.10.1.2, “Upgrading from MySQL 5.6 to 5.7”
Section 4.2.3.1, “Using Options on the Command Line”
Section 6.2.6, “When Privilege Changes Take Effect”

--skip-gtids

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 7.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”

--skip-host-cache

Section 6.2.7, “Causes of Access-Denied Errors”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--skip-innodb

Section 14.12, “InnoDB Startup Options and System Variables”
Section 5.1.8.1, “Installing and Uninstalling Plugins”
Section 5.1.3, “Server Command Options”
Section 14.1.3, “Turning Off InnoDB”
Section 17.3.2, “Using Replication with Different Master and Slave Storage Engines”

--skip-innodb-checksums

Section 14.12, “InnoDB Startup Options and System Variables”

--skip-innodb_adaptive_hash_index

Section 14.12, “InnoDB Startup Options and System Variables”

--skip-innodb_doublewrite

Section 14.12, “InnoDB Startup Options and System Variables”

--skip-kill-mysqld

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--skip-line-numbers

Section 4.5.1.1, “mysql Options”

--skip-lock-tables

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-name-resolve

Section 6.2.7, “Causes of Access-Denied Errors”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 8.11.5.2, “DNS Lookup Optimization and the Host Cache”
Section 2.9.2, “Securing the Initial MySQL Accounts”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 2.3.5.8, “Testing The MySQL Installation”

--skip-named-commands

Section 4.5.1.1, “mysql Options”

--skip-networking

Section C.5.2.2, “Can't connect to [local] MySQL server
Section C.5.2.9, “MySQL server has gone away
Section 6.2.7, “Causes of Access-Denied Errors”
Section 8.11.5.2, “DNS Lookup Optimization and the Host Cache”
Section 6.3.8, “Pluggable Authentication”
Section C.5.4.1.3, “Resetting the Root Password: Generic Instructions”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 17.4.3, “Upgrading a Replication Setup”

skip-networking

Section 17.1.1.1, “Setting the Replication Master Configuration”
Section 17.4.4, “Troubleshooting Replication”

--skip-new

Section 13.7.2.4, “OPTIMIZE TABLE Syntax”
Section 23.4.1, “Debugging a MySQL Server”
Section 5.1.4, “Server System Variables”

--skip-opt

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-pager

Section 4.5.1.1, “mysql Options”

--skip-partition

Chapter 18, Partitioning
Section 5.1.3, “Server Command Options”

--skip-plugin-innodb_file_per_table

Section 5.1.3, “Server Command Options”

--skip-plugin_name

Section 5.1.8.1, “Installing and Uninstalling Plugins”

--skip-quick

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-quote-names

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-random-passwords

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

--skip-reconnect

Section 4.5.1.1, “mysql Options”
Section 22.8.16, “Controlling Automatic Reconnection Behavior”
Section 4.5.1.6.5, “Disabling mysql Auto-Reconnect”

--skip-routines

Section 7.4.5.3, “Dumping Stored Programs”

--skip-secure-auth

Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.1.3, “Server Command Options”

--skip-set-charset

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-show-database

Section 13.7.5.13, “SHOW DATABASES Syntax”
Section 6.2.1, “Privileges Provided by MySQL”
Section 5.1.3, “Server Command Options”

--skip-slave-start

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 13.4.2.6, “START SLAVE Syntax”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.1.3.2, “Setting Up Replication Using GTIDs”
Section 17.3.7, “Setting Up Replication Using SSL”
Section 17.1.1.8, “Setting Up Replication with Existing Data”
Section 17.4.4, “Troubleshooting Replication”
Section 17.4.3, “Upgrading a Replication Setup”

--skip-ssl

Section 6.3.11.4, “SSL Command Options”
Section 6.3.11.3, “Using SSL Connections”

--skip-stack-trace

Section 23.4.1.4, “Debugging mysqld under gdb
Section 5.1.3, “Server Command Options”

--skip-super-large-pages

Section 8.11.4.2, “Enabling Large Page Support”
Section 5.1.3, “Server Command Options”

--skip-symbolic-links

Section 13.1.14, “CREATE TABLE Syntax”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 8.11.3.1.2, “Using Symbolic Links for MyISAM Tables on Unix”

--skip-syslog

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.2.2, “The Error Log”

--skip-triggers

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 7.4.5.3, “Dumping Stored Programs”

--skip-tz-utc

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-version-check

Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”

--skip-warn

Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”

--skip-write-binlog

Section 11.3.4, “YEAR(2) Limitations and Migrating to YEAR(4)
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”

--skip_grant_tables

Section 4.2.3.1, “Using Options on the Command Line”

--slave-checkpoint-group

Section 17.1.4.3, “Replication Slave Options and Variables”

--slave-checkpoint-period

Section 17.1.4.3, “Replication Slave Options and Variables”

--slave-load-tmpdir

Section 17.3.1.2, “Backing Up Raw Data from a Slave”
Section 7.2, “Database Backup Methods”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section C.5.4.4, “Where MySQL Stores Temporary Files”

slave-max-allowed-packet

Section 17.1.4.3, “Replication Slave Options and Variables”

--slave-max-allowed-packet

Section 17.1.4.3, “Replication Slave Options and Variables”

--slave-net-timeout

Section 17.1.4.3, “Replication Slave Options and Variables”

--slave-parallel-type

Section 17.1.4.3, “Replication Slave Options and Variables”

--slave-parallel-workers

Section 17.1.4.3, “Replication Slave Options and Variables”

--slave-pending-jobs-size-max

Section 17.1.4.3, “Replication Slave Options and Variables”

slave-rows-search-algorithms

Section 17.1.4.3, “Replication Slave Options and Variables”

--slave-skip-errors

Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.4.1.26, “Slave Errors During Replication”

--slave-sql-verify-checksum

Section 17.1.4.4, “Binary Logging Options and Variables”
Section 17.1.4.3, “Replication Slave Options and Variables”

--slave_compressed_protocol

Section 17.1.4.3, “Replication Slave Options and Variables”

--sleep

Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

--slow-query-log

Section 5.1.3, “Server Command Options”

--slow-start-timeout

Section 5.1.3, “Server Command Options”

--slow_query_log

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

--slow_query_log_file

Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.2.5, “The Slow Query Log”

--socket

Section 4.5.1.1, “mysql Options”
Section C.5.2.2, “Can't connect to [local] MySQL server
Section 6.2.7, “Causes of Access-Denied Errors”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.1, “mysql_config — Display Options for Compiling Clients”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section C.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
Section 4.2.1, “Invoking MySQL Programs”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.3, “Server Command Options”
Section 23.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
Section 2.3.5.8, “Testing The MySQL Installation”
Section 5.3.4, “Using Client Programs in a Multiple-Server Environment”

socket

Section 2.4.1, “General Notes on Installing MySQL on Mac OS X”

--sort-index

Section 7.6.4, “MyISAM Table Optimization”
Section 4.6.3.4, “Other myisamchk Options”

--sort-records

Section 7.6.4, “MyISAM Table Optimization”
Section 4.6.3.4, “Other myisamchk Options”

--sort-recover

Section 4.6.3.1, “myisamchk General Options”
Section 4.6.3.6, “myisamchk Memory Usage”
Section 4.6.3.3, “myisamchk Repair Options”

--sporadic-binlog-dump-fail

Section 17.1.4.4, “Binary Logging Options and Variables”

--sql-mode

Chapter 12, Functions and Operators
Section 5.1.3, “Server Command Options”
Section 5.1.7, “Server SQL Modes”

sql-mode

Section 5.1.7, “Server SQL Modes”

--srcdir

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

--ssl

Section 4.5.1.1, “mysql Options”
Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 5.1.3, “Server Command Options”
Section 6.3.11.4, “SSL Command Options”
Section 6.3.11.3, “Using SSL Connections”

--ssl*

Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 5.1.3, “Server Command Options”

--ssl-ca

Section 13.7.1.4, “GRANT Syntax”
Section 6.3.11.5, “Setting Up SSL Certificates and Keys for MySQL”
Section 6.3.11.4, “SSL Command Options”
Section 6.3.11.3, “Using SSL Connections”

--ssl-capath

Section 13.7.1.4, “GRANT Syntax”
Section 6.3.11.4, “SSL Command Options”

--ssl-cert

Section 13.7.1.4, “GRANT Syntax”
Section 6.3.11.5, “Setting Up SSL Certificates and Keys for MySQL”
Section 6.3.11.4, “SSL Command Options”
Section 6.3.11.3, “Using SSL Connections”

--ssl-cipher

Section 6.3.11.4, “SSL Command Options”

--ssl-crl

Section 6.3.11.4, “SSL Command Options”

--ssl-crlpath

Section 6.3.11.4, “SSL Command Options”

--ssl-key

Section 13.7.1.4, “GRANT Syntax”
Section 6.3.11.5, “Setting Up SSL Certificates and Keys for MySQL”
Section 6.3.11.4, “SSL Command Options”
Section 6.3.11.3, “Using SSL Connections”

--ssl-verify-server-cert

Section 6.3.11.4, “SSL Command Options”

--ssl-xxx

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 6.3.11.2, “Configuring MySQL for SSL”
Section 5.1.4, “Server System Variables”
Section 6.3.11.4, “SSL Command Options”

--standalone

Section 23.4.1.2, “Creating Trace Files”
Section 5.1.3, “Server Command Options”
Section 2.3.5.5, “Starting MySQL from the Windows Command Line”

--start-datetime

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 7.5.1, “Point-in-Time Recovery Using Event Times”

--start-page

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”

--start-position

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 7.5.2, “Point-in-Time Recovery Using Event Positions”

--statefile

Section 4.4.1, “comp_err — Compile MySQL Error Message File”

--stats

Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”

--status

Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”

--stop-datetime

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 7.5.1, “Point-in-Time Recovery Using Event Times”

--stop-never

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.7.4, “Specifying the mysqlbinlog Server ID”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”

--stop-never-slave-server-id

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.7.4, “Specifying the mysqlbinlog Server ID”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”

--stop-position

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 7.5.2, “Point-in-Time Recovery Using Event Positions”

--strict-check

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”

--suffix

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--super-large-pages

Section 8.11.4.2, “Enabling Large Page Support”
Section 5.1.3, “Server Command Options”

--symbolic-links

Section 5.1.3, “Server Command Options”

--symbols-file

Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”

SYSCONFDIR

Section 4.2.3.3, “Using Option Files”

--sysdate-is-now

Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 12.7, “Date and Time Functions”
Section 17.4.1.15, “Replication and System Functions”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--syslog

Section 4.5.1.3, “mysql Logging”
Section 4.5.1.1, “mysql Options”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 2.11, “Environment Variables”
Section 5.2.2, “The Error Log”
Section 1.4, “What Is New in MySQL 5.7”

--syslog-tag

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

T

[index top]

-T

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.1.3, “Server Command Options”

-t

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.1.3, “Server Command Options”

--tab

Section 7.1, “Backup and Recovery Types”
Section 7.2, “Database Backup Methods”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump
Section 7.4, “Using mysqldump for Backups”

--table

Section 4.5.1.1, “mysql Options”

--tables

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”

--tc-heuristic-recover

Section 5.1.3, “Server Command Options”

--tcp-ip

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--tee

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”

--temp-pool

Section 5.1.3, “Server Command Options”

--test

Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”

Text

Section 1.2, “Typographical and Syntax Conventions”

--thread_cache_size

Section 23.4.1.4, “Debugging mysqld under gdb

--thread_stack

Section 8.11.5.1, “How MySQL Uses Threads for Client Connections”

--timezone

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 10.6, “MySQL Server Time Zone Support”
Section 17.4.1.30, “Replication and Time Zones”
Section 5.1.4, “Server System Variables”
Section C.5.4.6, “Time Zone Problems”

tmpdir

Section 2.3, “Installing MySQL on Microsoft Windows”

--tmpdir

Section 4.6.3.6, “myisamchk Memory Usage”
Section 4.6.3.3, “myisamchk Repair Options”
Section C.5.2.13, “Can't create/write to file
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.3, “Server Command Options”
Section C.5.4.4, “Where MySQL Stores Temporary Files”

--to-last-log

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.7.4, “Specifying the mysqlbinlog Server ID”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”

--transaction-isolation

Section 13.3.6, “SET TRANSACTION Syntax”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 14.2.2, “The InnoDB Transaction Model and Locking”

--transaction-read-only

Section 13.3.6, “SET TRANSACTION Syntax”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--triggers

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 7.4.5.3, “Dumping Stored Programs”

--tz-utc

Section 4.5.4, “mysqldump — A Database Backup Program”

U

[index top]

-U

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Section 2.5.3, “Installing MySQL on Linux Using RPM Packages”

-u

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.2.1, “Invoking MySQL Programs”
Section 5.1.3, “Server Command Options”
Section 2.3.5.8, “Testing The MySQL Installation”
Section 6.3.1, “User Names and Passwords”
Section 2.3.8, “Windows Postinstallation Procedures”

--unbuffered

Section 4.5.1.1, “mysql Options”

--unpack

Section 4.6.3.3, “myisamchk Repair Options”
Section 15.2.3, “MyISAM Table Storage Formats”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”

--update-state

Section 4.6.3.2, “myisamchk Check Options”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 15.2, “The MyISAM Storage Engine”

--upgrade-system-tables

Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”

--use-default

Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”

--use-frm

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--use-mysqld_safe

Section 4.3.3, “mysql.server — MySQL Server Startup Script”

--use-threads

Section 4.5.5, “mysqlimport — A Data Import Program”

--user

Section 4.5.1.3, “mysql Logging”
Section 4.5.1.1, “mysql Options”
Section C.5.2.18, “'File' Not Found and Similar Errors”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 7.3, “Example Backup and Recovery Strategy”
Section 6.1.5, “How to Run MySQL as a Normal User”
Section 4.2.1, “Invoking MySQL Programs”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 4.2.3.6, “Option Defaults, Options Expecting Values, and the = Sign”
Section 6.3.8, “Pluggable Authentication”
Section 2.9.1, “Postinstallation Procedures for Unix-like Systems”
Section C.5.4.1.2, “Resetting the Root Password: Unix Systems”
Section 5.1.3, “Server Command Options”
Section 6.3.9.6, “The Socket Peer-Credential Authentication Plugin”
Section 6.3.9.7, “The Test Authentication Plugin”
Section 6.3.1, “User Names and Passwords”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 4.2.3.3, “Using Option Files”

user

Section 4.5.1.1, “mysql Options”
Section 4.2.3.4, “Command-Line Options that Affect Option-File Handling”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.2.3.3, “Using Option Files”

V

[index top]

-V

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.8.2, “replace — A String-Replacement Utility”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 5.1.3, “Server Command Options”
Section 4.2.3.1, “Using Options on the Command Line”

-v

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.7.2, “mysqlbinlog Row Event Display”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.8.2, “replace — A String-Replacement Utility”
Section 7.6.2, “How to Check MyISAM Tables for Errors”
Section 4.6.3.5, “Obtaining Table Information with myisamchk
Section 5.1.3, “Server Command Options”
Section 4.2.3.1, “Using Options on the Command Line”

--validate-password

Section 6.1.2.6.1, “Password Validation Plugin Installation”
Section 6.1.2.6.2, “Password Validation Plugin Options and Variables”

--var_name

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 14.12, “InnoDB Startup Options and System Variables”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 5.1.3, “Server Command Options”

--verbose

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.7.2, “mysqlbinlog Row Event Display”
Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.5.1.5, “Executing SQL Statements from a Text File”
Section 4.6.3.4, “Other myisamchk Options”
Section 5.1.3, “Server Command Options”
Section 2.9.1.3, “Starting and Troubleshooting the MySQL Server”
Section 8.11.2, “Tuning Server Parameters”
Section 17.1.2.2, “Usage of Row-Based Logging and Replication”
Section 4.2.3.3, “Using Option Files”
Section 4.2.3.1, “Using Options on the Command Line”

--verify-binlog-checksum

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--version

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.7.1, “mysql_config — Display Options for Compiling Clients”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 5.1.3, “Server Command Options”
Section 4.2.3.1, “Using Options on the Command Line”

--version-check

Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”

--vertical

Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 1.7, “How to Report Bugs or Problems”

W

[index top]

-W

Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.1.3, “Server Command Options”

-w

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.4, “mysqldump — A Database Backup Program”

--wait

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

--warn

Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”

--where

Section 4.5.4, “mysqldump — A Database Backup Program”

--windows

Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

WITH_CLIENT_PROTOCOL_TRACING

Section 2.8.4, “MySQL Source-Configuration Options”

WITH_DEBUG

Section 13.7.5.14, “SHOW ENGINE Syntax”
Section 2.8.4, “MySQL Source-Configuration Options”

WITH_EDITLINE

Section 2.8.4, “MySQL Source-Configuration Options”

WITH_LIBEDIT

Section 2.8.4, “MySQL Source-Configuration Options”

WITH_PERFSCHEMA_STORAGE_ENGINE

Section 21.2.1, “Performance Schema Build Configuration”

WITH_TEST_TRACE_PLUGIN

Section 2.8.4, “MySQL Source-Configuration Options”
Section 23.2.4.11.1, “Using the Test Protocol Trace Plugin”
Section 23.2.4.11.2, “Using Your Own Protocol Trace Plugins”

WITH_ZLIB

Section 2.8.4, “MySQL Source-Configuration Options”

--write

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”

--write-binlog

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”

X

[index top]

-X

Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”

-x

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”

--xml

Section 4.5.1.1, “mysql Options”
Section 13.2.7, “LOAD XML Syntax”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 12.11, “XML Functions”

Y

[index top]

-Y

Section 4.5.4, “mysqldump — A Database Backup Program”

-y

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”