Option Index

Symbols

[index top]

--

Section 1.8.5.5, "'--' as the Start of a Comment"

Section 4.8.2, "replace — A String-Replacement Utility"

-#

Section 4.6.3.1, "myisamchk General Options"

Section 4.5.1.1, "mysql Options"

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

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.7.3, "my_print_defaults — Display Options from Option Files"

Section 4.4.1, "comp_err — Compile MySQL Error Message File"

Section 4.8.2, "replace — A String-Replacement Utility"

Section 5.1.3, "Server Command Options"

Section 22.4.3, "The DBUG Package"

/opt/mysql/server-

Section 2.5.2, "Installing MySQL on Linux Using Debian Packages"

-1

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

-?

Section 4.6.3.1, "myisamchk General Options"

Section 4.5.1.1, "mysql Options"

Section 4.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

Section 4.6.2, "myisam_ftdump — Display Full-Text Index information"

Section 4.6.4, "myisamlog — Display MyISAM Log File Contents"

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

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

Section 4.6.15, "mysql_waitpid — Kill Process and Wait for Its Termination"

Section 4.6.16, "mysql_zap — Kill Processes That Match a Pattern"

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.7.3, "my_print_defaults — Display Options from Option Files"

Section 4.4.1, "comp_err — Compile MySQL Error Message File"

Section 4.4.4, "mysql_plugin — Configure MySQL Server Plugins"

Section 4.8.1, "perror — Explain Error Codes"

Section 4.8.2, "replace — A String-Replacement Utility"

Section 4.8.3, "resolveip — Resolve Host name to IP Address or ViceVersa"

Section 5.1.3, "Server Command Options"

Section 4.2.3.1, "Using Options on the Command Line"

A

[index top]

-A

Section 4.5.1.1, "mysql Options"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.6.3.4, "Other myisamchk Options"

-a

Section 7.6.4, "MyISAM Table Optimization"

Section 4.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

Section 4.6.9, "mysqldumpslow — Summarize Slow Query Log Files"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.6.3.4, "Other myisamchk Options"

--abort-slave-event-count

Section 16.1.4.3, "Replication Slave Options and Variables"

--add-drop-database

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 7.4.1, "Dumping Data in SQL Format with mysqldump"

--add-drop-table

Section 4.5.4, "mysqldump — A Database Backup Program"

--add-drop-trigger

Section 4.5.4, "mysqldump — A Database Backup Program"

--add-locks

Section 4.5.4, "mysqldump — A Database Backup Program"

--addtodest

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

--all

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

--all-databases

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.4.7, "mysql_upgrade — Check and Upgrade MySQL Tables"

Section 7.4.1, "Dumping Data in SQL Format with mysqldump"

Section 9.2.3, "Mapping of Identifiers to File Names"

Section 2.11.4, "Rebuilding or Repairing Tables or Indexes"

Section 7.4.2, "Reloading SQL-Format Backups"

Section 2.11.1.1, "Upgrading from MySQL 5.6 to 5.7"

Section 4.6.8.3, "Using mysqlbinlog to Back Up Binary Log Files"

--all-in-1

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

--all-tablespaces

Section 4.5.4, "mysqldump — A Database Backup Program"

--allow-keywords

Section 4.5.4, "mysqldump — A Database Backup Program"

--allow-mismatches

Section 4.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

Section 14.2.5.13, "Enhanced innochecksum Capability"

--allow-suspicious-udfs

Section 5.1.3, "Server Command Options"

Section 22.3.2.6, "User-Defined Function Security Precautions"

--allowold

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

--analyze

Section 4.6.3.1, "myisamchk General Options"

Section 7.6.4, "MyISAM Table Optimization"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.6.3.4, "Other myisamchk Options"

--ansi

Section 1.8.3, "Running MySQL in ANSI Mode"

Section 5.1.3, "Server Command Options"

--apply-slave-statements

Section 4.5.4, "mysqldump — A Database Backup Program"

--audit-log

Section 6.3.11.5, "Audit Log Plugin Options and Variables"

Section 6.3.11.1, "Installing the Audit Log Plugin"

--auto-generate-sql

Section 4.5.7, "mysqlslap — Load Emulation Client"

--auto-generate-sql-add-autoincrement

Section 4.5.7, "mysqlslap — Load Emulation Client"

--auto-generate-sql-execute-number

Section 4.5.7, "mysqlslap — Load Emulation Client"

--auto-generate-sql-guid-primary

Section 4.5.7, "mysqlslap — Load Emulation Client"

--auto-generate-sql-load-type

Section 4.5.7, "mysqlslap — Load Emulation Client"

--auto-generate-sql-secondary-indexes

Section 4.5.7, "mysqlslap — Load Emulation Client"

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

Section 4.5.7, "mysqlslap — Load Emulation Client"

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

Section 4.5.7, "mysqlslap — Load Emulation Client"

--auto-generate-sql-write-number

Section 4.5.7, "mysqlslap — Load Emulation Client"

--auto-rehash

Section 4.5.1.2, "mysql Commands"

Section 4.5.1.1, "mysql Options"

--auto-repair

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

--auto-vertical-output

Section 4.5.1.1, "mysql Options"

--autocommit

Section 5.1.4, "Server System Variables"

B

[index top]

-B

Section 4.6.3.3, "myisamchk Repair Options"

Section 4.5.1.1, "mysql Options"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

-b

Section 4.5.1.1, "mysql Options"

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

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.4.4, "mysql_plugin — Configure MySQL Server Plugins"

Section 4.6.3.4, "Other myisamchk Options"

Section 5.1.3, "Server Command Options"

--back_log

Section 2.6, "Installing MySQL on Solaris and OpenSolaris"

--backup

Section 4.6.3.3, "myisamchk Repair Options"

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

--base64-output

Section 4.6.8.2, "mysqlbinlog Row Event Display"

Section 16.1.2.1, "Advantages and Disadvantages of Statement-Based and Row-BasedReplication"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 16.1.3.1, "GTID Concepts"

Section 16.1.2.2, "Usage of Row-Based Logging and Replication"

--basedir

Section 4.4.3, "mysql_install_db — Initialize MySQL Data Directory"

Section 4.4.4, "mysql_plugin — Configure MySQL Server Plugins"

Section 4.4.7, "mysql_upgrade — Check and Upgrade MySQL Tables"

Section 4.3.3, "mysql.server — MySQL Server Startup Script"

Section 4.3.2, "mysqld_safe — MySQL Server Startup Script"

Section 2.9.4, "MySQL Source-Configuration Options"

Section 5.6, "Running Multiple MySQL Instances on One Machine"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

Section 2.10.1.3, "Starting and Troubleshooting the MySQL Server"

Section 2.10.1, "Unix Postinstallation Procedures"

Section 1.4, "What Is New in MySQL 5.7"

basedir

Section 2.3.5.2, "Creating an Option File"

Section 2.10.1.2, "Starting and Stopping MySQL Automatically"

Section 2.3.6, "Troubleshooting a Microsoft Windows MySQL Server Installation"

--batch

Section 4.5.1.3, "mysql Logging"

Section 4.5.1.1, "mysql Options"

--big-tables

Section 5.1.3, "Server Command Options"

--binary-mode

Section 4.5.1.2, "mysql Commands"

Section 4.5.1.1, "mysql Options"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

--bind-address

Section 4.5.1.1, "mysql Options"

Section C.5.2.2, "Can't connect to [local] MySQL server"

Section 6.2.7, "Causes of Access-Denied Errors"

Section 5.1.9.2, "Configuring the MySQL Server to Permit IPv6 Connections"

Section 5.1.9.4, "Connecting Using IPv6 Nonlocal Host Addresses"

Section 5.1.9.3, "Connecting Using the IPv6 Local Host Address"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.3.4, "mysqld_multi — Manage Multiple MySQL Servers"

Section 5.1.9, "IPv6 Support"

Section 5.1.9.5, "Obtaining an IPv6 Address from a Broker"

Section 5.6, "Running Multiple MySQL Instances on One Machine"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

--binlog-checksum

Section 16.1.4.4, "Binary Log Options and Variables"

--binlog-do-db

Section 16.1.4.4, "Binary Log Options and Variables"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 16.2.3.1, "Evaluation of Database-Level Replication and Binary Logging Options"

Section 16.2.3, "How Servers Evaluate Replication Filtering Rules"

Section 16.1.4.3, "Replication Slave Options and Variables"

Section 5.2.4, "The Binary Log"

--binlog-format

Section 16.1.4.4, "Binary Log Options and Variables"

Section 5.2.4.1, "Binary Logging Formats"

Section 5.1.3, "Server Command Options"

Section 5.2.4.2, "Setting The Binary Log Format"

--binlog-ignore-db

Section 16.1.4.4, "Binary Log Options and Variables"

Section 16.2.3.1, "Evaluation of Database-Level Replication and Binary Logging Options"

