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.5.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.8, “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.3, “my_print_defaults — Display Options from Option Files”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.8.2, “replace — A String-Replacement Utility”
Section 5.1.3, “Server Command Options”
Section 22.4.3, “The DBUG Package”

-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.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.15, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.6.16, “mysql_zap — Kill Processes That Match a Pattern”
Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.10, “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, “my_print_defaults — Display Options from Option Files”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.4.4, “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”

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.9, “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 16.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.10, “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.7, “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.11.4, “Rebuilding or Repairing Tables or Indexes”
Section 7.4.2, “Reloading SQL-Format Backups”
Section 2.11.1.1, “Upgrading from MySQL 5.5 to 5.6”
Section 4.6.8.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-suspicious-udfs

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

--allowold

Section 4.6.10, “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.3, “Running MySQL in ANSI Mode”
Section 5.1.3, “Server Command Options”

--apply-slave-statements

Section 4.5.4, “mysqldump — A Database Backup Program”

--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”

--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.6.7, “mysqlaccess — Client for Checking Access Privileges”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.4.4, “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.8.2, “mysqlbinlog Row Event Display”
Section 16.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 16.1.3.1, “GTID Concepts”
Section 16.1.2.2, “Usage of Row-Based Logging and Replication”

--basedir

Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.4, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.7, “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.9.4, “MySQL Source-Configuration Options”
Section 5.4, “Running Multiple MySQL Instances on One Machine”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 2.10.1.3, “Starting and Troubleshooting the MySQL Server”
Section 2.10.1, “Unix Postinstallation Procedures”

basedir

Section 2.3.4.2, “Creating an Option File”
Section 2.10.1.2, “Starting and Stopping MySQL Automatically”
Section 2.3.5, “Troubleshooting a Microsoft Windows MySQL Server Installation”

--batch

Section 4.5.1.3, “mysql History File”
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.8, “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.8, “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.4, “Running Multiple MySQL Instances on One Machine”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--binlog-checksum

Section 16.1.4.4, “Binary Log Options and Variables”

--binlog-do-db

Section 16.1.4.4, “Binary Log Options and Variables”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 5.2.4, “The Binary Log”

--binlog-format

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

--binlog-ignore-db

Section 16.1.4.4, “Binary Log Options and Variables”
Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 5.2.4, “The Binary Log”

--binlog-row-event-max-size

Section 16.1.4.4, “Binary Log Options and Variables”
Section 5.1.2.1, “Changes to Server Defaults”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.2.4.2, “Setting The Binary Log Format”
Section 2.11.1.1, “Upgrading from MySQL 5.5 to 5.6”

--binlog-rows-query-log-events

Section 16.1.4.4, “Binary Log Options and Variables”

--binlog_format

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

--block-search

Section 4.6.3.4, “Other myisamchk Options”

--bootstrap

Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.1.3, “Server Command Options”

--brief

Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”

C

[index top]

-C

Section 4.6.3.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
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.8, “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.3, “my_print_defaults — Display Options from Option Files”

--cflags

Section 2.9.5, “Dealing with Problems Compiling MySQL”
Section 4.7.2, “mysql_config — Get Compile 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 16.4.1.2, “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.8, “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.9.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.7, “mysql_upgrade — Check and Upgrade MySQL Tables”

--checkpoint

Section 4.6.10, “mysqlhotcopy — A Database Backup Program”

--chroot

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

CMAKE_INSTALL_PREFIX

Section 22.2.4.3, “Compiling and Installing Plugin Libraries”
Section 2.9.3, “Installing MySQL from a Development Source Tree”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.4.3, “Running Multiple MySQL Instances on Unix”

CMAKE_PREFIX_PATH

Section 2.9.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 16.4.1.2, “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.9.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.6.7, “mysqlaccess — Client for Checking Access Privileges”
Section 4.5.7, “mysqlslap — Load Emulation Client”

--comp

Section 4.2.3, “Specifying Program Options”

--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”

--compress

Section 4.5.1.1, “mysql Options”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 6.3.8.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”

--concurrency

Section 4.5.7, “mysqlslap — Load Emulation Client”

--config-file

Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--console

Section 14.2.5.5, “InnoDB General Troubleshooting”
Section 14.2.5.4, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 14.2.3.1, “Creating the InnoDB Tablespace”
Section C.5.4.1.1, “Resetting the Root Password: Windows Systems”
Section 5.1.3, “Server Command Options”
Section 2.3.4.4, “Starting the Server for the First Time”
Section 5.2.2, “The Error Log”

--copy

Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”

--core-file

Section 22.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.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-and-drop-schema

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”

--csv

Section 4.5.7, “mysqlslap — Load Emulation Client”

--cxxflags

Section 2.9.5, “Dealing with Problems Compiling MySQL”
Section 4.7.2, “mysql_config — Get Compile 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 22.4.1.1, “Compiling MySQL for Debugging”
Section 21.8.1, “Compiling Programs with libmysqld
Section 22.4.2, “Debugging a MySQL Client”
Section 4.6.8, “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.9.2, “Installing MySQL from a Standard Source Distribution”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 22.1.1, “MySQL Threads”
Chapter 17, Partitioning
Section 20.2.1, “Performance Schema Build Configuration”
Section 16.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 14.6, “The ARCHIVE Storage Engine”
Section 14.7, “The BLACKHOLE Storage Engine”
Section 14.10, “The EXAMPLE Storage Engine”
Section 14.9, “The FEDERATED Storage Engine”
Section 5.5, “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.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.4.4, “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.8, “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.11.4, “Rebuilding or Repairing Tables or Indexes”
Section 7.4.2, “Reloading SQL-Format Backups”

