Skip navigation links
Privileges Index »
Section Navigation      [Toggle]

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.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.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.2, “Server Command Options”
Section 22.5.3, “The DBUG Package”

/i

Section 2.3.3.2, “Automating MySQL Installation on Microsoft Windows using the MSI Package”

/passive

Section 2.3.3.2, “Automating MySQL Installation on Microsoft Windows using the MSI Package”

/quiet

Section 2.3.3.2, “Automating MySQL Installation on Microsoft Windows using the MSI Package”

/uninstall

Section 2.3.3.2, “Automating MySQL Installation on Microsoft Windows using the MSI Package”

/x

Section 2.3.3.2, “Automating MySQL Installation on Microsoft Windows using the MSI 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.14, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.6.15, “mysql_zap — Kill Processes That Match a Pattern”
Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.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.2, “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 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.6.3.4, “Other myisamchk Options”

--abort-slave-event-count

Section 16.1.4.3, “Replication Slave Options and Variables”

--add-drop-database

Section 4.5.4, “mysqldump — A Database Backup Program”

--add-drop-table

Section 4.5.4, “mysqldump — A Database Backup Program”

--add-drop-trigger

Section 4.5.4, “mysqldump — A Database Backup Program”

--add-locks

Section 4.5.4, “mysqldump — A Database Backup Program”

--addtodest

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--all-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 Tables for MySQL Upgrade”
Section 9.2.3, “Mapping of Identifiers to File Names”
Section 2.11.4, “Rebuilding or Repairing Tables or Indexes”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”

--all-in-1

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--all-tablespaces

Section 4.5.4, “mysqldump — A Database Backup Program”

--allow-keywords

Section 4.5.4, “mysqldump — A Database Backup Program”

--allow-suspicious-udfs

Section 6.1.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 22.3.2.6, “User-Defined Function Security Precautions”

--allowold

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--analyze

Section 4.6.3.1, “myisamchk General Options”
Section 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.2, “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.3, “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.6, “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.2, “Server Command Options”

--back_log

Section 2.6, “Installing MySQL on Solaris and OpenSolaris”

--backup

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

--base64-output

Section 4.6.7.2, “mysqlbinlog Row Event Display”
Section 16.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 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 Tables for MySQL Upgrade”
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.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “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.5.2, “Creating an Option File”
Section 2.3.4.13, “MySQL Server Instance Config Wizard: Creating an Instance from the Command Line”
Section 2.10.1.2, “Starting and Stopping MySQL Automatically”
Section 2.3.6, “Troubleshooting a MySQL Installation Under Windows”

--batch

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

--big-tables

Section 5.1.2, “Server Command Options”

--binary-mode

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

--bind-address

Section 4.5.1.1, “mysql Options”
Section C.5.2.2, “Can't connect to [local] MySQL server”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 5.1.8.2, “Configuring the MySQL Server to Permit IPv6 Connections”
Section 5.1.8.4, “Connecting Using IPv6 Nonlocal Host Addresses”
Section 5.1.8.3, “Connecting Using the IPv6 Local Host Address”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 5.1.8, “IPv6 Support”
Section 5.1.8.5, “Obtaining an IPv6 Address from a Broker”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “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.7, “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.2, “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 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.2.4.2, “Setting The Binary Log Format”

--binlog-rows-query-log-events

Section 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.2, “Server Command Options”

--brief

Section 4.6.6, “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.2, “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.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”
Section 2.3.4.13, “MySQL Server Instance Config Wizard: Creating an Instance from the Command Line”

--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.2, “Server Command Options”
Section 10.1.14.7.1, “The cp932 Character Set”

--character-set-filesystem

Section 5.1.2, “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.2, “Server Command Options”

--character-sets-dir

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

--checkpoint

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--chroot

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 5.1.2, “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.3.3, “Running Multiple MySQL Instances on Unix”

--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.2, “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.6, “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”

--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.3, “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.2, “Server Command Options”
Section 2.3.5.4, “Starting the Server for the First Time”
Section 5.2.2, “The Error Log”

--copy

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

--core-file

Section 22.5.1.4, “Debugging mysqld under gdb”
Section 5.1.2, “Server Command Options”