Section 16.2.3, "How Servers Evaluate Replication Filtering Rules"

Section 16.1.4.3, "Replication Slave Options and Variables"

Section 5.2.4, "The Binary Log"

--binlog-row-event-max-size

Section 16.1.4.4, "Binary Log Options and Variables"

Section 4.6.8, "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 5.1.3, "Server Command Options"

--brief

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

C

[index top]

-C

Section 4.6.3.2, "myisamchk Check Options"

Section 4.5.1.1, "mysql Options"

Section 4.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.4.1, "comp_err — Compile MySQL Error Message File"

Section 5.1.3, "Server Command Options"

-c

Section 4.6.3.2, "myisamchk Check Options"

Section 4.5.1.1, "mysql Options"

Section 4.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

Section 4.6.2, "myisam_ftdump — Display Full-Text Index information"

Section 4.6.4, "myisamlog — Display MyISAM Log File Contents"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.7.3, "my_print_defaults — Display Options from Option Files"

--cflags

Section 2.9.5, "Dealing with Problems Compiling MySQL"

Section 4.7.2, "mysql_config — Display Options for Compiling Clients"

--character-set-client-handshake

Section 5.1.3, "Server Command Options"

Section 10.1.14.7.1, "The cp932 Character Set"

--character-set-filesystem

Section 5.1.3, "Server Command Options"

--character-set-server

Section 10.5, "Character Set Configuration"

Section 10.1.5, "Configuring the Character Set and Collation for Applications"

Section 16.4.1.3, "Replication and Character Sets"

Section 10.1.3.1, "Server Character Set and Collation"

Section 5.1.3, "Server Command Options"

--character-sets-dir

Section 4.6.3.3, "myisamchk Repair Options"

Section 4.5.1.1, "mysql Options"

Section C.5.2.17, "Can't initialize character set"

Section 10.5, "Character Set Configuration"

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

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 5.1.3, "Server Command Options"

--character_set_server

Section 2.9.4, "MySQL Source-Configuration Options"

--charset

Section 4.4.1, "comp_err — Compile MySQL Error Message File"

--check

Section 4.6.3.2, "myisamchk Check Options"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

--check-only-changed

Section 4.6.3.2, "myisamchk Check Options"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

--check-upgrade

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.4.7, "mysql_upgrade — Check and Upgrade MySQL Tables"

--checkpoint

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

--chroot

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

Section 5.1.3, "Server Command Options"

CMAKE_INSTALL_PREFIX

Section 22.2.4.3, "Compiling and Installing Plugin Libraries"

Section 2.9.3, "Installing MySQL Using a Development Source Tree"

Section 2.9.4, "MySQL Source-Configuration Options"

Section 5.6.3, "Running Multiple MySQL Instances on Unix"

CMAKE_PREFIX_PATH

Section 2.9.4, "MySQL Source-Configuration Options"

--collation-server

Section 10.5, "Character Set Configuration"

Section 10.1.5, "Configuring the Character Set and Collation for Applications"

Section 16.4.1.3, "Replication and Character Sets"

Section 10.1.3.1, "Server Character Set and Collation"

Section 5.1.3, "Server Command Options"

--collation_server

Section 2.9.4, "MySQL Source-Configuration Options"

--column-names

Section 4.5.1.1, "mysql Options"

Section 4.2.3.2, "Program Option Modifiers"

--column-type-info

Section 4.5.1.1, "mysql Options"

--columns

Section 4.5.5, "mysqlimport — A Data Import Program"

--comments

Section 4.5.1.1, "mysql Options"

Section 4.5.4, "mysqldump — A Database Backup Program"

--commit

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

Section 4.5.7, "mysqlslap — Load Emulation Client"

--comp

Section 4.2.3, "Specifying Program Options"

Section 1.4, "What Is New in MySQL 5.7"

--compact

Section 4.5.4, "mysqldump — A Database Backup Program"

--compatible

Section 4.5.4, "mysqldump — A Database Backup Program"

COMPILATION_COMMENT

Section 5.1.4, "Server System Variables"

--complete-insert

Section 4.5.4, "mysqldump — A Database Backup Program"

--compr

Section 4.2.3, "Specifying Program Options"

Section 1.4, "What Is New in MySQL 5.7"

--compress

Section 4.5.1.1, "mysql Options"

Section 13.2.6, "LOAD DATA INFILESyntax"

Section 6.3.9.1, "Basic SSL Concepts"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.2.3, "Specifying Program Options"

Section 1.4, "What Is New in MySQL 5.7"

--concurrency

Section 4.5.7, "mysqlslap — Load Emulation Client"

--config-file

Section 4.7.3, "my_print_defaults — Display Options from Option Files"

Section 4.3.4, "mysqld_multi — Manage Multiple MySQL Servers"

--connect-expired-password

Section 4.5.1.1, "mysql Options"

--console

Section 14.2.4.5, "InnoDB General Troubleshooting"

Section 14.2.4.4, "SHOW ENGINE INNODBSTATUS and the InnoDB Monitors"

Section 14.2.2.1, "Creating the InnoDB Tablespace"

Section C.5.4.1.1, "Resetting the Root Password: Windows Systems"

Section 5.1.3, "Server Command Options"

Section 2.3.5.4, "Starting the Server for the First Time"

Section 5.2.2, "The Error Log"

--copy

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

--core-file

Section 22.4.1.4, "Debugging mysqld under gdb"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

--core-file-size

Section 4.3.2, "mysqld_safe — MySQL Server Startup Script"

Section 5.1.3, "Server Command Options"

--correct-checksum

Section 4.6.3.3, "myisamchk Repair Options"

--count

Section 4.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

Section 4.6.2, "myisam_ftdump — Display Full-Text Index information"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

--create

Section 4.5.7, "mysqlslap — Load Emulation Client"

--create-options

Section 4.5.4, "mysqldump — A Database Backup Program"

--create-schema

Section 4.5.7, "mysqlslap — Load Emulation Client"

--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 — Display Options for Compiling Clients"

D

[index top]

-D

Section 4.6.3.3, "myisamchk Repair Options"

Section 4.5.1.1, "mysql Options"

Section C.5.2.17, "Can't initialize character set"

Section 10.3, "Adding a Character Set"

Section 2.1.2.2, "Choosing a Distribution Format"

Section 22.4.1.1, "Compiling MySQL for Debugging"

Section 21.7.1, "Compiling Programs with libmysqld"

Section 22.4.2, "Debugging a MySQL Client"

Section 4.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.4.1, "comp_err — Compile MySQL Error Message File"

Section 2.9.2, "Installing MySQL Using a Standard Source Distribution"

Section 2.9.4, "MySQL Source-Configuration Options"

Section 22.1.1, "MySQL Threads"

Chapter 17, Partitioning

Section 20.2.1, "Performance Schema Build Configuration"

Section 14.2.9.3.1, "Prerequisites for the InnoDB memcached Plugin"

Section 16.1.4.3, "Replication Slave Options and Variables"

Section 6.1.6, "Security Issues with LOADDATA LOCAL"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

Section 14.6, "The ARCHIVE Storage Engine"

Section 14.7, "The BLACKHOLE Storage Engine"

Section 14.10, "The EXAMPLE Storage Engine"

Section 14.9, "The FEDERATED Storage Engine"

Section 5.7, "Tracing mysqld Using DTrace"

Section C.5.4.2, "What to Do If MySQL Keeps Crashing"

-d

Section 4.6.3.1, "myisamchk General Options"

Section 4.6.2, "myisam_ftdump — Display Full-Text Index information"

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.6.9, "mysqldumpslow — Summarize Slow Query Log Files"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.4.4, "mysql_plugin — Configure MySQL Server Plugins"

Section 4.6.3.4, "Other myisamchk Options"

Section 5.1.4, "Server System Variables"

--data-file-length

Section 4.6.3.3, "myisamchk Repair Options"

--database

Section 4.5.1.1, "mysql Options"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

--databases

Section 7.4.5.2, "Copy a Database from one Server to Another"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 7.4.1, "Dumping Data in SQL Format with mysqldump"

Section 7.4.5.1, "Making a Copy of a Database"

Section 2.11.4, "Rebuilding or Repairing Tables or Indexes"

Section 7.4.2, "Reloading SQL-Format Backups"

--datadir

Section 2.3.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 and Upgrade MySQL Tables"

Section 4.3.3, "mysql.server — MySQL Server Startup Script"

Section 4.3.2, "mysqld_safe — MySQL Server Startup Script"

Section 2.9.4, "MySQL Source-Configuration Options"

Section 5.6, "Running Multiple MySQL Instances on One Machine"

Section 5.6.3, "Running Multiple MySQL Instances on Unix"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

Section 5.6.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"

Section 1.4, "What Is New in MySQL 5.7"

datadir

Section 2.3.5.2, "Creating an Option File"