--datadir

Section 2.3.4.2, “Creating an Option File”
Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.4, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.7, “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.9.4, “MySQL Source-Configuration Options”
Section 5.4, “Running Multiple MySQL Instances on One Machine”
Section 5.4.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 5.4.1, “Setting Up Multiple Data Directories”
Section 2.10.1.3, “Starting and Troubleshooting the MySQL Server”
Section 2.10.1, “Unix Postinstallation Procedures”
Section 4.2.3.3, “Using Option Files”

datadir

Section 2.3.4.2, “Creating an Option File”
Section 2.4.1, “General Notes on Installing MySQL on Mac OS X”
Section 2.10.1.2, “Starting and Stopping MySQL Automatically”
Section 2.3.5, “Troubleshooting a Microsoft Windows MySQL Server Installation”
Section E.10.5, “Windows Platform Limitations”

--db

Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”

--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 22.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, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.6.10, “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, “my_print_defaults — Display Options from Option Files”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 2.10.1.3, “Starting and Troubleshooting the MySQL Server”
Section 2.3.4.5, “Starting MySQL from the Windows Command Line”
Section 22.4.3, “The DBUG Package”

--debug-check

Section 4.5.1.1, “mysql Options”
Section 4.6.8, “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.7, “mysql_upgrade — Check and Upgrade MySQL Tables”

--debug-info

Section 4.5.1.1, “mysql Options”
Section 4.6.8, “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.7, “mysql_upgrade — Check and Upgrade MySQL Tables”

--debug-sync-timeout

Section 2.9.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 21.9.10, “C API Client Plugin Functions”
Section 22.2.4.2.3, “Client Plugin Descriptors”
Section 4.6.8, “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.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 6.3.6, “Pluggable Authentication”
Section 6.3.6.1, “The Native Authentication Plugins”
Section 22.2.4.9.3, “Using the Authentication Plugins”

--default-authentication-plugin

Section 13.7.1.2, “CREATE USER Syntax”
Section 5.1.3, “Server Command Options”

--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.1, “Unicode Support on Windows”
Section 6.3.1, “User Names and Passwords”

--default-storage-engine

Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 14.1, “Setting the Storage Engine”
Section 14.2.3.8, “Turning Off InnoDB”

default-storage-engine

Section 14.1, “Setting the Storage Engine”

--default-time-zone

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

--default-tmp-storage-engine

Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 5.1.3, “Server Command Options”
Section 14.2.3.8, “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.2.3.4, “Command-Line Options that Affect Option-File Handling”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.2.3.3, “Using Option Files”

--defaults-file

Section 4.2.3.4, “Command-Line Options that Affect Option-File Handling”
Section 14.2.1.2, “Configuring InnoDB
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
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.9.4, “MySQL Source-Configuration Options”
Section 21.8.3, “Options with the Embedded Server”
Section C.5.4.1.1, “Resetting the Root Password: Windows Systems”
Section 5.4, “Running Multiple MySQL Instances on One Machine”
Section 5.4.3, “Running Multiple MySQL Instances on Unix”
Section 5.4.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 5.4.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 2.3.4.8, “Starting MySQL as a Windows Service”

--defaults-group-suffix

Section 4.2.3.4, “Command-Line Options that Affect Option-File Handling”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 2.12, “Environment Variables”

--delay-key-write

Section 14.3.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.4, “Server System Variables”
Section 5.1.5, “Using System Variables”

--delayed-insert

Section 4.5.4, “mysqldump — A Database Backup Program”

--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 22.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”

--disable-gtid-unsafe-statements

Section 16.1.4.5, “Global Transaction ID Options and Variables”
Section 16.1.3.2, “Setting Up Replication Using GTIDs”
Section 16.1.2.2, “Usage of Row-Based Logging and Replication”

--disable-keys

Section 4.5.4, “mysqldump — A Database Backup Program”

--disable-log-bin

Section 4.6.8, “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_GRANT_OPTIONS

Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

--disconnect-slave-event-count

Section 16.1.4.3, “Replication Slave Options and Variables”

--dryrun

Section 4.6.10, “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.3, “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.2, “mysql_config — Get Compile 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.6.3, “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.4.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”

--enforce-gtid-consistency

Section 16.1.4.5, “Global Transaction ID Options and Variables”
Section 16.1.3.3, “Restrictions on Replication with GTIDs”
Section 16.1.3.2, “Setting Up Replication Using GTIDs”
Section 1.4, “What Is New in MySQL 5.6”

--engine

Section 4.5.7, “mysqlslap — Load Emulation Client”

event-scheduler

Section 18.4.2, “Event Scheduler Configuration”

--event-scheduler

Section 18.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.11.1.1, “Upgrading from MySQL 5.5 to 5.6”
Section 4.6.8.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.8, “mysqlbinlog — Utility for Processing Binary Log Files”

--execute

Section 4.5.1.3, “mysql History File”
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 14.3.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.3, “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.8, “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.16, “mysql_zap — Kill Processes That Match a Pattern”
Section 4.6.8, “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 22.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 14.9, “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”

--flush_time

Section 22.1.1, “MySQL Threads”

--flushlog