--core-file-size

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.1.2, “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.5.1.1, “Compiling MySQL for Debugging”
Section 22.5.2, “Debugging a MySQL Client”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 2.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 6.1.6, “Security Issues with LOAD DATA LOCAL”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “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.4, “Tracing mysqld Using DTrace”
Section 6.3.8.2, “Using SSL Connections”
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.6, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.4.4, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.6.3.4, “Other myisamchk Options”
Section 5.1.3, “Server System Variables”

--data-file-length

Section 4.6.3.3, “myisamchk Repair Options”

--database

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

--databases

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 2.11.4, “Rebuilding or Repairing Tables or Indexes”

--datadir

Section 2.3.5.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 Tables for MySQL Upgrade”
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.3, “Running Multiple MySQL Instances on One Machine”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 5.3.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.5.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.6, “Troubleshooting a MySQL Installation Under Windows”
Section E.10.5, “Windows Platform Limitations”

--db

Section 4.6.6, “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.5.1.1, “Compiling MySQL for Debugging”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.3, “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.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 2.10.1.3, “Starting and Troubleshooting the MySQL Server”
Section 2.3.5.5, “Starting MySQL from the Windows Command Line”
Section 22.5.3, “The DBUG Package”

--debug-check

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

--debug-info

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

--debug-sync-timeout

Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--default-auth

Section 4.5.1.1, “mysql Options”
Section 22.2.4.2.3, “Client Plugin Descriptors”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.7, “mysql_upgrade — Check Tables for MySQL Upgrade”
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-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.3, “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.2, “Server Command Options”
Section 5.1.3, “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.27, “Replication and Time Zones”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--default-tmp-storage-engine

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

--default.key_buffer_size

Section 5.1.4.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.3.1, “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.3.1, “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.2, “End-User Guidelines for Password Security”
Section 2.9.4, “MySQL Source-Configuration Options”
Section C.5.4.1.1, “Resetting the Root Password: Windows Systems”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 5.3.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 5.3.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 2.3.5.7, “Starting MySQL as a Windows Service”
Section 2.3.4.1, “Starting the MySQL Server Instance Configuration Wizard”

--defaults-group-suffix

Section 4.2.3.3.1, “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 5.1.2, “Server Command Options”
Section C.5.4.2, “What to Do If MySQL Keeps Crashing”

--delay_key_write

Section 5.1.3, “Server System Variables”
Section 5.1.4, “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.5.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.2, “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.3, “Restrictions on Replication with GTIDs”
Section 16.1.3.2, “Setting Up Replication Using GTIDs”

--disable-keys

Section 4.5.4, “mysqldump — A Database Backup Program”

--disable-log-bin

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

--disable-named-commands

Section 4.5.1.1, “mysql Options”

--disable-plugin_name

Section 5.1.7.1, “Installing and Uninstalling Plugins”

DISABLE_GRANT_OPTIONS

Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”
Section 6.1.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--disconnect-slave-event-count

Section 16.1.4.3, “Replication Slave Options and Variables”

--dryrun

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--dump

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

--dump-date

Section 4.5.4, “mysqldump — A Database Backup Program”

--dump-slave

Section 4.5.4, “mysqldump — A Database Backup Program”

E

[index top]

-E

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

-e

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 13.2.7, “LOAD XML Syntax”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
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-named-pipe

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

--enable-plugin_name

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--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.2, “Server Command Options”

--events

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

--example

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--exclude-gtids

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

--execute

Section 4.5.1.3, “mysql 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.2, “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 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--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.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.15, “mysql_zap — Kill Processes That Match a Pattern”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 22.5.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”

--fields-escaped-by

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

--fields-optionally-enclosed-by

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

--fields-terminated-by

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

--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.2, “Server Command Options”
Section 5.1.3, “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 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.9, “mysqlhotcopy — A Database Backup Program”

--force

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.10, “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 Tables for MySQL Upgrade”
Section 22.1.2, “The MySQL Test Suite”
Section 3.5, “Using mysql in Batch Mode”

--force-read

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

G

[index top]

-G

Section 4.5.1.1, “mysql Options”

-g

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

--gdb