Section 2.4.1, "General Notes on Installing MySQL on Mac OS X"

Section 2.10.1.2, "Starting and Stopping MySQL Automatically"

Section 2.3.6, "Troubleshooting a Microsoft Windows MySQL Server Installation"

Section D.10.6, "Windows Platform Limitations"

--db

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

--debug

Section 4.6.3.1, "myisamchk General Options"

Section 4.5.1.1, "mysql Options"

Section 6.2.7, "Causes of Access-Denied Errors"

Section 22.4.1.1, "Compiling MySQL for Debugging"

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

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.6.9, "mysqldumpslow — Summarize Slow Query Log Files"

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.7.3, "my_print_defaults — Display Options from Option Files"

Section 4.4.1, "comp_err — Compile MySQL Error Message File"

Section 2.9.4, "MySQL Source-Configuration Options"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

Section 2.10.1.3, "Starting and Troubleshooting the MySQL Server"

Section 2.3.5.5, "Starting MySQL from the Windows Command Line"

Section 22.4.3, "The DBUG Package"

--debug-check

Section 4.5.1.1, "mysql Options"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.4.7, "mysql_upgrade — Check and Upgrade MySQL Tables"

--debug-info

Section 4.5.1.1, "mysql Options"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.4.1, "comp_err — Compile MySQL Error Message File"

Section 4.4.7, "mysql_upgrade — Check and Upgrade MySQL Tables"

--debug-sync-timeout

Section 2.9.4, "MySQL Source-Configuration Options"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

--default-auth

Section 4.5.1.1, "mysql Options"

Section 21.8.14, "C API Client Plugin Functions"

Section 22.2.4.2.3, "Client Plugin Descriptors"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.4.7, "mysql_upgrade — Check and Upgrade MySQL Tables"

Section 6.3.7, "Pluggable Authentication"

Section 6.3.7.1, "The Native Authentication Plugins"

Section 22.2.4.9.3, "Using the Authentication Plugins"

--default-authentication-plugin

Section 13.7.1.2, "CREATE USER Syntax"

Section 5.1.3, "Server Command Options"

--default-character-set

Section 4.5.1.1, "mysql Options"

Section 13.2.6, "LOAD DATA INFILESyntax"

Section 10.5, "Character Set Configuration"

Section 10.1.5, "Configuring the Character Set and Collation for Applications"

Section 10.1.4, "Connection Character Sets and Collations"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.5.1.5, "Executing SQL Statements from a Text File"

Section 5.1.4, "Server System Variables"

Section 4.5.1.6.2, "Unicode Support on Windows"

Section 6.3.1, "User Names and Passwords"

--default-storage-engine

Section 14.2.6, "InnoDB Startup Options and System Variables"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

Section 14.1, "Setting the Storage Engine"

Section 14.2.2.8, "Turning Off InnoDB"

default-storage-engine

Section 14.1, "Setting the Storage Engine"

--default-time-zone

Section 10.6, "MySQL Server Time Zone Support"

Section 16.4.1.29, "Replication and Time Zones"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

--default-tmp-storage-engine

Section 14.2.6, "InnoDB Startup Options and System Variables"

Section 5.1.3, "Server Command Options"

Section 14.2.2.8, "Turning Off InnoDB"

--default.key_buffer_size

Section 5.1.5.1, "Structured System Variables"

DEFAULT_CHARSET

Section 10.1.5, "Configuring the Character Set and Collation for Applications"

Section 10.1.3.1, "Server Character Set and Collation"

DEFAULT_COLLATION

Section 10.1.5, "Configuring the Character Set and Collation for Applications"

Section 10.1.3.1, "Server Character Set and Collation"

--defaults-extra-file

Section 4.2.3.4, "Command-Line Options that Affect Option-File Handling"

Section 4.7.3, "my_print_defaults — Display Options from Option Files"

Section 4.3.4, "mysqld_multi — Manage Multiple MySQL Servers"

Section 4.3.2, "mysqld_safe — MySQL Server Startup Script"

Section 4.2.3.3, "Using Option Files"

--defaults-file

Section 4.2.3.4, "Command-Line Options that Affect Option-File Handling"

Section 14.2.1.2, "Configuring InnoDB"

Section 4.7.3, "my_print_defaults — Display Options from Option Files"

Section 4.3.4, "mysqld_multi — Manage Multiple MySQL Servers"

Section 4.3.2, "mysqld_safe — MySQL Server Startup Script"

Section 6.1.2.1, "End-User Guidelines for Password Security"

Section 2.9.4, "MySQL Source-Configuration Options"

Section 21.7.3, "Options with the Embedded Server"

Section C.5.4.1.1, "Resetting the Root Password: Windows Systems"

Section 5.6, "Running Multiple MySQL Instances on One Machine"

Section 5.6.3, "Running Multiple MySQL Instances on Unix"

Section 5.6.2.2, "Starting Multiple MySQL Instances as Windows Services"

Section 5.6.2.1, "Starting Multiple MySQL Instances at the Windows Command Line"

Section 2.3.5.7, "Starting MySQL as a Windows Service"

--defaults-group-suffix

Section 4.2.3.4, "Command-Line Options that Affect Option-File Handling"

Section 4.7.3, "my_print_defaults — Display Options from Option Files"

Section 2.12, "Environment Variables"

--delay-key-write

Section 14.3.1, "MyISAM Startup Options"

Section 8.10.5, "External Locking"

Section 5.1.3, "Server Command Options"

Section C.5.4.2, "What to Do If MySQL Keeps Crashing"

--delay_key_write

Section 5.1.5, "Using System Variables"

--delete

Section 4.5.5, "mysqlimport — A Data Import Program"

--delete-master-logs

Section 4.5.4, "mysqldump — A Database Backup Program"

--delimiter

Section 4.5.1.1, "mysql Options"

Section 4.5.7, "mysqlslap — Load Emulation Client"

--demangle

Section 22.4.1.5, "Using a Stack Trace"

--des-key-file

Section 13.7.6.3, "FLUSH Syntax"

Section 12.13, "Encryption and Compression Functions"

Section 5.1.3, "Server Command Options"

--description

Section 4.6.3.4, "Other myisamchk Options"

--detach

Section 4.5.7, "mysqlslap — Load Emulation Client"

--disable

Section 4.2.3.2, "Program Option Modifiers"

--disable-auto-rehash

Section 4.5.1.1, "mysql Options"

--disable-keys

Section 4.5.4, "mysqldump — A Database Backup Program"

--disable-log-bin

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

--disable-named-commands

Section 4.5.1.1, "mysql Options"

--disable-plugin_name

Section 5.1.8.1, "Installing and Uninstalling Plugins"

--disconnect-slave-event-count

Section 16.1.4.3, "Replication Slave Options and Variables"

--dryrun

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

--dump

Section 4.6.2, "myisam_ftdump — Display Full-Text Index information"

--dump-date

Section 4.5.4, "mysqldump — A Database Backup Program"

--dump-slave

Section 4.5.4, "mysqldump — A Database Backup Program"

E

[index top]

-E

Section 4.5.1.1, "mysql Options"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.4, "mysqldump — A Database Backup Program"

-e

Section 4.6.3.2, "myisamchk Check Options"

Section 4.6.3.1, "myisamchk General Options"

Section 4.6.3.3, "myisamchk Repair Options"

Section 4.5.1.1, "mysql Options"

Section 13.2.7, "LOAD XML Syntax"

Section 4.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

Section 4.6.11, "mysql_convert_table_format — Convert Tables to Use a Given StorageEngine"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.7.3, "my_print_defaults — Display Options from Option Files"

Section 7.6.2, "How to Check MyISAM Tables for Errors"

Section 4.6.3.5, "Obtaining Table Information with myisamchk"

Section 4.2.3.1, "Using Options on the Command Line"

--embedded

Section 4.7.2, "mysql_config — Display Options for Compiling Clients"

--enable-cleartext-plugin

Section 4.5.1.1, "mysql Options"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 6.3.7.3, "The Cleartext Client-Side Authentication Plugin"

--enable-named-pipe

Section C.5.2.2, "Can't connect to [local] MySQL server"

Section 4.2.2, "Connecting to the MySQL Server"

Section 2.3.5.3, "Selecting a MySQL Server Type"

Section 5.1.3, "Server Command Options"

--enable-plugin_name

Section 5.1.8.1, "Installing and Uninstalling Plugins"

--end-page

Section 4.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

--enforce-gtid-consistency

Section 16.1.4.5, "Global Transaction ID Options and Variables"

Section 16.1.3.4, "Restrictions on Replication with GTIDs"

Section 16.1.3.2, "Setting Up Replication Using GTIDs"

Section 16.1.3.3, "Using GTIDs for Failover and Scaleout"

--engine

Section 4.6.11, "mysql_convert_table_format — Convert Tables to Use a Given StorageEngine"