Section 4.6.10, “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.6.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
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.3, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 22.1.2, “The MySQL Test Suite”
Section 3.5, “Using mysql in Batch Mode”

--force-if-open

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

--force-read

Section 4.6.8, “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 22.4.1.1, “Compiling MySQL for Debugging”
Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”

--gdb

Section 22.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”
Section 1.4, “What Is New in MySQL 5.6”

--general_log_file

Section 5.4, “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”
Section 1.4, “What Is New in MySQL 5.6”

--gtid-mode

Section 16.1.4.5, “Global Transaction ID Options and Variables”
Section 16.1.3.3, “Restrictions on Replication with GTIDs”
Section 16.1.3.2, “Setting Up Replication Using GTIDs”
Section 2.11.1, “Upgrading MySQL”
Section 1.4, “What Is New in MySQL 5.6”

--gtid_mode

Section 16.1.3.3, “Restrictions on Replication with GTIDs”

H

[index top]

-H

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.8, “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, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.6.10, “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.4, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
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”

HAVE_EMBEDDED_PRIVILEGE_CONTROL

Section 21.8, “libmysqld, the Embedded MySQL Server Library”

--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.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.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.12, “mysql_find_rows — Extract SQL Statements from Files”
Section 4.6.14, “mysql_setpermission — Interactively Set Permissions in Grant Tables”
Section 4.6.15, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.6.16, “mysql_zap — Kill Processes That Match a Pattern”
Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.6.10, “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, “my_print_defaults — Display Options from Option Files”
Section 4.7.4, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.4.4, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.7, “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 5.1.3, “Server Command Options”
Section 2.10.1.3, “Starting and Troubleshooting the MySQL Server”
Section 8.11.2, “Tuning Server Parameters”
Chapter 3, Tutorial
Section 2.10.1, “Unix Postinstallation Procedures”
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.8.1, “mysqlbinlog Hex Dump Format”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”

--histignore

Section 4.5.1.3, “mysql History File”
Section 4.5.1.1, “mysql Options”

--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.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.14, “mysql_setpermission — Interactively Set Permissions in Grant Tables”
Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.10, “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.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.8.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 5.4.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.2.3.4, “Command-Line Options that Affect Option-File Handling”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.2.3.3, “Using Option Files”

--howto

Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”

--html

Section 4.5.1.1, “mysql Options”

I

[index top]

-I

Section 21.9.17, “Building Client Programs”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.15, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.6.16, “mysql_zap — Kill Processes That Match a Pattern”
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.9, “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.4, “mysql_plugin — Configure MySQL Server Plugins”
Section 7.6.2, “How to Check MyISAM Tables for Errors”
Section 22.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.3, “Using the --safe-updates Option”

--ignore

Section 4.5.5, “mysqlimport — A Data Import Program”

--ignore-builtin-innodb

Section 14.2.7, “InnoDB Startup Options and System Variables”

--ignore-db-dir

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

--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.2, “mysql_config — Get Compile Options for Compiling Clients”

--include-gtids

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

--include-master-host-port

Section 4.5.4, “mysqldump — A Database Backup Program”

--info

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.12, “mysql_find_rows — Extract SQL Statements from Files”

--information

Section 4.6.3.2, “myisamchk Check Options”

--init-command

Section 4.5.1.1, “mysql Options”

--init-file

Section 2.9.4, “MySQL Source-Configuration Options”
Section 20.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 14.4, “The MEMORY Storage Engine”

--init-rpl-role

Section 1.4, “What Is New in MySQL 5.6”

--init_connect

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

--innodb

Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 14.2.3.8, “Turning Off InnoDB”

innodb-status-file

Section 14.2.5.4, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”

--innodb-status-file

Section 14.2.7, “InnoDB Startup Options and System Variables”

--innodb-xxx

Section 5.1.3, “Server Command Options”

--innodb_checksums

Section 14.2.7, “InnoDB Startup Options and System Variables”

--innodb_file_per_table

Section 14.2.2.1.1, “Enabling and Disabling File-Per-Table Mode”
Section 5.1.3, “Server Command Options”
Section 8.11.3.1.3, “Using Symbolic Links for Databases on Windows”

innodb_file_per_table

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

--innodb_rollback_on_timeout

Section 14.2.4.14, “InnoDB Error Handling”
Section 14.2.7, “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.4.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 2.3.4.8, “Starting MySQL as a Windows Service”

--install-manual

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

--iterations

Section 4.5.7, “mysqlslap — Load Emulation Client”

J

[index top]

-j

Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.8, “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”

--keep_files_on_create

Section 13.1.14, “CREATE TABLE Syntax”

--keepold

Section 4.6.10, “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 21.9.17, “Building Client Programs”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 2.13.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 21.9.3.39, “mysql_library_end()
Section 21.9.17, “Building Client Programs”
Section 21.9.9, “C API Embedded Server Function Descriptions”
Section 21.9.2, “C API Function Overview”
Section 21.8.1, “Compiling Programs with libmysqld
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “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.3, “my_print_defaults — Display Options from Option Files”
Section 21.9.17.1, “Problems Linking to the MySQL Client Library”
Section 2.13.3, “Problems Using the Perl DBI/DBD Interface”
Section 5.1.3, “Server Command Options”

--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.3, “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.2, “mysql_config — Get Compile Options for Compiling Clients”

--libs

Section 4.7.2, “mysql_config — Get Compile Options for Compiling Clients”

--libs_r