Section 22.5.1.4, “Debugging mysqld under gdb”
Section 5.1.2, “Server Command Options”

--general-log

Section 5.1.2, “Server Command Options”

--general_log

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “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.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “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.2, “Setting Up Replication Using GTIDs”

H

[index top]

-H

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

-h

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

--header_file

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

--HELP

Section 4.6.3.1, “myisamchk General Options”

--help

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.10, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.11, “mysql_find_rows — Extract SQL Statements from Files”
Section 4.6.13, “mysql_setpermission — Interactively Set Permissions in Grant Tables”
Section 4.6.14, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.6.15, “mysql_zap — Kill Processes That Match a Pattern”
Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.3, “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 Tables for MySQL Upgrade”
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.2, “Server Command Options”
Section 2.10.1.3, “Starting and Troubleshooting the MySQL Server”
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.7.1, “mysqlbinlog Hex Dump Format”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--host

Section 4.5.1.1, “mysql Options”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 5.1.8.2, “Configuring the MySQL Server to Permit IPv6 Connections”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.6.10, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.13, “mysql_setpermission — Interactively Set Permissions in Grant Tables”
Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
Section 5.1.2, “Server Command Options”
Section 1.2, “Typographical and Syntax Conventions”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 5.3.4, “Using Client Programs in a Multiple-Server Environment”
Section 4.2.3.3, “Using Option Files”
Section 4.2.3.1, “Using Options on the Command Line”

--howto

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

--html

Section 4.5.1.1, “mysql Options”

I

[index top]

-I

Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.14, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.6.15, “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.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.4, “mysql_plugin — Configure MySQL Server Plugins”
Section 22.5.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.2, “Server Command Options”
Section 5.1.3, “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.7, “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.11, “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 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.2, “Server Command Options”
Section 5.1.3, “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-autoinc-lock-mode

Section 14.2.2.4.2, “Configurable InnoDB Auto-Increment Locking”

innodb-status-file

Section 14.2.5.3, “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.2, “Server Command Options”

--innodb_checksums

Section 14.2.7, “InnoDB Startup Options and System Variables”

--innodb_file_per_table

Section 5.1.2, “Server Command Options”
Section 14.2.2.1, “Using File-Per-Table Mode”

innodb_file_per_table

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

--innodb_rollback_on_timeout

Section 14.2.4.15, “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.3.1, “Command-Line Options that Affect Option-File Handling”
Section 5.1.2, “Server Command Options”
Section 5.3.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 2.3.5.7, “Starting MySQL as a Windows Service”

--install-manual

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

--iterations

Section 4.5.7, “mysqlslap — Load Emulation Client”

J

[index top]

-j

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

--join

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

K

[index top]

-K

Section 4.5.4, “mysqldump — A Database Backup Program”

-k

Section 4.6.3.3, “myisamchk Repair Options”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”

--keep_files_on_create

Section 13.1.14, “CREATE TABLE Syntax”

--keepold

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--key_buffer_size

Section 5.1.2, “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 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 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 2.13.3, “Problems Using the Perl DBI/DBD Interface”
Section 5.1.2, “Server Command Options”

--language

Section 5.1.2, “Server Command Options”

--large-pages

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

--lc-messages

Section 5.1.2, “Server Command Options”

--lc-messages-dir

Section 5.1.2, “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”

--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.6, “LOAD DATA INFILE Syntax”
Section 13.2.7, “LOAD XML Syntax”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”
Section 6.1.4, “Security-Related mysqld Options”

--local-load

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

--local-service

Section 2.3.5.7, “Starting MySQL as a Windows Service”

--lock-all-tables

Section 4.5.4, “mysqldump — A Database Backup Program”

--lock-tables

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

--log

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 5.1.2, “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 16.1.4.4, “Binary Log Options and Variables”
Section 18.7, “Binary Logging of Stored Programs”
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 16.1.4.3, “Replication Slave Options and Variables”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.3, “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 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.5, “Option Defaults, Options Expecting Values, and the = Sign”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.2, “Server Command Options”
Section 5.2.6, “Server Log Maintenance”
Section 5.2.2, “The Error Log”

--log-isam

Section 5.1.2, “Server Command Options”

--log-output

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.2, “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.2, “Server Command Options”