Section 4.5.7, "mysqlslap — Load Emulation Client"

event-scheduler

Section 18.4.2, "Event Scheduler Configuration"

--event-scheduler

Section 18.4.2, "Event Scheduler Configuration"

Section 5.1.3, "Server Command Options"

--events

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 7.4.5.3, "Dumping Stored Programs"

Section 7.4.5.4, "Dumping Table Definitions and Content Separately"

Section 2.11.1.1, "Upgrading from MySQL 5.6 to 5.7"

Section 4.6.8.3, "Using mysqlbinlog to Back Up Binary Log Files"

--example

Section 4.3.4, "mysqld_multi — Manage Multiple MySQL Servers"

--exclude-gtids

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

--execute

Section 4.5.1.3, "mysql Logging"

Section 4.5.1.1, "mysql Options"

Section 4.2.3.1, "Using Options on the Command Line"

--exit-info

Section 5.1.3, "Server Command Options"

--extend-check

Section 4.6.3.2, "myisamchk Check Options"

Section 4.6.3.1, "myisamchk General Options"

Section 4.6.3.3, "myisamchk Repair Options"

--extended

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

--extended-insert

Section 4.5.4, "mysqldump — A Database Backup Program"

--external-locking

Section 14.3.1, "MyISAM Startup Options"

Section 8.10.5, "External Locking"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

Section 8.11.1, "System Factors and Startup Parameter Tuning"

--extra-file

Section 4.7.3, "my_print_defaults — Display Options from Option Files"

F

[index top]

-F

Section 4.6.3.2, "myisamchk Check Options"

Section 4.5.1.2, "mysql Commands"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.4.1, "comp_err — Compile MySQL Error Message File"

-f

Section 4.6.3.2, "myisamchk Check Options"

Section 4.6.3.3, "myisamchk Repair Options"

Section 4.5.1.1, "mysql Options"

Section 4.6.4, "myisamlog — Display MyISAM Log File Contents"

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

Section 4.6.16, "mysql_zap — Kill Processes That Match a Pattern"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 22.4.1.5, "Using a Stack Trace"

--fast

Section 4.6.3.2, "myisamchk Check Options"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

--federated

Section 14.9, "The FEDERATED Storage Engine"

--fields-enclosed-by

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 7.4.3, "Dumping Data in Delimited-Text Format with mysqldump"

--fields-escaped-by

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 7.4.3, "Dumping Data in Delimited-Text Format with mysqldump"

--fields-optionally-enclosed-by

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 7.4.3, "Dumping Data in Delimited-Text Format with mysqldump"

--fields-terminated-by

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 7.4.3, "Dumping Data in Delimited-Text Format with mysqldump"

--fields-xxx

Section 4.5.4, "mysqldump — A Database Backup Program"

--fix-db-names

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

--fix-table-names

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

--flush

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

Section C.5.4.2, "What to Do If MySQL Keeps Crashing"

--flush-logs

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 7.3.1, "Establishing a Backup Policy"

Section 5.2, "MySQL Server Logs"

--flush-privileges

Section 4.5.4, "mysqldump — A Database Backup Program"

--flush_time

Section 22.1.1, "MySQL Threads"

--flushlog

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

--force

Section 4.6.3.2, "myisamchk Check Options"

Section 4.6.3.3, "myisamchk Repair Options"

Section 4.5.1.1, "mysql Options"

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

Section 4.6.11, "mysql_convert_table_format — Convert Tables to Use a Given StorageEngine"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.4.3, "mysql_install_db — Initialize MySQL Data Directory"

Section 4.4.7, "mysql_upgrade — Check and Upgrade MySQL Tables"

Section 22.1.2, "The MySQL Test Suite"

Section 3.5, "Using mysql in Batch Mode"

--force-if-open

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

--force-read

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

G

[index top]

-G

Section 4.5.1.1, "mysql Options"

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

-g

Section 22.4.1.1, "Compiling MySQL for Debugging"

Section 4.6.9, "mysqldumpslow — Summarize Slow Query Log Files"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.7.3, "my_print_defaults — Display Options from Option Files"

--gdb

Section 22.4.1.4, "Debugging mysqld under gdb"

Section 5.1.3, "Server Command Options"

--general-log

Section 5.1.3, "Server Command Options"

--general_log

Section 5.2.1, "Selecting General Query and Slow Query Log Output Destinations"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

Section 5.2.3, "The General Query Log"

--general_log_file

Section 5.6, "Running Multiple MySQL Instances on One Machine"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

Section 5.2.3, "The General Query Log"

--gtid-mode

Section 16.1.4.5, "Global Transaction ID Options and Variables"

Section 16.1.4.3, "Replication Slave Options and Variables"

Section 16.1.3.4, "Restrictions on Replication with GTIDs"

Section 16.1.3.2, "Setting Up Replication Using GTIDs"

Section 2.11.1, "Upgrading MySQL"

Section 16.1.3.3, "Using GTIDs for Failover and Scaleout"

H

[index top]

-H

Section 4.6.3.1, "myisamchk General Options"

Section 4.5.1.1, "mysql Options"

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.4.1, "comp_err — Compile MySQL Error Message File"

-h

Section 4.5.1.1, "mysql Options"

Section 4.2.2, "Connecting to the MySQL Server"

Section 4.6.2, "myisam_ftdump — Display Full-Text Index information"

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.6.9, "mysqldumpslow — Summarize Slow Query Log Files"

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.5.7, "mysqlslap — Load Emulation Client"

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

Section 4.2.1, "Invoking MySQL Programs"

Section 5.1.3, "Server Command Options"

Section 1.2, "Typographical and Syntax Conventions"

Section 4.2.3.1, "Using Options on the Command Line"

HAVE_EMBEDDED_PRIVILEGE_CONTROL

Section 21.7, "libmysqld, the Embedded MySQL Server Library"

--header_file

Section 4.4.1, "comp_err — Compile MySQL Error Message File"

--HELP

Section 4.6.3.1, "myisamchk General Options"

--help

Section 4.6.3.1, "myisamchk General Options"

Section 4.5.1.1, "mysql Options"

Section 4.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

Section 4.6.2, "myisam_ftdump — Display Full-Text Index information"

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

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

Section 4.6.11, "mysql_convert_table_format — Convert Tables to Use a Given StorageEngine"

Section 4.6.12, "mysql_find_rows — Extract SQL Statements from Files"

Section 4.6.14, "mysql_setpermission — Interactively Set Permissions in GrantTables"

Section 4.6.15, "mysql_waitpid — Kill Process and Wait for Its Termination"

Section 4.6.16, "mysql_zap — Kill Processes That Match a Pattern"

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.6.9, "mysqldumpslow — Summarize Slow Query Log Files"

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.7.3, "my_print_defaults — Display Options from Option Files"

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

Section 4.4.1, "comp_err — Compile MySQL Error Message File"

Section 4.4.4, "mysql_plugin — Configure MySQL Server Plugins"

Section 4.4.7, "mysql_upgrade — Check and Upgrade MySQL Tables"

Section 4.8.1, "perror — Explain Error Codes"

Section 4.8.3, "resolveip — Resolve Host name to IP Address or ViceVersa"

Section 4.3.4, "mysqld_multi — Manage Multiple MySQL Servers"

Section 4.3.2, "mysqld_safe — MySQL Server Startup Script"

Section 4.1, "Overview of MySQL Programs"

Section 5.1.3, "Server Command Options"

Section 2.10.1.3, "Starting and Troubleshooting the MySQL Server"

Section 8.11.2, "Tuning Server Parameters"

Chapter 3, Tutorial

Section 2.10.1, "Unix Postinstallation Procedures"

Section 4.2.3.3, "Using Option Files"

Section 4.2.3.1, "Using Options on the Command Line"

--hex-blob

Section 4.5.4, "mysqldump — A Database Backup Program"

--hexdump

Section 4.6.8.1, "mysqlbinlog Hex Dump Format"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

--histignore

Section 4.5.1.3, "mysql Logging"

Section 4.5.1.1, "mysql Options"

Section 1.4, "What Is New in MySQL 5.7"

--host

Section 4.5.1.1, "mysql Options"

Section 6.2.7, "Causes of Access-Denied Errors"

Section 5.1.9.2, "Configuring the MySQL Server to Permit IPv6 Connections"

Section 4.2.2, "Connecting to the MySQL Server"

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

Section 4.6.11, "mysql_convert_table_format — Convert Tables to Use a Given StorageEngine"

Section 4.6.14, "mysql_setpermission — Interactively Set Permissions in GrantTables"

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.2.1, "Invoking MySQL Programs"

Section 4.2.3.6, "Option Defaults, Options Expecting Values, and the =Sign"

Section 5.1.3, "Server Command Options"

Section 1.2, "Typographical and Syntax Conventions"

Section 4.6.8.3, "Using mysqlbinlog to Back Up Binary Log Files"