Section 4.7.2, “mysql_config — Get Compile 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.8, “mysqlbinlog — Utility for Processing Binary Log Files”

--local-service

Section 2.3.4.8, “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.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 5.1.3, “Server Command Options”
Section 1.4, “What Is New in MySQL 5.6”

--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 16.1.4.4, “Binary Log Options and Variables”
Section 18.7, “Binary Logging of Stored Programs”
Section 7.2, “Database Backup Methods”
Section 7.3.1, “Establishing a Backup Policy”
Section 16.1.4.5, “Global Transaction ID Options and Variables”
Section 16.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 16.1.4.3, “Replication Slave Options and Variables”
Section 5.4, “Running Multiple MySQL Instances on One Machine”
Section 5.1.4, “Server System Variables”
Section 16.3.6, “Switching Masters During Failover”
Section 5.2.4, “The Binary Log”
Section 16.4.4, “Troubleshooting Replication”
Section 16.4.3, “Upgrading a Replication Setup”
Section 7.3.2, “Using Backups for Recovery”
Section 1.4, “What Is New in MySQL 5.6”

--log-bin-index

Section 16.1.4.4, “Binary Log Options and Variables”
Section 5.2.4, “The Binary Log”

--log-bin-trust-function-creators

Section 16.1.4.4, “Binary Log Options and Variables”
Section 18.7, “Binary Logging of Stored Programs”

--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.4, “Running Multiple MySQL Instances on One Machine”
Section 5.1.3, “Server Command Options”
Section 5.2.6, “Server Log Maintenance”
Section 2.3.4.5, “Starting MySQL from the Windows Command Line”
Section 2.3.4.4, “Starting the Server for the First Time”
Section 5.2.2, “The Error Log”

--log-isam

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 16.1.4.4, “Binary Log Options and Variables”
Section 5.1.3, “Server Command Options”
Section 5.2.5, “The Slow Query Log”

--log-slave-updates

Section 16.1.4.5, “Global Transaction ID Options and Variables”
Section 16.4.5, “How to Report Replication Bugs or Problems”
Section 16.3.5, “Improving Replication Performance”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 16.3.6, “Switching Masters During Failover”
Section 5.2.4, “The Binary Log”

--log-slow-admin-statements

Section 5.1.3, “Server Command Options”
Section 5.2.5, “The Slow Query Log”

--log-slow-queries

Section 5.1.3, “Server Command Options”
Section 1.4, “What Is New in MySQL 5.6”

--log-slow-slave-statements

Section 16.1.4.3, “Replication Slave Options and Variables”
Section 5.2.5, “The Slow Query Log”

--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 C.5.2.9, “MySQL server has gone away
Section C.5.2.11, “Communication Errors and Aborted Connections”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server Command Options”
Section 5.2.2, “The Error Log”

--login-path

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.7.3, “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 13.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 16.1.4.3, “Replication Slave Options and Variables”

--master-data

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 7.3.1, “Establishing a Backup Policy”
Section 5.2, “MySQL Server Logs”
Section 16.2.2, “Replication Relay and Status Logs”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”

--master-host

Section 16.1.4.3, “Replication Slave Options and Variables”

--master-info-file

Section 16.1.4.3, “Replication Slave Options and Variables”
Section 16.2.2.2, “Slave Status Logs”

--master-info-repository

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 16.2.2, “Replication Relay and Status Logs”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 16.2.2.2, “Slave Status Logs”
Section 1.4, “What Is New in MySQL 5.6”

--master-password

Section 16.1.4.3, “Replication Slave Options and Variables”

--master-port

Section 16.1.4.3, “Replication Slave Options and Variables”

--master-retry-count

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

--master-ssl

Section 16.1.4.3, “Replication Slave Options and Variables”

--master-ssl-ca

Section 16.1.4.3, “Replication Slave Options and Variables”

--master-ssl-capath

Section 16.1.4.3, “Replication Slave Options and Variables”

--master-ssl-cert

Section 16.1.4.3, “Replication Slave Options and Variables”

--master-ssl-cipher

Section 16.1.4.3, “Replication Slave Options and Variables”

--master-ssl-key

Section 16.1.4.3, “Replication Slave Options and Variables”

--master-user

Section 16.1.4.3, “Replication Slave Options and Variables”

--master-verify-checksum

Section 16.1.4.4, “Binary Log Options and Variables”

--max

Section 4.2.3.5, “Using Options to Set Program Variables”

--max-binlog-dump-events

Section 16.1.4.4, “Binary Log Options and Variables”

--max-binlog-size

Section 16.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 16.1.4.3, “Replication Slave Options and Variables”

--max-seeks-for-key

Section 8.2.1.4, “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.3, “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.2.3.3, “Using Raw Disk Partitions for the Shared Tablespace”

--method

Section 4.6.10, “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.4, “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-options

Section 14.3.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 14.3, “The MyISAM Storage Engine”
Section 22.4.1.6, “Using Server Logs to Find Causes of Errors in mysqld

MYSQL_MAINTAINER_MODE

Section 2.9.5, “Dealing with Problems Compiling MySQL”

MYSQL_TCP_PORT

Section 2.9.3, “Installing MySQL from a Development Source Tree”
Section 2.9.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.9.3, “Installing MySQL from a Development Source Tree”
Section 2.9.4, “MySQL Source-Configuration Options”

--mysqladmin

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--mysqld