--log-raw

Section 6.1.2.1, “Administrator Guidelines for Password Security”
Section 5.1.2, “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.2, “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.2, “Server Command Options”
Section 5.2.5, “The Slow Query Log”

--log-slow-queries

Section 5.1.2, “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.2, “Server Command Options”

--log-tc-size

Section 5.1.2, “Server Command Options”
Section 5.1.5, “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.2, “Server Command Options”
Section 5.2.2, “The Error Log”

--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 5.1.2, “Server Command Options”

--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 5.2, “MySQL Server Logs”
Section 16.2.2, “Replication Relay and Status Logs”
Section 4.6.7.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.4, “Binary Log Options and Variables”
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.1.4.4, “Binary Log Options and Variables”
Section 16.2.2, “Replication Relay and Status Logs”
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.4, “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 C.5.6, “Optimizer-Related Issues”

--max_a

Section 4.2.3.4, “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 5.1.4, “Using System Variables”

--maximum-var_name

Section 5.1.2, “Server Command Options”
Section 5.1.4, “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.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 14.2.3.3, “Using Raw Disk Partitions for the Shared Tablespace”

--method

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--min-examined-row-limit

Section 5.1.2, “Server Command Options”

--my-plugin

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--my-print-defaults

Section 4.4.4, “mysql_plugin — Configure MySQL Server Plugins”

--my_plugin

Section 5.1.7.1, “Installing and Uninstalling Plugins”

--myisam-block-size

Section 5.1.2, “Server Command Options”

--myisam-recover-options

Section 14.3.1, “MyISAM Startup Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section C.5.2.19, “Table-Corruption Issues”
Section 14.3, “The MyISAM Storage Engine”
Section 22.5.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.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.7.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”

--no-data

Section 4.5.4, “mysqldump — A Database Backup Program”

--no-defaults

Section 6.2.7, “Causes of Access-Denied Errors”
Section 4.2.3.3.1, “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.9, “mysqlhotcopy — A Database Backup Program”

--number-char-cols

Section 4.5.7, “mysqlslap — Load Emulation Client”

--number-int-cols

Section 4.5.7, “mysqlslap — Load Emulation Client”

--number-of-queries

Section 4.5.7, “mysqlslap — Load Emulation Client”

--numeric-dump-file

Section 4.7.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 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--offset

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

--old-alter-table

Section 5.1.2, “Server Command Options”

--old-passwords

Section C.5.2.4, “Client does not support authentication protocol”
Section 6.1.2.3, “Password Hashing in MySQL”
Section 6.1.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”

--old-style-user-limits

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

--old_server

Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

ON

Section 3.3.4.9, “Using More Than one Table”

--one-database

Section 4.5.1.1, “mysql Options”

--one-thread

Section 5.1.2, “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 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--opt

Section 4.5.4, “mysqldump — A Database Backup Program”

--opt_name

Section 4.2.3.3, “Using Option Files”

--optimize

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--order-by-primary

Section 4.5.4, “mysqldump — A Database Backup Program”

--out_dir

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

--out_file

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

P

[index top]

-P

Section 4.5.1.1, “mysql Options”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.4, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.2.1, “Invoking MySQL Programs”
Section 5.1.2, “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, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.4, “mysql_plugin — Configure MySQL Server Plugins”
Section 6.1.2.2, “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.5.7, “Starting MySQL as a Windows Service”
Section 2.3.5.5, “Starting MySQL from the Windows Command Line”
Section 2.3.5.8, “Testing The MySQL Installation”
Section 2.3.7, “Upgrading MySQL on Windows”
Section 6.3.1, “User Names and Passwords”
Section 4.2.3.1, “Using Options on the Command Line”
Section 2.3.8, “Windows Postinstallation Procedures”

--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.2, “Server Command Options”

--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.10, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.13, “mysql_setpermission — Interactively Set Permissions in Grant Tables”
Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.7, “mysql_upgrade — Check Tables for MySQL Upgrade”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 6.1.2.2, “End-User Guidelines for Password Security”
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.4, “The Test Authentication Plugin”
Section 6.3.1, “User Names and Passwords”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 4.2.3.1, “Using Options on the Command Line”