Section 5.6.4, "Using Client Programs in a Multiple-Server Environment"

Section 4.2.3.3, "Using Option Files"

Section 4.2.3.1, "Using Options on the Command Line"

host

Section 4.2.3.4, "Command-Line Options that Affect Option-File Handling"

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

Section 4.2.3.3, "Using Option Files"

--howto

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

--html

Section 4.5.1.1, "mysql Options"

I

[index top]

-I

Section 21.8.4.1, "Building C API Client Programs"

Section 4.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

Section 4.6.4, "myisamlog — Display MyISAM Log File Contents"

Section 4.6.15, "mysql_waitpid — Kill Process and Wait for Its Termination"

Section 4.6.16, "mysql_zap — Kill Processes That Match a Pattern"

Section 4.8.1, "perror — Explain Error Codes"

Section 4.8.2, "replace — A String-Replacement Utility"

Section 4.8.3, "resolveip — Resolve Host name to IP Address or ViceVersa"

-i

Section 4.6.3.2, "myisamchk Check Options"

Section 4.5.1.1, "mysql Options"

Section 4.6.4, "myisamlog — Display MyISAM Log File Contents"

Section 4.6.9, "mysqldumpslow — Summarize Slow Query Log Files"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.4.4, "mysql_plugin — Configure MySQL Server Plugins"

Section 7.6.2, "How to Check MyISAM Tables for Errors"

Section 22.4.1.3, "Using pdb to create a Windows crashdump"

--i-am-a-dummy

Section 4.5.1.1, "mysql Options"

Section 4.5.1.6.4, "Using the --safe-updates Option"

--idempotent

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

--ignore

Section 4.5.5, "mysqlimport — A Data Import Program"

--ignore-builtin-innodb

Section 14.2.6, "InnoDB Startup Options and System Variables"

--ignore-db-dir

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

--ignore-error

Section 4.5.4, "mysqldump — A Database Backup Program"

--ignore-lines

Section 4.5.5, "mysqlimport — A Data Import Program"

--ignore-spaces

Section 4.5.1.1, "mysql Options"

--ignore-table

Section 4.5.4, "mysqldump — A Database Backup Program"

--in_file

Section 4.4.1, "comp_err — Compile MySQL Error Message File"

--include

Section 4.7.2, "mysql_config — Display Options for Compiling Clients"

--include-gtids

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

--include-master-host-port

Section 4.5.4, "mysqldump — A Database Backup Program"

--info

Section 4.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

Section 4.8.1, "perror — Explain Error Codes"

Section 4.8.3, "resolveip — Resolve Host name to IP Address or ViceVersa"

--Information

Section 4.6.12, "mysql_find_rows — Extract SQL Statements from Files"

--information

Section 4.6.3.2, "myisamchk Check Options"

--init-command

Section 4.5.1.1, "mysql Options"

--init-file

Section 20.2.3, "Performance Schema Runtime Configuration"

Section C.5.4.1.2, "Resetting the Root Password: Unix Systems"

Section C.5.4.1.1, "Resetting the Root Password: Windows Systems"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

Section 14.4, "The MEMORY Storage Engine"

--init_connect

Section 10.1.5, "Configuring the Character Set and Collation for Applications"

--innodb

Section 14.2.6, "InnoDB Startup Options and System Variables"

Section 14.2.2.8, "Turning Off InnoDB"

innodb-status-file

Section 14.2.4.4, "SHOW ENGINE INNODBSTATUS and the InnoDB Monitors"

--innodb-status-file

Section 14.2.6, "InnoDB Startup Options and System Variables"

--innodb-xxx

Section 5.1.3, "Server Command Options"

--innodb_checksums

Section 14.2.6, "InnoDB Startup Options and System Variables"

--innodb_file_per_table

Section 5.4.1.1, "Enabling and Disabling File-Per-Table Mode"

Section 5.1.3, "Server Command Options"

innodb_file_per_table

Section 16.1.1.6, "Creating a Data Snapshot Using Raw Data Files"

Section 5.1.3, "Server Command Options"

--innodb_rollback_on_timeout

Section 14.2.3.15, "InnoDB Error Handling"

Section 14.2.6, "InnoDB Startup Options and System Variables"

--innodb_support_xa

Section 5.2.4, "The Binary Log"

--insert-ignore

Section 4.5.4, "mysqldump — A Database Backup Program"

--install

Section 4.2.3.4, "Command-Line Options that Affect Option-File Handling"

Section 5.1.3, "Server Command Options"

Section 5.6.2.2, "Starting Multiple MySQL Instances as Windows Services"

Section 2.3.5.7, "Starting MySQL as a Windows Service"

--install-manual

Section 5.1.3, "Server Command Options"

Section 5.6.2.2, "Starting Multiple MySQL Instances as Windows Services"

Section 2.3.5.7, "Starting MySQL as a Windows Service"

--iterations

Section 4.5.7, "mysqlslap — Load Emulation Client"

J

[index top]

-j

Section 4.5.1.1, "mysql Options"

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

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

--join

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

K

[index top]

-K

Section 4.5.4, "mysqldump — A Database Backup Program"

-k

Section 4.6.3.3, "myisamchk Repair Options"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.4.7, "mysql_upgrade — Check and Upgrade MySQL Tables"

--keep_files_on_create

Section 13.1.14, "CREATE TABLE Syntax"

--keepold

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

--key_buffer_size

Section 5.1.3, "Server Command Options"

--keys

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

--keys-used

Section 4.6.3.3, "myisamchk Repair Options"

L

[index top]

-L

Section 4.5.1.1, "mysql Options"

Section 21.8.4.1, "Building C API Client Programs"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 2.13.3, "Problems Using the Perl DBI/DBD Interface"

Section 6.1.6, "Security Issues with LOADDATA LOCAL"

-l

Section 4.6.3.3, "myisamchk Repair Options"

Section 21.8.7.39, "mysql_library_end()"

Section 21.8.4.1, "Building C API Client Programs"

Section 21.8.13, "C API Embedded Server Function Descriptions"

Section 21.8.6, "C API Function Overview"

Section 4.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

Section 4.6.2, "myisam_ftdump — Display Full-Text Index information"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.6.9, "mysqldumpslow — Summarize Slow Query Log Files"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.7.3, "my_print_defaults — Display Options from Option Files"

--language

Section 5.1.3, "Server Command Options"

--large-pages

Section 8.11.4.2, "Enabling Large Page Support"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

--lc-messages

Section 5.1.3, "Server Command Options"

--lc-messages-dir

Section 5.1.3, "Server Command Options"

--ldata

Section 4.4.3, "mysql_install_db — Initialize MySQL Data Directory"

--ledir

Section 4.3.2, "mysqld_safe — MySQL Server Startup Script"

--length

Section 4.6.2, "myisam_ftdump — Display Full-Text Index information"

--libmysqld-libs

Section 4.7.2, "mysql_config — Display Options for Compiling Clients"

--libs

Section 4.7.2, "mysql_config — Display Options for Compiling Clients"

--libs_r

Section 4.7.2, "mysql_config — Display Options for Compiling Clients"

--line-numbers

Section 4.5.1.1, "mysql Options"

--lines-terminated-by

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 7.4.3, "Dumping Data in Delimited-Text Format with mysqldump"

--local

Section 13.2.6, "LOAD DATA INFILE Syntax"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 6.1.6, "Security Issues with LOADDATA LOCAL"

--local-infile

Section 4.5.1.1, "mysql Options"

Section 13.2.7, "LOAD XML Syntax"

Section 6.1.6, "Security Issues with LOADDATA LOCAL"

--local-load

Section 4.6.8, "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.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

Section 4.3.4, "mysqld_multi — Manage Multiple MySQL Servers"

Section 14.2.5.13, "Enhanced innochecksum Capability"

--log-bin

Section 13.4.2.1, "CHANGE MASTER TO Syntax"

Section 13.4.1.1, "PURGE BINARY LOGS Syntax"

Section 7.3.3, "Backup Strategy Summary"

Section 16.1.4.4, "Binary Log Options and Variables"

Section 18.7, "Binary Logging of Stored Programs"

Section 7.2, "Database Backup Methods"

Section 7.3.1, "Establishing a Backup Policy"

Section 16.1.4.5, "Global Transaction ID Options and Variables"

Section 16.4.5, "How to Report Replication Bugs or Problems"

Section C.5.8, "Known Issues in MySQL"

Section 7.5, "Point-in-Time (Incremental) Recovery Using the Binary Log"

Section 16.1.4.3, "Replication Slave Options and Variables"

Section 5.6, "Running Multiple MySQL Instances on One Machine"

Section 16.3.6, "Switching Masters During Failover"

Section 5.2.4, "The Binary Log"

Section 16.4.4, "Troubleshooting Replication"

Section 16.4.3, "Upgrading a Replication Setup"