Section 4.4.4, “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.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.6.10, “mysqlhotcopy — A Database Backup Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 4.7.4, “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 16.2.1, “Replication Implementation Details”

net_write_timeout

Section 16.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-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 6.2.7, “Causes of Access-Denied Errors”
Section 4.2.3.4, “Command-Line Options that Affect Option-File Handling”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 4.4.4, “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”

--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.10, “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.4, “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”

-o

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 21.8.1, “Compiling Programs with libmysqld
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.8, “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.8, “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.7, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.10, “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”

--one-thread

Section 5.1.3, “Server Command Options”
Section 1.4, “What Is New in MySQL 5.6”

--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.2.7, “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.7, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.10, “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_plugin — Configure MySQL Server Plugins”
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, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.10, “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_plugin — Configure MySQL Server Plugins”
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.10.2, “Securing the Initial MySQL Accounts”
Section 2.3.4.8, “Starting MySQL as a Windows Service”
Section 2.3.4.5, “Starting MySQL from the Windows Command Line”
Section 2.3.4.9, “Testing The MySQL Installation”
Section 2.3.6, “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.7, “Windows Postinstallation Procedures”

--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.2.3.4, “Command-Line Options that Affect Option-File Handling”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
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.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.14, “mysql_setpermission — Interactively Set Permissions in Grant Tables”
Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.10, “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.7, “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.6, “Pluggable Authentication”
Section 6.3.6.5, “The Test Authentication Plugin”
Section 6.3.1, “User Names and Passwords”
Section 4.6.8.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 20.10, “Performance Schema Command Options”
Section 5.1.3, “Server Command Options”

--performance_schema_instrument

Section 20.10, “Performance Schema Command Options”
Section 20.2.2, “Performance Schema Startup Configuration”
Section 5.1.3, “Server Command Options”

--performance_schema_max_mutex_classes

Section 20.5, “Performance Schema Status Monitoring”

--performance_schema_max_mutex_instances

Section 20.5, “Performance Schema Status Monitoring”

pid-file

Section 2.10.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.4, “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.4.9, “Testing The MySQL Installation”

--plan

Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”

--plugin

Section 5.1.3, “Server Command Options”

--plugin-dir

Section 4.5.1.1, “mysql Options”
Section 21.9.10, “C API Client Plugin Functions”
Section 22.2.4.2.3, “Client Plugin Descriptors”
Section 4.6.8, “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_plugin — Configure MySQL Server Plugins”
Section 4.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 6.3.6, “Pluggable Authentication”
Section E.9, “Restrictions on Pluggable Authentication”
Section 22.2.4.9.3, “Using the Authentication Plugins”

--plugin-ini

Section 4.4.4, “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 4.4.4, “mysql_plugin — Configure MySQL Server Plugins”
Section 5.1.8.1, “Installing and Uninstalling Plugins”
Section 2.9.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.6, “Pluggable Authentication”
Section 22.2.2, “Plugin API Components”
Section 22.2.4.2, “Plugin Data Structures”
Section 5.1.3, “Server Command Options”
Section 22.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
Section 22.2, “The MySQL Plugin API”
Section 22.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.9.4, “MySQL Source-Configuration Options”
Section 22.2.2, “Plugin API Components”

--plugin_name

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

--plugindir

Section 4.7.2, “mysql_config — Get Compile 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.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.14, “mysql_setpermission — Interactively Set Permissions in Grant Tables”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.10, “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, “mysql_config — Get Compile Options for Compiling Clients”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.2.1, “Invoking MySQL Programs”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.4, “Running Multiple MySQL Instances on One Machine”
Section 5.4.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 2.10.1.3, “Starting and Troubleshooting the MySQL Server”
Section 5.4.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”

--preview

Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”

--print-defaults

Section 4.2.3.4, “Command-Line Options that Affect Option-File Handling”
Section 4.4.4, “mysql_plugin — Configure MySQL Server Plugins”
Section 2.11.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.8, “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.4.3, “Running Multiple MySQL Instances on Unix”
Section 2.3.4.4, “Starting the Server for the First Time”
Section 2.3.4.9, “Testing The MySQL Installation”
Section 5.4.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.10, “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.10, “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.8, “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.8.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 22.3.2, “Adding a New User-Defined Function”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “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 from Generic Binaries on Unix/Linux”
Section 5.1.3, “Server Command Options”

--random-passwords

Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”
Section 2.5.1, “Installing MySQL from RPM Packages on Linux”
Section 2.10.1, “Unix Postinstallation Procedures”
Section 1.4, “What Is New in MySQL 5.6”

--raw

Section 4.5.1.1, “mysql Options”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 1.4, “What Is New in MySQL 5.6”

--read-from-remote-master

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

--read-from-remote-server

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8.4, “Specifying the mysqlbinlog Server ID”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 1.4, “What Is New in MySQL 5.6”

--read-only

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

--reconnect

Section 4.5.1.1, “mysql Options”

--record_log_pos

Section 4.6.10, “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.12, “mysql_find_rows — Extract SQL Statements from Files”
Section 4.6.10, “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 16.3.5, “Improving Replication Performance”
Section 16.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 16.1.4.3, “Replication Slave Options and Variables”
Section 16.2.2.1, “The Slave Relay Log”

--relay-log-index

Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 16.2.2.1, “The Slave Relay Log”

--relay-log-info-file

Section 16.1.4.3, “Replication Slave Options and Variables”
Section 16.2.2.2, “Slave Status Logs”