--performance_schema_consumer_consumer_name

Section 5.1.2, “Server Command Options”

--performance_schema_instrument

Section 5.1.2, “Server Command Options”

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.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--pipe

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

--plan

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

--plugin

Section 5.1.2, “Server Command Options”

--plugin-dir

Section 4.5.1.1, “mysql Options”
Section 22.2.4.2.3, “Client Plugin Descriptors”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.4, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.4.7, “mysql_upgrade — Check Tables for MySQL Upgrade”
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.2, “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.7.1, “Installing and Uninstalling Plugins”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 6.3.6, “Pluggable Authentication”
Section 22.2.2, “Plugin API Components”
Section 22.2.4.2, “Plugin Data Structures”
Section 6.1.4, “Security-Related mysqld Options”
Section 5.1.2, “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.7.1, “Installing and Uninstalling Plugins”
Section 5.1.2, “Server Command Options”

--plugin-sql-mode

Section 5.1.2, “Server Command Options”

--plugin-xxx

Section 5.1.2, “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.7.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.10, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.13, “mysql_setpermission — Interactively Set Permissions in Grant Tables”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.2, “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.3, “Running Multiple MySQL Instances on One Machine”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 2.10.1.3, “Starting and Troubleshooting the MySQL Server”
Section 5.3.4, “Using Client Programs in a Multiple-Server Environment”

--port-open-timeout

Section 5.1.2, “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.6, “mysqlaccess — Client for Checking Access Privileges”

--print-defaults

Section 4.2.3.3.1, “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.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 2.3.5.4, “Starting the Server for the First Time”
Section 2.3.5.8, “Testing The MySQL Installation”
Section 5.3.4, “Using Client Programs in a Multiple-Server Environment”

Q

[index top]

-Q

Section 4.5.4, “mysqldump — A Database Backup Program”

-q

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

--query

Section 4.5.7, “mysqlslap — Load Emulation Client”

--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 4.2.3.3, “Using Option Files”

--quiet

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--quote-names

Section 4.5.4, “mysqldump — A Database Backup Program”

R

[index top]

-R

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

-r

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

--raw

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

--read-from-remote-server

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.7.4, “Specifying the mysqlbinlog Server ID”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 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.9, “mysqlhotcopy — A Database Backup Program”

--recover

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

--regexp

Section 4.6.11, “mysql_find_rows — Extract SQL Statements from Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--relative

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

--relay-log

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 16.3.5, “Improving Replication Performance”
Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
Section 4.2.3.5, “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.4, “Binary Log Options and Variables”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 16.2.2.2, “Slave Status Logs”

--relay-log-info-repository

Section 16.1.4.4, “Binary Log Options and Variables”
Section 16.2.2, “Replication Relay and Status Logs”
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.6, “mysqlaccess — Client for Checking Access Privileges”

--remove

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

--repair

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--replace

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

--replicate-*

Section 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 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.23, “Replication and Reserved Words”
Section 16.4.1.20, “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.23, “Replication and Reserved Words”
Section 16.4.1.20, “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 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.23, “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.23, “Replication and Reserved Words”
Section 16.4.1.20, “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.20, “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.20, “Replication and Temporary Tables”
Section 16.1.4.3, “Replication Slave Options and Variables”

replication-ignore-table

Section 16.4.1.30, “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.3, “Server System Variables”

--report-password

Section 16.1.4.3, “Replication Slave Options and Variables”
Section 5.1.3, “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.3, “Server System Variables”

--report-user

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

--resetmaster

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--resetslave

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--result-file

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

--rhost

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

--rollback

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

--routines

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

--rows

Section 4.6.11, “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 4.2.2, “Connecting to the MySQL Server”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.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.15, “mysql_zap — Kill Processes That Match a Pattern”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.4, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.4.7, “mysql_upgrade — Check Tables for MySQL Upgrade”
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.2, “Server Command Options”

--safe-mode

Section 5.1.2, “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 6.1.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”

--secure-auth

Section 4.5.1.1, “mysql Options”
Section 6.1.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”

--secure-file-priv

Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 6.1.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “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.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 16.1.4, “Replication and Binary Logging Options and Variables”
Section 5.1.3, “Server System Variables”
Section 16.4.4, “Troubleshooting Replication”