Section 7.3.2, "Using Backups for Recovery"

Section 16.1.3.3, "Using GTIDs for Failover and Scaleout"

--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-bin-use-v1-row-events

Section 16.1.4.4, "Binary Log Options and Variables"

--log-error

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.3.2, "mysqld_safe — MySQL Server Startup Script"

Section 4.2.3.6, "Option Defaults, Options Expecting Values, and the =Sign"

Section 5.6, "Running Multiple MySQL Instances on One Machine"

Section 5.1.3, "Server Command Options"

Section 5.2.6, "Server Log Maintenance"

Section 2.3.5.5, "Starting MySQL from the Windows Command Line"

Section 2.3.5.4, "Starting the Server for the First Time"

Section 5.2.2, "The Error Log"

--log-isam

Section 4.6.4, "myisamlog — Display MyISAM Log File Contents"

Section 5.1.3, "Server Command Options"

--log-output

Section 5.2.1, "Selecting General Query and Slow Query Log Output Destinations"

Section 5.1.3, "Server Command Options"

Section 5.2.3, "The General Query Log"

Section 5.2.5, "The Slow Query Log"

--log-queries-not-using-indexes

Section 5.1.3, "Server Command Options"

--log-raw

Section 6.1.2.3, "Passwords and Logging"

Section 5.1.3, "Server Command Options"

Section 5.2.3, "The General Query Log"

--log-short-format

Section 16.1.4.4, "Binary Log Options and Variables"

Section 5.1.3, "Server Command Options"

Section 5.2.5, "The Slow Query Log"

--log-slave-updates

Section 16.1.4.5, "Global Transaction ID Options and Variables"

Section 16.4.5, "How to Report Replication Bugs or Problems"

Section 16.3.5, "Improving Replication Performance"

Section 16.1.4.3, "Replication Slave Options and Variables"

Section 16.3.6, "Switching Masters During Failover"

Section 5.2.4, "The Binary Log"

Section 16.1.3.3, "Using GTIDs for Failover and Scaleout"

--log-slow-admin-statements

Section 5.1.3, "Server Command Options"

Section 5.2.5, "The Slow Query Log"

--log-slow-slave-statements

Section 16.1.4.3, "Replication Slave Options and Variables"

Section 5.2.5, "The Slow Query Log"

--log-tc

Section 5.1.3, "Server Command Options"

--log-tc-size

Section 5.1.3, "Server Command Options"

Section 5.1.6, "Server Status Variables"

--log-warnings

Section C.5.2.9, "MySQL server has gone away"

Section C.5.2.11, "Communication Errors and Aborted Connections"

Section 5.2.4.3, "Mixed Binary Logging Format"

Section 16.1.4.3, "Replication Slave Options and Variables"

Section 5.1.3, "Server Command Options"

Section 5.2.2, "The Error Log"

--login-path

Section 4.2.3.4, "Command-Line Options that Affect Option-File Handling"

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

Section 4.7.3, "my_print_defaults — Display Options from Option Files"

Section 4.2.3.3, "Using Option Files"

--loose

Section 4.2.3.2, "Program Option Modifiers"

--loose-opt_name

Section 4.2.3.3, "Using Option Files"

--low-priority

Section 4.5.5, "mysqlimport — A Data Import Program"

--low-priority-updates

Section 13.2.5, "INSERT Syntax"

Section 8.10.3, "Concurrent Inserts"

Section 5.1.3, "Server Command Options"

Section 8.10.2, "Table Locking Issues"

--lower-case-table-names

Section 9.2.2, "Identifier Case Sensitivity"

M

[index top]

-m

Section 4.6.3.2, "myisamchk Check Options"

Section 4.5.1.1, "mysql Options"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

--malloc-lib

Section 4.3.2, "mysqld_safe — MySQL Server Startup Script"

--master-connect-retry

Section 16.1.4.3, "Replication Slave Options and Variables"

--master-data

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 7.3.1, "Establishing a Backup Policy"

Section 5.2, "MySQL Server Logs"

Section 4.6.8.3, "Using mysqlbinlog to Back Up Binary Log Files"

Section 16.1.3.3, "Using GTIDs for Failover and Scaleout"

--master-host

Section 16.1.4.3, "Replication Slave Options and Variables"

--master-info-file

Section 16.1.4.3, "Replication Slave Options and Variables"

Section 16.2.2.2, "Slave Status Logs"

--master-info-repository

Section 13.4.2.1, "CHANGE MASTER TO Syntax"

Section 16.2.2, "Replication Relay and Status Logs"

Section 16.1.4.3, "Replication Slave Options and Variables"

Section 16.1.1.8, "Setting Up Replication with Existing Data"

Section 16.2.2.2, "Slave Status Logs"

--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.33, "SHOW SLAVE STATUS Syntax"

Section 16.1.4.3, "Replication Slave Options and Variables"

--master-ssl

Section 16.1.4.3, "Replication Slave Options and Variables"

--master-ssl-ca

Section 16.1.4.3, "Replication Slave Options and Variables"

--master-ssl-capath

Section 16.1.4.3, "Replication Slave Options and Variables"

--master-ssl-cert

Section 16.1.4.3, "Replication Slave Options and Variables"

--master-ssl-cipher

Section 16.1.4.3, "Replication Slave Options and Variables"

--master-ssl-key

Section 16.1.4.3, "Replication Slave Options and Variables"

--master-user

Section 16.1.4.3, "Replication Slave Options and Variables"

--master-verify-checksum

Section 16.1.4.4, "Binary Log Options and Variables"

--max

Section 4.2.3.5, "Using Options to Set Program Variables"

--max-binlog-dump-events

Section 16.1.4.4, "Binary Log Options and Variables"

--max-binlog-size

Section 16.1.4.3, "Replication Slave Options and Variables"

--max-record-length

Section 4.6.3.3, "myisamchk Repair Options"

Section 13.7.2.5, "REPAIR TABLE Syntax"

--max-relay-log-size

Section 16.1.4.3, "Replication Slave Options and Variables"

--max-seeks-for-key

Section 8.2.1.4, "How to Avoid Full Table Scans"

Section C.5.6, "Optimizer-Related Issues"

--max_a

Section 4.2.3.5, "Using Options to Set Program Variables"

--max_join_size

Section 4.5.1.6.4, "Using the --safe-updates Option"

--maximum

Section 4.2.3.2, "Program Option Modifiers"

--maximum-query_cache_size

Section 4.2.3.2, "Program Option Modifiers"

Section 8.9.3.3, "Query Cache Configuration"

Section 5.1.5, "Using System Variables"

--maximum-var_name

Section 5.1.3, "Server Command Options"

Section 5.1.5, "Using System Variables"

--medium-check

Section 4.6.3.2, "myisamchk Check Options"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

--memlock

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

Section 14.2.2.3, "Using Raw Disk Partitions for the Shared Tablespace"

--method

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

--min-examined-row-limit

Section 5.1.3, "Server Command Options"

--my-plugin

Section 5.1.8.1, "Installing and Uninstalling Plugins"

--my-print-defaults

Section 4.4.4, "mysql_plugin — Configure MySQL Server Plugins"

--my_plugin

Section 5.1.8.1, "Installing and Uninstalling Plugins"

--myisam-block-size

Section 8.9.2.5, "Key Cache Block Size"

Section 5.1.3, "Server Command Options"

--myisam-recover

Section 5.1.3, "Server Command Options"

--myisam-recover-options

Section 14.3.1, "MyISAM Startup Options"

Section 8.6.1, "Optimizing MyISAM Queries"

Section 8.2.5, "Other Optimization Tips"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

Section 7.6.5, "Setting Up a MyISAM Table Maintenance Schedule"

Section C.5.2.19, "Table-Corruption Issues"

Section 14.3, "The MyISAM Storage Engine"

Section 22.4.1.6, "Using Server Logs to Find Causes of Errors in mysqld"

--myisam_sort_buffer_size

Section 4.6.3.6, "myisamchk Memory Usage"

MYSQL_MAINTAINER_MODE

Section 2.9.5, "Dealing with Problems Compiling MySQL"

MYSQL_TCP_PORT

Section 2.9.3, "Installing MySQL Using 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 Using 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.1, "innochecksum — Offline InnoDB File Checksum Utility"

Section 4.6.9, "mysqldumpslow — Summarize Slow Query Log Files"

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.7.3, "my_print_defaults — Display Options from Option Files"

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

--name_file

Section 4.4.1, "comp_err — Compile MySQL Error Message File"

--named-commands

Section 4.5.1.1, "mysql Options"

--ndb

Section 4.8.1, "perror — Explain Error Codes"

net_retry_count

Section 16.2.1, "Replication Implementation Details"

net_write_timeout

Section 16.2.1, "Replication Implementation Details"

--new

Section 4.2.3.3, "Using Option Files"

--nice