--relay-log-info-repository

Section 16.2.2, “Replication Relay and Status Logs”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 16.2.2.2, “Slave Status Logs”
Section 1.4, “What Is New in MySQL 5.6”

--relay-log-purge

Section 16.1.4.3, “Replication Slave Options and Variables”

--relay-log-recovery

Section 16.1.4.3, “Replication Slave Options and Variables”

--relay-log-space-limit

Section 16.1.4.3, “Replication Slave Options and Variables”

--relnotes

Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”

--remove

Section 5.1.3, “Server Command Options”
Section 5.4.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 2.3.4.8, “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 16.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.2.3.3, “Replication Rule Application”
Section 16.1.4.3, “Replication Slave Options and Variables”

--replicate-*-db

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

--replicate-*-table

Section 16.2.3.3, “Replication Rule Application”

--replicate-do-db

Section 13.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 16.1.4.4, “Binary Log Options and Variables”
Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.3.4, “Replicating Different Databases to Different Slaves”
Section 16.4.1.25, “Replication and Reserved Words”
Section 16.4.1.22, “Replication and Temporary Tables”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 5.2.4, “The Binary Log”
Section 16.1.2.2, “Usage of Row-Based Logging and Replication”

--replicate-do-table

Section 13.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 16.2.3.2, “Evaluation of Table-Level Replication Options”
Section 16.4.1.25, “Replication and Reserved Words”
Section 16.4.1.22, “Replication and Temporary Tables”
Section 16.2.3.3, “Replication Rule Application”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 14.7, “The BLACKHOLE Storage Engine”
Section 16.1.2.2, “Usage of Row-Based Logging and Replication”

--replicate-ignore-db

Section 13.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 16.1.4.4, “Binary Log Options and Variables”
Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.4.1.25, “Replication and Reserved Words”
Section 16.2.3.3, “Replication Rule Application”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 5.2.4, “The Binary Log”
Section 16.1.2.2, “Usage of Row-Based Logging and Replication”

--replicate-ignore-table

Section 13.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 16.2.3.2, “Evaluation of Table-Level Replication Options”
Section 16.4.1.25, “Replication and Reserved Words”
Section 16.4.1.22, “Replication and Temporary Tables”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 14.7, “The BLACKHOLE Storage Engine”
Section 16.1.2.2, “Usage of Row-Based Logging and Replication”

--replicate-rewrite-db

Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 16.1.2.2, “Usage of Row-Based Logging and Replication”

--replicate-same-server-id

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

--replicate-wild-do-table

Section 13.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 16.2.3.2, “Evaluation of Table-Level Replication Options”
Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 16.3.4, “Replicating Different Databases to Different Slaves”
Section 16.4.1.22, “Replication and Temporary Tables”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section E.1, “Restrictions on Stored Programs”

--replicate-wild-ignore-table

Section 13.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 16.2.3.2, “Evaluation of Table-Level Replication Options”
Section 16.4.1.22, “Replication and Temporary Tables”
Section 16.1.4.3, “Replication Slave Options and Variables”

replication-ignore-table

Section 16.4.1.32, “Replication and Views”

--report-host

Section 13.7.5.34, “SHOW SLAVE HOSTS Syntax”
Section 16.1.5.1, “Checking Replication Status”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”

--report-password

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

--report-port

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

--report-user

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

--resetmaster

Section 4.6.10, “mysqlhotcopy — A Database Backup Program”

--resetslave

Section 4.6.10, “mysqlhotcopy — A Database Backup Program”

--result-file

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

--rhost

Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”

--rollback

Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”

--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.11.1.1, “Upgrading from MySQL 5.5 to 5.6”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”

--rows

Section 4.6.12, “mysql_find_rows — Extract SQL Statements from Files”

--rpl-recovery-rank

Section 1.4, “What Is New in MySQL 5.6”

--rpm

Section 4.4.3, “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.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.10, “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.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.16, “mysql_zap — Kill Processes That Match a Pattern”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “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.4, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.4.7, “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-mode

Section 5.1.3, “Server Command Options”
Section 1.4, “What Is New in MySQL 5.6”

--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.3, “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 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 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 2.10.1, “Unix Postinstallation Procedures”

--select_limit

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

server-id

Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
Section 16.1, “Replication Configuration”
Section 16.1.4.2, “Replication Master Options and Variables”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 16.1.1.1, “Setting the Replication Master Configuration”
Section 16.1.1.2, “Setting the Replication Slave Configuration”
Section 16.1.1.8, “Setting Up Replication with Existing Data”

--server-id

Section 13.7.5.34, “SHOW SLAVE HOSTS Syntax”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 16.1.4, “Replication and Binary Logging Options and Variables”
Section 5.1.4, “Server System Variables”
Section 16.4.4, “Troubleshooting Replication”

--server-public-key

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

--server-public-key-path

Section 4.5.1.1, “mysql Options”
Section 6.3.6.2, “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.8, “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”

--shared-memory

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

--shared-memory-base-name

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

--short-form

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

--show-slave-auth-info

Section 16.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”

--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.2.3.4, “Backing Up and Recovering an InnoDB Database”
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.2.5.7, “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-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.17, “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 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 22.3.2.5, “Compiling and Installing User-Defined Functions”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”
Section 18.4.2, “Event Scheduler Configuration”
Section 5.1.8.1, “Installing and Uninstalling Plugins”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 6.3.6, “Pluggable Authentication”
Section 2.10.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 4.2.3.1, “Using Options on the Command Line”
Section 6.2.6, “When Privilege Changes Take Effect”