--service-startup-timeout

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

--set-auto-increment

Section 4.6.3.4, “Other myisamchk Options”

--set-character-set

Section 4.6.3.3, “myisamchk Repair Options”

--set-charset

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

--set-collation

Section 4.6.3.3, “myisamchk Repair Options”

--shared-memory

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

--shared-memory-base-name

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

--short-form

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

--show-slave-auth-info

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

--single-transaction

Section 14.2.3.4, “Backing Up and Recovering an InnoDB Database”
Section 4.5.4, “mysqldump — A Database Backup Program”

--skip

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.2.3.2, “Program Option Modifiers”
Section 5.1.2, “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.2, “Server Command Options”
Section 5.1.3, “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.2, “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.2, “Server Command Options”

--skip-extended-insert

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-external-locking

Section 5.1.2, “Server Command Options”
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.7.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 6.1.4, “Security-Related mysqld Options”
Section 5.1.2, “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.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--skip-host-cache

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

--skip-innodb

Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “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 2.10.2, “Securing the Initial MySQL Accounts”
Section 6.1.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 2.3.5.8, “Testing The MySQL Installation”

--skip-named-commands

Section 4.5.1.1, “mysql Options”

--skip-networking

Section C.5.2.2, “Can't connect to [local] MySQL server”
Section C.5.2.9, “MySQL server has gone away”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 6.3.6, “Pluggable Authentication”
Section C.5.4.1.3, “Resetting the Root Password: Generic Instructions”
Section 6.1.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “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.5.1, “Debugging a MySQL Server”
Section 5.1.3, “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.2, “Server Command Options”

--skip-plugin-innodb_file_per_table

Section 5.1.2, “Server Command Options”

--skip-plugin_name

Section 5.1.7.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 4.5.1.6.4, “Disabling mysql Auto-Reconnect”

--skip-secure-auth

Section 6.1.4, “Security-Related mysqld Options”
Section 5.1.2, “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 6.1.4, “Security-Related mysqld Options”
Section 5.1.2, “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.3, “SSL Command Options”

--skip-stack-trace

Section 22.5.1.4, “Debugging mysqld under gdb”
Section 5.1.2, “Server Command Options”

--skip-super-large-pages

Section 5.1.2, “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.2, “Server Command Options”

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

--skip-triggers

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-tz-utc

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-use-db

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

--skip-write-binlog

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

--skip_grant_tables

Section 4.2.3.1, “Using Options on the Command Line”

--slave-load-tmpdir

Section 16.3.1.2, “Backing Up Raw Data from a Slave”
Section 16.1.4.3, “Replication Slave 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-skip-errors

Section 16.1.4.3, “Replication Slave Options and Variables”
Section 16.4.1.24, “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.2, “Server Command Options”

--slow-start-timeout

Section 5.1.2, “Server Command Options”

--slow_query_log

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “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.3, “Running Multiple MySQL Instances on One Machine”
Section 5.1.2, “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.10, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.13, “mysql_setpermission — Interactively Set Permissions in Grant Tables”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.2, “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.3, “Running Multiple MySQL Instances on One Machine”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.2, “Server Command Options”
Section 22.2.4.2.1, “Server Plugin Library and Plugin Descriptors”
Section 2.3.5.8, “Testing The MySQL Installation”
Section 5.3.4, “Using Client Programs in a Multiple-Server Environment”

socket

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

--sort-index

Section 4.6.3.4, “Other myisamchk Options”

--sort-records

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.6, “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.2, “Server Command Options”
Section 5.1.6, “Server SQL Modes”

sql-mode

Section 5.1.6, “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 6.1.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 6.3.8.3, “SSL Command Options”
Section 6.3.8.2, “Using SSL Connections”

--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 6.1.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”

--ssl-ca

Section 13.7.1.3, “GRANT Syntax”
Section 6.3.8.3, “SSL Command Options”
Section 6.3.8.2, “Using SSL Connections”

--ssl-capath

Section 6.3.8.3, “SSL Command Options”

--ssl-cert

Section 13.7.1.3, “GRANT Syntax”
Section 6.3.8.3, “SSL Command Options”
Section 6.3.8.2, “Using SSL Connections”