Section 4.3.2, "mysqld_safe — MySQL Server Startup Script"

--no-auto-rehash

Section 4.5.1.1, "mysql Options"

--no-autocommit

Section 4.5.4, "mysqldump — A Database Backup Program"

--no-beep

Section 4.5.1.1, "mysql Options"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

--no-check

Section 4.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

Section 14.2.5.13, "Enhanced innochecksum Capability"

--no-create-db

Section 4.5.4, "mysqldump — A Database Backup Program"

--no-create-info

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 7.4.5.4, "Dumping Table Definitions and Content Separately"

--no-data

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 7.4.5.4, "Dumping Table Definitions and Content Separately"

--no-defaults

Section 6.2.7, "Causes of Access-Denied Errors"

Section 4.2.3.4, "Command-Line Options that Affect Option-File Handling"

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

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

Section 4.5.7, "mysqlslap — Load Emulation Client"

--no-log

Section 4.3.4, "mysqld_multi — Manage Multiple MySQL Servers"

--no-set-names

Section 4.5.4, "mysqldump — A Database Backup Program"

--no-symlinks

Section 4.6.3.3, "myisamchk Repair Options"

--no-tablespaces

Section 4.5.4, "mysqldump — A Database Backup Program"

--noindices

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

--number-char-cols

Section 4.5.7, "mysqlslap — Load Emulation Client"

--number-int-cols

Section 4.5.7, "mysqlslap — Load Emulation Client"

--number-of-queries

Section 4.5.7, "mysqlslap — Load Emulation Client"

--numeric-dump-file

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

O

[index top]

-O

Section 4.4.1, "comp_err — Compile MySQL Error Message File"

-o

Section 4.6.3.3, "myisamchk Repair Options"

Section 4.5.1.1, "mysql Options"

Section 21.7.1, "Compiling Programs with libmysqld"

Section 4.6.4, "myisamlog — Display MyISAM Log File Contents"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 8.11.3, "Optimizing Disk I/O"

--offset

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

--old-alter-table

Section 5.1.3, "Server Command Options"

--old-style-user-limits

Section 5.1.3, "Server Command Options"

Section 6.3.4, "Setting Account Resource Limits"

--old_server

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

ON

Section 3.3.4.9, "Using More Than one Table"

--one-database

Section 4.5.1.1, "mysql Options"

--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 andSimilar Errors"

Section 14.2.6, "InnoDB Startup Options and System Variables"

Section 4.3.2, "mysqld_safe — MySQL Server Startup Script"

Section 8.4.3.1, "How MySQL Opens and Closes Tables"

Section 5.1.3, "Server Command Options"

--opt

Section 8.5.4, "Bulk Data Loading for InnoDB Tables"

Section 4.5.4, "mysqldump — A Database Backup Program"

--opt_name

Section 4.2.3.3, "Using Option Files"

--optimize

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

--order-by-primary

Section 4.5.4, "mysqldump — A Database Backup Program"

--out_dir

Section 4.4.1, "comp_err — Compile MySQL Error Message File"

--out_file

Section 4.4.1, "comp_err — Compile MySQL Error Message File"

P

[index top]

-P

Section 4.5.1.1, "mysql Options"

Section 4.2.2, "Connecting to the MySQL Server"

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.4.4, "mysql_plugin — Configure MySQL Server Plugins"

Section 4.2.1, "Invoking MySQL Programs"

Section 5.1.3, "Server Command Options"

-p

Section 4.6.3.3, "myisamchk Repair Options"

Section 4.5.1.1, "mysql Options"

Section 6.3.2, "Adding User Accounts"

Section 6.2.7, "Causes of Access-Denied Errors"

Section 4.2.2, "Connecting to the MySQL Server"

Section 4.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

Section 4.6.4, "myisamlog — Display MyISAM Log File Contents"

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.4.4, "mysql_plugin — Configure MySQL Server Plugins"

Section 6.1.2.1, "End-User Guidelines for Password Security"

Section 4.2.1, "Invoking MySQL Programs"

Section C.5.2.5, "Password Fails When Entered Interactively"

Section 2.10.2, "Securing the Initial MySQL Accounts"

Section 2.3.5.7, "Starting MySQL as a Windows Service"

Section 2.3.5.5, "Starting MySQL from the Windows Command Line"

Section 2.3.5.8, "Testing The MySQL Installation"

Section 2.3.7, "Upgrading MySQL on Windows"

Section 6.3.1, "User Names and Passwords"

Section 4.2.3.1, "Using Options on the Command Line"

Section 2.3.8, "Windows Postinstallation Procedures"

--page

Section 4.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

--page-type-dump

Section 4.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

Section 14.2.5.13, "Enhanced innochecksum Capability"

--page-type-summary

Section 4.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

Section 14.2.5.13, "Enhanced innochecksum Capability"

--pager

Section 4.5.1.2, "mysql Commands"

Section 4.5.1.1, "mysql Options"

--parallel-recover

Section 4.6.3.3, "myisamchk Repair Options"

--partition

Section 5.1.3, "Server Command Options"

password

Section 4.2.3.4, "Command-Line Options that Affect Option-File Handling"

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

Section 4.2.3.3, "Using Option Files"

--password

Section 4.5.1.1, "mysql Options"

Section 6.3.2, "Adding User Accounts"

Section 6.2.7, "Causes of Access-Denied Errors"

Section 4.2.2, "Connecting to the MySQL Server"

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

Section 4.6.11, "mysql_convert_table_format — Convert Tables to Use a Given StorageEngine"

Section 4.6.14, "mysql_setpermission — Interactively Set Permissions in GrantTables"

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.4.7, "mysql_upgrade — Check and Upgrade MySQL Tables"

Section 4.3.4, "mysqld_multi — Manage Multiple MySQL Servers"

Section 6.1.2.1, "End-User Guidelines for Password Security"

Section 7.3, "Example Backup and Recovery Strategy"

Section 4.2.1, "Invoking MySQL Programs"

Section C.5.2.5, "Password Fails When Entered Interactively"

Section 6.3.7, "Pluggable Authentication"

Section 6.3.7.5, "The Test Authentication Plugin"

Section 6.3.1, "User Names and Passwords"

Section 4.6.8.3, "Using mysqlbinlog to Back Up Binary Log Files"

Section 4.2.3.1, "Using Options on the Command Line"

--performance-schema-consumer-consumer_name

Section 20.11, "Performance Schema Command Options"

--performance-schema-instrument

Section 20.11, "Performance Schema Command Options"

Section 20.2.2, "Performance Schema Startup Configuration"

--performance-schema-xxx

Section 5.1.3, "Server Command Options"

--performance_schema_max_mutex_classes

Section 20.5, "Performance Schema Status Monitoring"

--performance_schema_max_mutex_instances

Section 20.5, "Performance Schema Status Monitoring"

pid-file

Section 2.10.1.2, "Starting and Stopping MySQL Automatically"

--pid-file

Section 4.3.3, "mysql.server — MySQL Server Startup Script"

Section 4.3.4, "mysqld_multi — Manage Multiple MySQL Servers"

Section 4.3.2, "mysqld_safe — MySQL Server Startup Script"

Section 5.6, "Running Multiple MySQL Instances on One Machine"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

--pipe

Section 4.5.1.1, "mysql Options"

Section 4.2.2, "Connecting to the MySQL Server"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 2.3.5.8, "Testing The MySQL Installation"

--plan

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

--plugin

Section 5.1.3, "Server Command Options"

--plugin-dir

Section 4.5.1.1, "mysql Options"

Section 21.8.14.3, "mysql_load_plugin()"

Section 21.8.14, "C API Client Plugin Functions"

Section 22.2.4.2.3, "Client Plugin Descriptors"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.4.4, "mysql_plugin — Configure MySQL Server Plugins"

Section 4.4.7, "mysql_upgrade — Check and Upgrade MySQL Tables"

Section 4.3.2, "mysqld_safe — MySQL Server Startup Script"

Section 6.3.7, "Pluggable Authentication"

Section D.9, "Restrictions on Pluggable Authentication"

Section 22.2.4.9.3, "Using the Authentication Plugins"

--plugin-ini

Section 4.4.4, "mysql_plugin — Configure MySQL Server Plugins"

--plugin-innodb_file_per_table

Section 5.1.3, "Server Command Options"

--plugin-load

Section 13.7.3.3, "INSTALL PLUGIN Syntax"

Section 6.3.11.5, "Audit Log Plugin Options and Variables"

Section 4.4.4, "mysql_plugin — Configure MySQL Server Plugins"

Section 5.1.8.1, "Installing and Uninstalling Plugins"

Section 6.3.11.1, "Installing the Audit Log Plugin"

Section 2.9.4, "MySQL Source-Configuration Options"

Section 6.1.2.6.1, "Password Validation Plugin Installation"

Section 6.1.2.6.2, "Password Validation Plugin Options and Variables"

Section 6.3.7, "Pluggable Authentication"

Section 22.2.2, "Plugin API Components"

Section 22.2.4.2, "Plugin Data Structures"

Section 5.1.3, "Server Command Options"

Section 22.2.4.2.1, "Server Plugin Library and Plugin Descriptors"

Section 22.2, "The MySQL Plugin API"

Section 22.2.4.9.3, "Using the Authentication Plugins"

--plugin-load-add

Section 5.1.8.1, "Installing and Uninstalling Plugins"

Section 5.1.3, "Server Command Options"

--plugin-sql-mode

Section 5.1.3, "Server Command Options"

--plugin-xxx

Section 5.1.3, "Server Command Options"

--plugin_dir

Section 2.9.4, "MySQL Source-Configuration Options"

Section 22.2.2, "Plugin API Components"

--plugin_name

Section 4.4.4, "mysql_plugin — Configure MySQL Server Plugins"

Section 5.1.8.1, "Installing and Uninstalling Plugins"

--plugindir

Section 4.7.2, "mysql_config — Display Options for Compiling Clients"

--port

Section 4.5.1.1, "mysql Options"

Section 6.2.7, "Causes of Access-Denied Errors"

Section 4.2.2, "Connecting to the MySQL Server"

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

Section 4.6.11, "mysql_convert_table_format — Convert Tables to Use a Given StorageEngine"

Section 4.6.14, "mysql_setpermission — Interactively Set Permissions in GrantTables"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.7.2, "mysql_config — Display 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.6, "Running Multiple MySQL Instances on One Machine"

Section 5.6.3, "Running Multiple MySQL Instances on Unix"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

Section 2.10.1.3, "Starting and Troubleshooting the MySQL Server"

Section 5.6.4, "Using Client Programs in a Multiple-Server Environment"

--port-open-timeout

Section 5.1.3, "Server Command Options"

--post-query

Section 4.5.7, "mysqlslap — Load Emulation Client"

--post-system

Section 4.5.7, "mysqlslap — Load Emulation Client"

--pre-query

Section 4.5.7, "mysqlslap — Load Emulation Client"

--pre-system

Section 4.5.7, "mysqlslap — Load Emulation Client"

--preview

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

--print-defaults

Section 4.2.3.4, "Command-Line Options that Affect Option-File Handling"

Section 4.4.4, "mysql_plugin — Configure MySQL Server Plugins"

Section 2.11.1, "Upgrading MySQL"

--prompt

Section 4.5.1.2, "mysql Commands"

Section 4.5.1.1, "mysql Options"

--protocol

Section 4.5.1.1, "mysql Options"

Section 4.2.2, "Connecting to the MySQL Server"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 5.6.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.6.4, "Using Client Programs in a Multiple-Server Environment"

Q

[index top]

-Q

Section 4.5.4, "mysqldump — A Database Backup Program"

-q

Section 4.6.3.3, "myisamchk Repair Options"

Section 4.5.1.1, "mysql Options"

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.7, "mysqlslap — Load Emulation Client"

--query

Section 4.5.7, "mysqlslap — Load Emulation Client"

--query-cache-size

Section 8.10.5, "External Locking"

--quick

Section 4.6.3.6, "myisamchk Memory Usage"

Section 4.6.3.3, "myisamchk Repair Options"

Section 4.5.1.1, "mysql Options"

Section C.5.2.8, "Out of memory"

Section 4.5.1, "mysql — The MySQL Command-Line Tool"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 7.6.1, "Using myisamchk for Crash Recovery"

Section 4.2.3.3, "Using Option Files"

--quiet

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

--quote-names

Section 4.5.4, "mysqldump — A Database Backup Program"

R

[index top]

-R

Section 7.6.4, "MyISAM Table Optimization"

Section 4.6.4, "myisamlog — Display MyISAM Log File Contents"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.6.3.4, "Other myisamchk Options"

Section 4.6.8.3, "Using mysqlbinlog to Back Up Binary Log Files"

-r

Section 4.6.3.2, "myisamchk Check Options"

Section 4.6.3.3, "myisamchk Repair Options"

Section 4.5.1.1, "mysql Options"

Section 22.3.2, "Adding a New User-Defined Function"

Section 4.6.4, "myisamlog — Display MyISAM Log File Contents"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.6.9, "mysqldumpslow — Summarize Slow Query Log Files"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 7.6.3, "How to Repair MyISAM Tables"

Section 2.2, "Installing MySQL on Unix/Linux Using Generic Binaries"

Section 5.1.3, "Server Command Options"

--random-passwords

Section 4.4.3, "mysql_install_db — Initialize MySQL Data Directory"

Section 2.5.1, "Installing MySQL on Linux Using RPM Packages"

Section 2.10.1, "Unix Postinstallation Procedures"

--raw

Section 4.5.1.1, "mysql Options"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.6.8.3, "Using mysqlbinlog to Back Up Binary Log Files"

Section 16.1.3.3, "Using GTIDs for Failover and Scaleout"

--read-from-remote-master

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 16.1.3.3, "Using GTIDs for Failover and Scaleout"

--read-from-remote-server

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.6.8.4, "Specifying the mysqlbinlog Server ID"

Section 4.6.8.3, "Using mysqlbinlog to Back Up Binary Log Files"

Section 16.1.3.3, "Using GTIDs for Failover and Scaleout"

--read-only

Section 4.6.3.2, "myisamchk Check Options"

Section 16.1.4.3, "Replication Slave Options and Variables"

--reconnect

Section 4.5.1.1, "mysql Options"

--record_log_pos

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

--recover

Section 4.6.3.2, "myisamchk Check Options"

Section 4.6.3.1, "myisamchk General Options"

Section 4.6.3.6, "myisamchk Memory Usage"

Section 4.6.3.3, "myisamchk Repair Options"

--regexp

Section 4.6.12, "mysql_find_rows — Extract SQL Statements from Files"

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

--relative

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

--relay-log

Section 13.4.2.1, "CHANGE MASTER TO Syntax"

Section 16.3.5, "Improving Replication Performance"

Section 16.1.1.9, "Introducing Additional Slaves to an Existing Replication Environment"

Section 4.2.3.6, "Option Defaults, Options Expecting Values, and the =Sign"

Section 16.1.4.3, "Replication Slave Options and Variables"

Section 16.2.2.1, "The Slave Relay Log"

--relay-log-index

Section 16.1.1.9, "Introducing Additional Slaves to an Existing Replication Environment"

Section 16.1.4.3, "Replication Slave Options and Variables"

Section 16.2.2.1, "The Slave Relay Log"

--relay-log-info-file

Section 16.1.4.3, "Replication Slave Options and Variables"

Section 16.2.2.2, "Slave Status Logs"

--relay-log-info-repository

Section 16.2.2, "Replication Relay and Status Logs"

Section 16.1.4.3, "Replication Slave Options and Variables"

Section 16.2.2.2, "Slave Status Logs"

--relay-log-purge

Section 16.1.4.3, "Replication Slave Options and Variables"

--relay-log-recovery

Section 16.2.2, "Replication Relay and Status Logs"

Section 16.1.4.3, "Replication Slave Options and Variables"

Section 5.1.12, "The Shutdown Process"

--relay-log-space-limit

Section 16.1.4.3, "Replication Slave Options and Variables"

--relnotes

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

--remove

Section 5.1.3, "Server Command Options"

Section 5.6.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 D.1, "Restrictions on Stored Programs"

--replicate-*-table

Section 16.2.3.3, "Replication Rule Application"

--replicate-do-db

Section 13.7.5.33, "SHOW SLAVE STATUS Syntax"

Section 13.3.1, "START TRANSACTION, COMMIT, andROLLBACK Syntax"

Section 16.1.4.4, "Binary Log Options and Variables"

Section 16.2.3.1, "Evaluation of Database-Level Replication and Binary Logging Options"

Section 16.2.3, "How Servers Evaluate Replication Filtering Rules"

Section 16.3.4, "Replicating Different Databases to Different Slaves"

Section 16.4.1.25, "Replication and Reserved Words"

Section 16.4.1.22, "Replication and Temporary Tables"

Section 16.1.4.3, "Replication Slave Options and Variables"

Section 5.2.4, "The Binary Log"

Section 16.1.2.2, "Usage of Row-Based Logging and Replication"

--replicate-do-table

Section 13.7.5.33, "SHOW SLAVE STATUS Syntax"

Section 16.2.3.2, "Evaluation of Table-Level Replication Options"

Section 16.4.1.25, "Replication and Reserved Words"

Section 16.4.1.22, "Replication and Temporary Tables"

Section 16.2.3.3, "Replication Rule Application"

Section 16.1.4.3, "Replication Slave Options and Variables"

Section 14.7, "The BLACKHOLE Storage Engine"

Section 16.1.2.2, "Usage of Row-Based Logging and Replication"