--skip-gtids

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

--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.2.7, “InnoDB Startup Options and System Variables”
Section 5.1.8.1, “Installing and Uninstalling Plugins”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 14.2.3.8, “Turning Off InnoDB”
Section 16.3.2, “Using Replication with Different Master and Slave Storage Engines”

--skip-innodb-checksums

Section 14.2.7, “InnoDB Startup Options and System Variables”

--skip-innodb_adaptive_hash_index

Section 14.2.7, “InnoDB Startup Options and System Variables”

--skip-innodb_checksums

Section 14.2.7, “InnoDB Startup Options and System Variables”

--skip-innodb_doublewrite

Section 14.2.7, “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-log-warnings

Section 16.1.4.3, “Replication Slave Options and Variables”

--skip-name-resolve

Section 6.2.7, “Causes of Access-Denied Errors”
Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”
Section 8.11.5.2, “DNS Lookup Optimization and the Host Cache”
Section 2.10.2, “Securing the Initial MySQL Accounts”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 2.3.4.9, “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.6, “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 16.4.3, “Upgrading a Replication Setup”

skip-networking

Section 16.1.1.1, “Setting the Replication Master Configuration”
Section 16.4.4, “Troubleshooting Replication”

--skip-new

Section 13.7.2.4, “OPTIMIZE TABLE Syntax”
Section 22.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 17, 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-reconnect

Section 4.5.1.1, “mysql Options”
Section 21.9.12, “Controlling Automatic Reconnection Behavior”
Section 4.5.1.6.4, “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 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.15, “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.5, “START SLAVE Syntax”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 16.1.3.2, “Setting Up Replication Using GTIDs”
Section 16.3.7, “Setting Up Replication Using SSL”
Section 16.1.1.8, “Setting Up Replication with Existing Data”
Section 16.4.4, “Troubleshooting Replication”
Section 16.4.3, “Upgrading a Replication Setup”

--skip-ssl

Section 6.3.8.4, “SSL Command Options”

--skip-stack-trace

Section 22.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”
Section 8.11.3.1.3, “Using Symbolic Links for Databases on Windows”

--skip-syslog

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

--skip-thread-priority

Section 5.1.3, “Server Command Options”
Section 1.4, “What Is New in MySQL 5.6”

--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-use-db

Section 4.6.12, “mysql_find_rows — Extract SQL Statements from Files”

--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.7, “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 16.1.4.3, “Replication Slave Options and Variables”

--slave-checkpoint-period

Section 16.1.4.3, “Replication Slave Options and Variables”

--slave-load-tmpdir

Section 16.3.1.2, “Backing Up Raw Data from a Slave”
Section 7.2, “Database Backup Methods”
Section 16.1.4.3, “Replication Slave Options and Variables”

slave-max-allowed-packet

Section 16.1.4.2, “Replication Master Options and Variables”

--slave-max-allowed-packet

Section 16.1.4.2, “Replication Master Options and Variables”

--slave-net-timeout

Section 16.1.4.3, “Replication Slave Options and Variables”

--slave-parallel-workers

Section 16.1.4.3, “Replication Slave Options and Variables”

--slave-pending-jobs-size-max

Section 16.1.4.3, “Replication Slave Options and Variables”

slave-rows-search-algorithms

Section 16.1.4.2, “Replication Master Options and Variables”

--slave-skip-errors

Section 16.1.4.3, “Replication Slave Options and Variables”
Section 16.4.1.26, “Slave Errors During Replication”

--slave-sql-verify-checksum

Section 16.1.4.4, “Binary Log Options and Variables”
Section 16.1.4.3, “Replication Slave Options and Variables”

--slave_compressed_protocol

Section 16.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”
Section 1.4, “What Is New in MySQL 5.6”

--slow_query_log_file

Section 5.4, “Running Multiple MySQL Instances on One Machine”
Section 5.1.3, “Server Command Options”
Section 5.2.5, “The Slow Query Log”
Section 1.4, “What Is New in MySQL 5.6”

--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.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.14, “mysql_setpermission — Interactively Set Permissions in Grant Tables”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.10, “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, “mysql_config — Get Compile Options for Compiling Clients”
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.9.4, “MySQL Source-Configuration Options”
Section 5.4, “Running Multiple MySQL Instances on One Machine”
Section 5.4.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.3, “Server Command Options”
Section 22.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
Section 2.3.4.9, “Testing The MySQL Installation”
Section 5.4.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”

--sort_buffer_size

Section 4.6.3.6, “myisamchk Memory Usage”

--spassword

Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”

--sporadic-binlog-dump-fail

Section 16.1.4.4, “Binary Log Options and Variables”

--sql-mode

Chapter 12, Functions and Operators
Section 1.8.2, “Selecting SQL Modes”
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.3, “mysql_install_db — Initialize MySQL Data Directory”

--ssl

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”
Section 6.3.8.4, “SSL Command Options”

--ssl*

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”

--ssl-ca

Section 13.7.1.4, “GRANT Syntax”
Section 6.3.8.5, “Setting Up SSL Certificates and Keys for MySQL”
Section 6.3.8.4, “SSL Command Options”
Section 6.3.8.3, “Using SSL Connections”

--ssl-capath

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

--ssl-cert

Section 13.7.1.4, “GRANT Syntax”
Section 6.3.8.5, “Setting Up SSL Certificates and Keys for MySQL”
Section 6.3.8.4, “SSL Command Options”
Section 6.3.8.3, “Using SSL Connections”

--ssl-cipher

Section 6.3.8.4, “SSL Command Options”

--ssl-crl

Section 6.3.8.4, “SSL Command Options”

--ssl-crlpath

Section 6.3.8.4, “SSL Command Options”

--ssl-key

Section 13.7.1.4, “GRANT Syntax”
Section 6.3.8.5, “Setting Up SSL Certificates and Keys for MySQL”
Section 6.3.8.4, “SSL Command Options”
Section 6.3.8.3, “Using SSL Connections”

--ssl-verify-server-cert

Section 6.3.8.4, “SSL Command Options”

--ssl-xxx

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

--standalone

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

--start-datetime

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

--start-position

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

--start_row

Section 4.6.12, “mysql_find_rows — Extract SQL Statements from Files”

--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.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 7.5.1, “Point-in-Time Recovery Using Event Times”

--stop-never

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8.4, “Specifying the mysqlbinlog Server ID”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”

--stop-never-slave-server-id

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8.4, “Specifying the mysqlbinlog Server ID”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”

--stop-position

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

--suffix

Section 4.6.10, “mysqlhotcopy — A Database Backup Program”

--super-large-pages

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

--superuser

Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”

--symbolic-links

Section 5.1.3, “Server Command Options”

--symbols-file

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

SYSCONFDIR

Section 4.2.3.3, “Using Option Files”

--sysdate-is-now

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

--syslog

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

--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.7, “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.16, “mysql_zap — Kill Processes That Match a Pattern”
Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “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.7, “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”
Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”

--table-cache

Section 1.4, “What Is New in MySQL 5.6”

--table_open_cache

Section 8.4.3.1, “How MySQL Opens and Closes Tables”

--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 22.4.1.4, “Debugging mysqld under gdb

--thread_handling

Section 5.1.3, “Server Command Options”
Section 1.4, “What Is New in MySQL 5.6”

--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 16.4.1.29, “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.10, “mysqlhotcopy — A Database Backup Program”
Section 4.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.4, “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.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8.4, “Specifying the mysqlbinlog Server ID”
Section 4.6.8.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.4.1, “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”

--type

Section 4.6.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”

--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 4.6.7, “mysqlaccess — Client for Checking Access Privileges”

-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, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.10, “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.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.2.1, “Invoking MySQL Programs”
Section 5.1.3, “Server Command Options”
Section 2.3.4.9, “Testing The MySQL Installation”
Section 6.3.1, “User Names and Passwords”
Section 2.3.7, “Windows Postinstallation Procedures”

--unbuffered

Section 4.5.1.1, “mysql Options”

--unpack

Section 4.6.3.3, “myisamchk Repair Options”
Section 14.3.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 14.3, “The MyISAM Storage Engine”

--upgrade-system-tables

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

--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.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.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.14, “mysql_setpermission — Interactively Set Permissions in Grant Tables”
Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.10, “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_install_db — Initialize MySQL Data Directory”
Section 4.4.7, “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.6, “Pluggable Authentication”
Section C.5.4.1.2, “Resetting the Root Password: Unix Systems”
Section 5.1.3, “Server Command Options”
Section 6.3.6.4, “The Socket Peer-Credential Authentication Plugin”
Section 6.3.6.5, “The Test Authentication Plugin”
Section 2.10.1, “Unix Postinstallation Procedures”
Section 6.3.1, “User Names and Passwords”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 4.2.3.3, “Using Option Files”

user

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.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.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.15, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.6.8, “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.3, “my_print_defaults — Display Options from Option Files”
Section 4.7.4, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.4.4, “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.8.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.15, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “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.3, “my_print_defaults — Display Options from Option Files”
Section 4.4.4, “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.2.7, “InnoDB Startup Options and System Variables”
Section 4.6.8, “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.8.2, “mysqlbinlog Row Event Display”
Section 16.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
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.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.15, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “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.3, “my_print_defaults — Display Options from Option Files”
Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.4, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.7, “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.10.1.3, “Starting and Troubleshooting the MySQL Server”
Section 8.11.2, “Tuning Server Parameters”
Section 16.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.8, “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.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.6.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.15, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.6.7, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.8, “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.3, “my_print_defaults — Display Options from Option Files”
Section 4.7.2, “mysql_config — Get Compile Options for Compiling Clients”
Section 4.7.4, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.4.4, “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”

--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.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.3, “mysql_install_db — Initialize MySQL Data Directory”

--with-mysql-sock

Section 21.10.4, “MySQL Functions (PDO_MYSQL) (MySQL (PDO))”

--with-pdo-mysql

Section 21.10.4, “MySQL Functions (PDO_MYSQL) (MySQL (PDO))”

--with-zlib-dir

Section 21.10.4, “MySQL Functions (PDO_MYSQL) (MySQL (PDO))”

WITH_DEBUG

Section 2.9.4, “MySQL Source-Configuration Options”

WITH_PERFSCHEMA_STORAGE_ENGINE

Section 20.2.1, “Performance Schema Build Configuration”

WITH_ZLIB

Section 2.9.4, “MySQL Source-Configuration Options”

--write-binlog

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 16.1.4.5, “Global Transaction ID Options and Variables”
Section 16.1.3.3, “Restrictions on Replication with GTIDs”

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”