--ssl-cipher

Section 6.3.8.3, “SSL Command Options”

--ssl-crl

Section 6.3.8.3, “SSL Command Options”

--ssl-crlpath

Section 6.3.8.3, “SSL Command Options”

--ssl-key

Section 13.7.1.3, “GRANT Syntax”
Section 6.3.8.3, “SSL Command Options”
Section 6.3.8.2, “Using SSL Connections”

--ssl-verify-server-cert

Section 6.3.8.3, “SSL Command Options”

--ssl-xxx

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 5.1.3, “Server System Variables”
Section 6.3.8.2, “Using SSL Connections”

--standalone

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

--start-datetime

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

--start-position

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

--start_row

Section 4.6.11, “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.7, “mysqlbinlog — Utility for Processing Binary Log Files”

--stop-never

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

--stop-never-slave-server-id

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

--stop-position

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

--suffix

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

--super-large-pages

Section 5.1.2, “Server Command Options”

--superuser

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

--symbolic-links

Section 5.1.2, “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.12, “Replication and System Functions”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “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 Tables for MySQL Upgrade”
Section 5.1.2, “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.15, “mysql_zap — Kill Processes That Match a Pattern”
Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.4.7, “mysql_upgrade — Check Tables for MySQL Upgrade”
Section 2.3.4.13, “MySQL Server Instance Config Wizard: Creating an Instance from the Command Line”
Section 5.1.2, “Server Command Options”

--tab

Section 4.5.4, “mysqldump — A Database Backup Program”

--table

Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”

--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.2, “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.2, “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.5.1.4, “Debugging mysqld under gdb”

--thread_handling

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

--timezone

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

tmpdir

Section 2.3, “Installing MySQL on Microsoft Windows”

--tmpdir

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

--to-last-log

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

--transaction-isolation

Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 14.2.4.1, “The InnoDB Transaction Model and Locking”

--transaction-read-only

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

--triggers

Section 4.5.4, “mysqldump — A Database Backup Program”

--type

Section 4.6.10, “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.6, “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, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.7, “mysql_upgrade — Check Tables for MySQL Upgrade”
Section 4.2.1, “Invoking MySQL Programs”
Section 5.1.2, “Server Command Options”
Section 2.3.5.8, “Testing The MySQL Installation”
Section 6.3.1, “User Names and Passwords”
Section 2.3.8, “Windows Postinstallation Procedures”

--unbuffered

Section 4.5.1.1, “mysql Options”

--unpack

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

--upgrade-system-tables

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

--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.10, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.13, “mysql_setpermission — Interactively Set Permissions in Grant Tables”
Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.7, “mysql_upgrade — Check Tables for MySQL Upgrade”
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 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.5, “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.2, “Server Command Options”
Section 6.3.6.3, “The Socket Peer-Credential Authentication Plugin”
Section 6.3.6.4, “The Test Authentication Plugin”
Section 2.10.1, “Unix Postinstallation Procedures”
Section 6.3.1, “User Names and Passwords”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 4.2.3.3, “Using Option Files”

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.14, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.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.2, “Server Command Options”
Section 4.2.3.1, “Using Options on the Command Line”

-v

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.7.2, “mysqlbinlog Row Event Display”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.14, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.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 4.6.3.5, “Obtaining Table Information with myisamchk”
Section 5.1.2, “Server Command Options”
Section 4.2.3.1, “Using Options on the Command Line”

--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.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 5.1.2, “Server Command Options”

--verbose

Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.7.2, “mysqlbinlog Row Event Display”
Section 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.10, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.14, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.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 Tables for MySQL Upgrade”
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.2, “Server Command Options”
Section 2.10.1.3, “Starting and Troubleshooting the MySQL Server”
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”

--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.10, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.14, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.7.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.2, “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.2, “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.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”

--where

Section 4.5.4, “mysqldump — A Database Backup Program”

--windows

Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”

WITH_COMMENT

Section 5.1.3, “Server System Variables”

WITH_DEBUG

Section 2.9.4, “MySQL Source-Configuration Options”

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 Tables for MySQL Upgrade”

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”
Copyright © 1997, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices