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

Symbols

[index top]

--

Section 1.9.5.8, “'--' as the Start of a Comment”
Section C.3.58, “Changes in Release 3.23.3 (13 September 1999)”
Section 4.8.2, “replace — A String-Replacement Utility”

-#

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 4.6.2.1, “myisamchk General Options”
Section 4.6.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “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.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.8.2, “replace — A String-Replacement Utility”
Section 5.1.2, “Server Command Options”
Section 18.4.3, “The DBUG Package”

/3GB

Section D.3.3, “Windows Platform Limitations”

-1

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

-?

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 4.6.1, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.2.1, “myisamchk General Options”
Section 4.6.3, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.12, “mysql_explain_log — Use EXPLAIN on Statements in Query Log”
Section 4.6.17, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.6.18, “mysql_zap — Kill Processes That Match a Pattern”
Section 4.6.5, “mysqlaccess — Client for Checking Access Privileges”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “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.6.8, “mysqlhotcopy — 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 15.4.4, “ndb_config — Extract MySQL Cluster Configuration Information”
Section 15.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”
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 1.3.2, “The Main Features of MySQL”
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.2.4, “Other myisamchk Options”

-a

Section C.3.59, “Changes in Release 3.23.2 (09 August 1999)”
Section 15.5.2, “Commands in the MySQL Cluster Management Client”
Section 2.12.1.7, “Linux Alpha Notes”
Section 6.6.4, “MyISAM Table Optimization”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.6.7, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.6.2.4, “Other myisamchk Options”

--abort-slave-event-count

Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section 14.8.3, “Replication Slave Options and Variables”

--add-drop-database

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section 6.4.1, “Dumping Data in SQL Format with mysqldump”
Section 4.5.4, “mysqldump — A Database Backup Program”

--add-drop-table

Section 4.5.4, “mysqldump — A Database Backup Program”

--add-locks

Section 4.5.4, “mysqldump — A Database Backup Program”

--addtodest

Section 4.6.8, “mysqlhotcopy — A Database Backup Program”

--all

Section 4.5.4, “mysqldump — A Database Backup Program”

--all-databases

Section C.3.49, “Changes in Release 3.23.12 (07 March 2000)”
Section 6.4.1, “Dumping Data in SQL Format with mysqldump”
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”
Section 6.4.2, “Reloading SQL-Format Backups”

--all-in-1

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--allow-keywords

Section 4.5.4, “mysqldump — A Database Backup Program”

--allow-suspicious-udfs

Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section 5.4.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”
Section 18.2.2.6, “User-Defined Function Security Precautions”

--allowold

Section 4.6.8, “mysqlhotcopy — A Database Backup Program”

--analyze

Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section 6.6.4, “MyISAM Table Optimization”
Section 4.6.2.1, “myisamchk General Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.6.2.4, “Other myisamchk Options”

--ansi

Section C.3.55, “Changes in Release 3.23.6 (15 December 1999)”
Section 1.9.3, “Running MySQL in ANSI Mode”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--auto-rehash

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

--auto-repair

Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--autoclose

Section 2.7, “Installing MySQL on NetWare”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

B

[index top]

-B

Section 4.6.2.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.6.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.5, “mysqlaccess — Client for Checking Access Privileges”
Section 15.4.14, “ndb_restore — Restore a MySQL Cluster Backup”
Section 4.6.2.4, “Other myisamchk Options”
Section 5.1.2, “Server Command Options”

--back_log

Section 2.12.3, “Solaris Notes”

--backup

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

backup_path

Section 15.4.14, “ndb_restore — Restore a MySQL Cluster Backup”

--backup_path

Section 15.4.14, “ndb_restore — Restore a MySQL Cluster Backup”

--basedir

Section 2.9.7.1, “Building MySQL from Source Using VC++”
Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section 2.9.3, “MySQL Source-Configuration Options”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 4.4.6, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.7, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 2.10.2.3, “Starting and Troubleshooting the MySQL Server”
Section 2.10.2, “Unix Postinstallation Procedures”

basedir

Section 2.3.7, “Creating an Option File”
Section 2.10.2.2, “Starting and Stopping MySQL Automatically”
Section 2.3.13, “Troubleshooting a MySQL Installation Under Windows”

--batch

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

--bdb-home

Section 13.5.3, “BDB Startup Options”

--bdb-lock-detect

Section 13.5.3, “BDB Startup Options”

--bdb-logdir

Section 13.5.3, “BDB Startup Options”
Section 13.5.4, “Characteristics of BDB Tables”
Section 5.7, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.3, “Server System Variables”

--bdb-no-recover

Section 13.5.3, “BDB Startup Options”
Section C.3.31, “Changes in Release 3.23.30 (04 January 2001)”
Section 2.10.2.3, “Starting and Troubleshooting the MySQL Server”

--bdb-no-sync

Section 13.5.3, “BDB Startup Options”
Section C.3.31, “Changes in Release 3.23.30 (04 January 2001)”

--bdb-recover

Section C.3.31, “Changes in Release 3.23.30 (04 January 2001)”

--bdb-shared-data

Section 13.5.3, “BDB Startup Options”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section 5.1.3, “Server System Variables”

--bdb-tmpdir

Section 13.5.3, “BDB Startup Options”
Section 5.7, “Running Multiple MySQL Servers on the Same Machine”

--big-tables

Section 7.8.4, “How MySQL Uses Memory”
Section 5.1.2, “Server Command Options”
Section B.5.2.12, “The table is full”

--bind-address

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 5.5.7, “Causes of Access-Denied Errors”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 5.7, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.2, “Server Command Options”

--binlog-do-db

Section 14.8.4, “Binary Log Options and Variables”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section 14.9.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 14.9, “How Servers Evaluate Replication Filtering Rules”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 14.7.8, “Replication and LOAD Operations”
Section 5.3.4, “The Binary Log”

--binlog-ignore-db

Section 14.8.4, “Binary Log Options and Variables”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section 14.9.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 14.9, “How Servers Evaluate Replication Filtering Rules”
Section 5.3.4, “The Binary Log”

--block-search

Section 4.6.2.4, “Other myisamchk Options”

--bootstrap

Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section 5.1.2, “Server Command Options”

--brief

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

C

[index top]

-C

Section C.3.39, “Changes in Release 3.23.22 (31 July 2000)”
Section 4.6.2.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 5.1.2, “Server Command Options”

-c

Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section 18.2.2.5, “Compiling and Installing User-Defined Functions”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 4.6.1, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.2.2, “myisamchk Check Options”
Section 4.6.3, “myisamlog — Display MyISAM Log File Contents”
Section 15.6, “MySQL 4.1 FAQ: MySQL Cluster”
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 15.4.4, “ndb_config — Extract MySQL Cluster Configuration Information”
Section 15.4.2, “ndb_mgmd — The MySQL Cluster Management Server Daemon”
Section 15.4.14, “ndb_restore — Restore a MySQL Cluster Backup”

CFLAGS

Section 2.12.3, “Solaris Notes”

--cflags

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

--character-set-client-handshake

Section 5.1.2, “Server Command Options”
Section 9.1.12.7.1, “The cp932 Character Set”

--character-set-server

Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section 9.6, “Character Set Configuration”
Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 14.7.2, “Replication and Character Sets”
Section 9.1.3.1, “Server Character Set and Collation”
Section 5.1.2, “Server Command Options”
Section 9.2, “Using the German Character Set”

--character-sets-dir

Section B.5.2.17, “Can't initialize character set”
Section C.3.28, “Changes in Release 3.23.33 (09 February 2001)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section 9.6, “Character Set Configuration”
Section 4.6.2.3, “myisamchk Repair Options”
Section 4.6.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “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.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 15.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”
Section 5.1.2, “Server Command Options”

--check

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

--check-only-changed

Section C.3.48, “Changes in Release 3.23.13 (14 March 2000)”
Section C.3.39, “Changes in Release 3.23.22 (31 July 2000)”
Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section 4.6.2.2, “myisamchk Check Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--checkpoint

Section 4.6.8, “mysqlhotcopy — A Database Backup Program”

--chroot

Section C.3.6, “Changes in Release 3.23.54 (05 December 2002)”
Section C.3.5, “Changes in Release 3.23.55 (23 January 2003)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section C.2.26, “Changes in Release 4.0.6 (14 December 2002: Gamma)”
Section 4.6.8, “mysqlhotcopy — A Database Backup Program”
Section 5.1.2, “Server Command Options”

--clear

Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”

--clear-only

Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”

--code-file

Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”

--col

Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”

--collation-server

Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section 9.6, “Character Set Configuration”
Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 14.7.2, “Replication and Character Sets”
Section 9.1.3.1, “Server Character Set and Collation”
Section 5.1.2, “Server Command Options”
Section 9.2, “Using the German Character Set”

--column-names

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

--columns

Section 4.5.5, “mysqlimport — A Data Import Program”

--comments

Section 4.5.4, “mysqldump — A Database Backup Program”

--commit

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

--comp

Section 4.2.3, “Specifying Program Options”

--compact

Section 4.5.4, “mysqldump — A Database Backup Program”

--compatible

Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section 4.5.4, “mysqldump — A Database Backup Program”

--complete-insert

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section 4.5.4, “mysqldump — A Database Backup Program”

--compr

Section 4.2.3, “Specifying Program Options”

--compress

Section 5.6.6.1, “Basic SSL Concepts”
Section 12.2.5, “LOAD DATA INFILE Syntax”
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.2.3, “Specifying Program Options”

--config-file

Section 15.2.3, “Initial Startup of MySQL Cluster”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 15.6, “MySQL 4.1 FAQ: MySQL Cluster”
Section 15.3.2.1, “MySQL Cluster Configuration: Basic Example”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 15.4.4, “ndb_config — Extract MySQL Cluster Configuration Information”
Section 15.4.2, “ndb_mgmd — The MySQL Cluster Management Server Daemon”

--connect-string

Section 15.6, “MySQL 4.1 FAQ: MySQL Cluster”
Section 15.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”

--console

Section C.2.22, “Changes in Release 4.0.10 (29 January 2003)”
Section 13.2.3.3, “Creating the InnoDB Tablespace”
Section 13.2.14.3, “InnoDB General Troubleshooting”
Section B.5.4.1.1, “Resetting the Root Password: Windows Systems”
Section 5.1.2, “Server Command Options”
Section 13.2.14.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 2.3.9, “Starting the Server for the First Time”
Section 5.3.1, “The Error Log”

--copy

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

--core-file

Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section C.3.15, “Changes in Release 3.23.45 (22 November 2001)”
Section C.3.6, “Changes in Release 3.23.54 (05 December 2002)”
Section 18.4.1.3, “Debugging mysqld under gdb”
Section 2.12.1.4, “Linux Postinstallation Notes”
Section 15.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”
Section 5.1.2, “Server Command Options”

--core-file-size

Section 2.12.1.4, “Linux Postinstallation Notes”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.1.2, “Server Command Options”

--correct-checksum

Section 4.6.2.3, “myisamchk Repair Options”

--count

Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section 4.6.1, “myisam_ftdump — Display Full-Text Index information”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

--create-options

Section 4.5.4, “mysqldump — A Database Backup Program”

D

[index top]

-D

Section 17.6.3.1, “Building C API Client Programs”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.3.8, “Changes in Release 3.23.52 (14 August 2002)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”
Section C.2.25, “Changes in Release 4.0.7 (20 December 2002)”
Appendix A, Licenses for Third-Party Components
Section 4.6.2.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 2.9.3, “MySQL Source-Configuration Options”
Section 18.1.1, “MySQL Threads”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 15.4.15, “ndb_select_all — Print Rows from an NDB Table”
Section 7.10.3, “Using Symbolic Links for Databases on Windows”

-d

Section 4.6.1, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.2.1, “myisamchk General Options”
Section 4.6.12, “mysql_explain_log — Use EXPLAIN on Statements in Query Log”
Section 4.6.5, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.7, “mysqldumpslow — Summarize Slow Query Log Files”
Section 15.4.2, “ndb_mgmd — The MySQL Cluster Management Server Daemon”
Section 15.4.17, “ndb_show_tables — Display List of NDB Tables”
Section 15.4.1, “ndbd — The MySQL Cluster Data Node Daemon”
Section 4.6.2.4, “Other myisamchk Options”

--daemon

Section 15.4.2, “ndb_mgmd — The MySQL Cluster Management Server Daemon”
Section 15.4.1, “ndbd — The MySQL Cluster Data Node Daemon”

--data-file-length

Section 4.6.2.3, “myisamchk Repair Options”

--database

Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 15.4.17, “ndb_show_tables — Display List of NDB Tables”

--databases

Section C.3.49, “Changes in Release 3.23.12 (07 March 2000)”
Section 6.4.5.2, “Copy a Database from one Server to Another”
Section 6.4.1, “Dumping Data in SQL Format with mysqldump”
Section 6.4.5.1, “Making a Copy of a Database”
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”
Section 6.4.2, “Reloading SQL-Format Backups”

--datadir

Section 13.5.3, “BDB Startup Options”
Section 2.9.7.1, “Building MySQL from Source Using VC++”
Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section C.3.10, “Changes in Release 3.23.50 (21 April 2002)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section 2.3.7, “Creating an Option File”
Section 2.9.3, “MySQL Source-Configuration Options”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 4.4.6, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.7, “Running Multiple MySQL Servers on the Same Machine”
Section 5.7.2, “Running Multiple Servers on Unix”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 2.10.2.3, “Starting and Troubleshooting the MySQL Server”
Section 2.10.2, “Unix Postinstallation Procedures”
Section 4.2.3.3, “Using Option Files”

datadir

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section 2.3.7, “Creating an Option File”
Section 2.10.2.2, “Starting and Stopping MySQL Automatically”
Section 2.3.13, “Troubleshooting a MySQL Installation Under Windows”
Section D.3.3, “Windows Platform Limitations”

--date

Section 4.6.12, “mysql_explain_log — Use EXPLAIN on Statements in Query Log”

--db

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

--debug

Section 5.5.7, “Causes of Access-Denied Errors”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section 18.4.1.1, “Compiling MySQL for Debugging”
Section 4.4.2, “make_win_src_distribution — Create Source Distribution for Windows”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 4.6.2.1, “myisamchk General Options”
Section 4.6.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.5, “mysqlaccess — Client for Checking Access Privileges”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “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.6.7, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.6.8, “mysqlhotcopy — 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 15.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”
Section 5.1.2, “Server Command Options”
Section 2.10.2.3, “Starting and Troubleshooting the MySQL Server”
Section 2.3.10, “Starting MySQL from the Windows Command Line”
Section 18.4.3, “The DBUG Package”

--debug-info

Section 4.5.1.1, “mysql Options”

--debugger

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”

--default-character-set

Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.17, “Changes in MySQL 4.1.9 (2005-01-11)”
Section 9.6, “Character Set Configuration”
Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 9.1.4, “Connection Character Sets and Collations”
Section 12.2.5, “LOAD DATA INFILE Syntax”
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 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 8.4, “User-Defined Variables”
Section 9.2, “Using the German Character Set”

--default-collation

Section 5.1.2, “Server Command Options”

--default-storage-engine

Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section 13.2.3, “InnoDB Configuration”
Section 13.2.4, “InnoDB Startup Options and System Variables”
Section 5.1.2, “Server Command Options”
Chapter 13, Storage Engines

--default-table-type

Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 12.4.5.10, “SHOW ENGINES Syntax”
Chapter 13, Storage Engines

--default-time-zone

Section 9.7, “MySQL Server Time Zone Support”
Section 14.7.18, “Replication and Time Zones”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--default.key_buffer_size

Section 5.1.4.1, “Structured System Variables”

--defaults-extra-file

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.3.35, “Changes in Release 3.23.26 (18 October 2000)”
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.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.2.3.3, “Using Option Files”

--defaults-file

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.3.44, “Changes in Release 3.23.17 (07 June 2000)”
Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
Section 5.4.2.2, “End-User Guidelines for Password Security”
Section 13.2.3, “InnoDB Configuration”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 17.5.3, “Options with the Embedded Server”
Section B.5.4.1.1, “Resetting the Root Password: Windows Systems”
Section 5.7, “Running Multiple MySQL Servers on the Same Machine”
Section 5.7.1.2, “Starting Multiple Windows Servers as Services”
Section 5.7.1.1, “Starting Multiple Windows Servers at the Command Line”
Section 2.3.11, “Starting MySQL as a Windows Service”
Section 2.3.4.14, “The Location of the my.ini File”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

--defaults-group-suffix

Section 2.13, “Environment Variables”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”

--delay-key-write

Section C.3.53, “Changes in Release 3.23.8 (02 January 2000)”
Section C.3.52, “Changes in Release 3.23.9 (29 January 2000)”
Section 7.6.4, “External Locking”
Section 13.1.1, “MyISAM Startup Options”
Section 14.10, “Replication FAQ”
Section 5.1.2, “Server Command Options”
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

--delay-key-write-for-all-tables

Section C.3.52, “Changes in Release 3.23.9 (29 January 2000)”
Section 5.1.2, “Server Command Options”

--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 C.3.3, “Changes in Release 3.23.57 (06 June 2003)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section 4.5.4, “mysqldump — A Database Backup Program”

--delimiter

Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section 4.5.1.1, “mysql Options”
Section 15.4.15, “ndb_select_all — Print Rows from an NDB Table”

--demangle

Section 18.4.1.4, “Using a Stack Trace”

--des-key-file

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.2.31, “Changes in Release 4.0.1 (23 December 2001)”
Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”
Section 11.12, “Encryption and Compression Functions”
Section 12.4.6.2, “FLUSH Syntax”
Section 5.1.2, “Server Command Options”

--descending

Section 15.4.15, “ndb_select_all — Print Rows from an NDB Table”

--description

Section 4.6.2.4, “Other myisamchk Options”

--dirname

Section 4.4.2, “make_win_src_distribution — Create Source Distribution for Windows”

--disable

Section 4.2.3.2, “Program Option Modifiers”

--disable-keys

Section 4.5.4, “mysqldump — A Database Backup Program”

--disable-large-files

Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”

--disable-log-bin

Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”

--disable-shared

Section 2.12.4.6, “BSD/OS Version 4.x Notes”
Section 2.9.3, “MySQL Source-Configuration Options”

--disconnect-slave-event-count

Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section 14.8.3, “Replication Slave Options and Variables”

--dryrun

Section 4.6.8, “mysqlhotcopy — A Database Backup Program”

--dump

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

E

[index top]

-E

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

-e

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section 6.6.2, “How to Check MyISAM Tables for Errors”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 4.6.2.2, “myisamchk Check Options”
Section 4.6.2.1, “myisamchk General Options”
Section 4.6.2.3, “myisamchk Repair Options”
Section 15.6, “MySQL 4.1 FAQ: MySQL Cluster”
Section 4.5.1.1, “mysql Options”
Section 4.6.12, “mysql_explain_log — Use EXPLAIN on Statements in Query Log”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 15.4.3, “ndb_mgm — The MySQL Cluster Management Client”
Section 4.6.2.5, “Obtaining Table Information with myisamchk”
Section 15.2.5, “Safe Shutdown and Restart of MySQL Cluster”
Section 4.2.3.1, “Using Options on the Command Line”
Section 15.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”

--embedded

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

--enable-

Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”

--enable-assembler

Section 2.12.3, “Solaris Notes”

--enable-large-files

Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”

--enable-local-infile

Section C.3.10, “Changes in Release 3.23.50 (21 April 2002)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section 5.4.5, “Security Issues with LOAD DATA LOCAL”

--enable-locking

Section 7.6.4, “External Locking”
Section 5.1.2, “Server Command Options”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

--enable-named-commands

Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”

--enable-named-pipe

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section C.3.10, “Changes in Release 3.23.50 (21 April 2002)”
Section 4.2.2, “Connecting to the MySQL Server”
Section 2.3.8, “Selecting a MySQL Server Type”
Section 5.1.2, “Server Command Options”
Section 1.3.2, “The Main Features of MySQL”

--enable-pstack

Section 5.1.2, “Server Command Options”

--enable-thread-safe-client

Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section 2.9.3, “MySQL Source-Configuration Options”

--err-log

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.3.1, “The Error Log”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

--example

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--execute

Section 4.5.1.3, “mysql Logging”
Section 4.5.1.1, “mysql Options”
Section 15.4.3, “ndb_mgm — The MySQL Cluster Management Client”
Section 4.2.3.1, “Using Options on the Command Line”
Section 15.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”

--exit-info

Section 5.1.2, “Server Command Options”

--expire-logs-days

Section C.1.17, “Changes in MySQL 4.1.9 (2005-01-11)”

--extend-check

Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section 4.6.2.2, “myisamchk Check Options”
Section 4.6.2.1, “myisamchk General Options”
Section 4.6.2.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”

--extern

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”

--external-locking

Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section 7.6.4, “External Locking”
Section 2.9.6, “MIT-pthreads Notes”
Section 13.1.1, “MyISAM Startup Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

--extra-file

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

--extra-partition-info

Section 15.4.7, “ndb_desc — Describe NDB Tables”

F

[index top]

-F

Section C.3.39, “Changes in Release 3.23.22 (31 July 2000)”
Section 4.6.2.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”

-f

Section 2.9.5, “Compiling and Linking an Optimized mysqld Server”
Section 2.9.4, “Dealing with Problems Compiling MySQL”
Section 2.12.5.3, “IBM-AIX notes”
Section 15.2.3, “Initial Startup of MySQL Cluster”
Section 2.9, “Installing MySQL from Source”
Section 2.12.1.7, “Linux Alpha Notes”
Section 4.6.2.2, “myisamchk Check Options”
Section 4.6.2.3, “myisamchk Repair Options”
Section 4.6.3, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 15.6, “MySQL 4.1 FAQ: MySQL Cluster”
Section 4.5.1.1, “mysql Options”
Section 4.6.18, “mysql_zap — Kill Processes That Match a Pattern”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “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.5, “mysqlimport — A Data Import Program”
Section 15.4.4, “ndb_config — Extract MySQL Cluster Configuration Information”
Section 15.4.2, “ndb_mgmd — The MySQL Cluster Management Server Daemon”
Section 18.4.1.4, “Using a Stack Trace”

--fast

Section C.3.48, “Changes in Release 3.23.13 (14 March 2000)”
Section C.3.39, “Changes in Release 3.23.22 (31 July 2000)”
Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section 4.6.2.2, “myisamchk Check Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--fields

Section 15.4.4, “ndb_config — Extract MySQL Cluster Configuration Information”

--fields-*-by

Section C.3.31, “Changes in Release 3.23.30 (04 January 2001)”

--fields-enclosed-by

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

--fields-escaped-by

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

--fields-optionally-enclosed-by

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

--fields-terminated-by

Section 6.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
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”

--first-slave

Section C.3.3, “Changes in Release 3.23.57 (06 June 2003)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section 4.5.4, “mysqldump — A Database Backup Program”

--flush

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

--flush-logs

Section 6.3.1, “Establishing a Backup Policy”
Section 4.5.4, “mysqldump — A Database Backup Program”

--flush_time

Section 18.1.1, “MySQL Threads”

--flushlog

Section 4.6.8, “mysqlhotcopy — A Database Backup Program”

--fno-common

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”

--force

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.3.20, “Changes in Release 3.23.40 (18 July 2001)”
Section 2.12.1.2, “Linux Binary Distribution Notes”
Section 4.6.2.2, “myisamchk Check Options”
Section 4.6.2.3, “myisamchk Repair Options”
Section 4.6.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.4.6, “mysql_install_db — Initialize MySQL Data Directory”
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 18.1.2, “The MySQL Test Suite”
Section 3.5, “Using mysql in Batch Mode”

--force-read

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

forcedirectio

Section 2.12.3, “Solaris Notes”

--fs

Section 15.4.10, “ndb_error_reporter — NDB Error-Reporting Utility”

G

[index top]

-G

Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section 4.5.1.1, “mysql Options”

-g

Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section 18.4.1.1, “Compiling MySQL for Debugging”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 4.5.1.1, “mysql Options”
Section 4.6.7, “mysqldumpslow — Summarize Slow Query Log Files”

--gci

Section 15.4.15, “ndb_select_all — Print Rows from an NDB Table”

--gdb

Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section 18.4.1.3, “Debugging mysqld under gdb”
Section 5.1.2, “Server Command Options”

H

[index top]

-H

Section 4.6.2.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.5, “mysqlaccess — Client for Checking Access Privileges”

-h

Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.2.1, “Invoking MySQL Programs”
Section 2.9.6, “MIT-pthreads Notes”
Section 4.6.1, “myisam_ftdump — Display Full-Text Index information”
Section 4.5.1.1, “mysql Options”
Section 4.6.12, “mysql_explain_log — Use EXPLAIN on Statements in Query Log”
Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 4.6.5, “mysqlaccess — Client for Checking Access Privileges”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “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.6.7, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.6.8, “mysqlhotcopy — 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.7.4, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
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

Section 15.4.15, “ndb_select_all — Print Rows from an NDB Table”

--HELP

Section 4.6.2.1, “myisamchk General Options”

--help

Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section 4.4.2, “make_win_src_distribution — Create Source Distribution for Windows”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 4.6.1, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.2.1, “myisamchk General Options”
Section 4.6.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.12, “mysql_explain_log — Use EXPLAIN on Statements in Query Log”
Section 4.6.13, “mysql_find_rows — Extract SQL Statements from Files”
Section 4.6.15, “mysql_setpermission — Interactively Set Permissions in Grant Tables”
Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 4.6.17, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.6.18, “mysql_zap — Kill Processes That Match a Pattern”
Section 4.6.5, “mysqlaccess — Client for Checking Access Privileges”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.7, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.6.8, “mysqlhotcopy — 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 15.4.4, “ndb_config — Extract MySQL Cluster Configuration Information”
Section 15.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”
Section 4.1, “Overview of MySQL Programs”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.7.4, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 5.1.2, “Server Command Options”
Section 2.10.2.3, “Starting and Troubleshooting the MySQL Server”
Section 1.3.2, “The Main Features of MySQL”
Section 7.8.2, “Tuning Server Parameters”
Chapter 3, Tutorial
Section 2.10.2, “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 C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.2.9, “Changes in Release 4.0.23 (18 December 2004)”
Section 4.5.4, “mysqldump — A Database Backup Program”

--host

Section 5.5.7, “Causes of Access-Denied Errors”
Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.2.1, “Invoking MySQL Programs”
Section 2.9.6, “MIT-pthreads Notes”
Section 4.5.1.1, “mysql Options”
Section 4.6.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.12, “mysql_explain_log — Use EXPLAIN on Statements in Query Log”
Section 4.6.15, “mysql_setpermission — Interactively Set Permissions in Grant Tables”
Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 4.6.5, “mysqlaccess — Client for Checking Access Privileges”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “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.6.8, “mysqlhotcopy — 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 15.4.4, “ndb_config — Extract MySQL Cluster Configuration Information”
Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
Section 5.1.3, “Server System Variables”
Section 1.2, “Typographical and Syntax Conventions”
Section 5.7.3, “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.5, “mysqlaccess — Client for Checking Access Privileges”

--html

Section 4.5.1.1, “mysql Options”

I

[index top]

-I

Section 17.6.3.1, “Building C API Client Programs”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.6.3, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.17, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.6.18, “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 C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section 15.5.2, “Commands in the MySQL Cluster Management Client”
Section 6.6.2, “How to Check MyISAM Tables for Errors”
Section 4.6.2.2, “myisamchk Check Options”
Section 4.6.3, “myisamlog — Display MyISAM Log File Contents”
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”
Section 4.6.7, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 15.4.1, “ndbd — The MySQL Cluster Data Node Daemon”

--i-am-a-dummy

Section C.3.50, “Changes in Release 3.23.11 (16 February 2000)”
Section 4.5.1.1, “mysql Options”
Section 4.5.1.6.2, “Using the --safe-updates Option”

--id

Section 15.4.4, “ndb_config — Extract MySQL Cluster Configuration Information”

--idx

Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”

--ignore

Section 4.5.5, “mysqlimport — A Data Import Program”

--ignore-lines

Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 4.5.5, “mysqlimport — A Data Import Program”

--ignore-space

Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”

--ignore-spaces

Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”
Section 4.5.1.1, “mysql Options”

--ignore-table

Section 4.5.4, “mysqldump — A Database Backup Program”

--include

Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section 4.7.2, “mysql_config — Display Options for Compiling Clients”

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

--information

Section 4.6.2.2, “myisamchk Check Options”

--init-file

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.3.59, “Changes in Release 3.23.2 (09 August 1999)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section B.5.4.1.2, “Resetting the Root Password: Unix Systems”
Section B.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 13.4, “The MEMORY (HEAP) Storage Engine”

--init_connect

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

--initial

Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section 15.3.2.5, “Defining MySQL Cluster Data Nodes”
Section 15.6, “MySQL 4.1 FAQ: MySQL Cluster”
Section 15.3.3.1, “MySQL Cluster Data Node Configuration Parameters”
Section 15.3.3.2, “MySQL Cluster Management Node Configuration Parameters”
Section 15.3.3.3, “MySQL Cluster SQL Node and API Node Configuration Parameters”
Section 15.4.14, “ndb_restore — Restore a MySQL Cluster Backup”
Section 15.4.1, “ndbd — The MySQL Cluster Data Node Daemon”
Section 15.3.3.4, “Other MySQL Cluster Configuration Parameters”
Section 15.3.3, “Overview of MySQL Cluster Configuration Parameters”
Section 15.2.6.1, “Performing a Rolling Restart of a MySQL Cluster”
Section 15.5.1, “Summary of MySQL Cluster Start Phases”

--innodb

Section 13.2.4, “InnoDB Startup Options and System Variables”

--innodb-safe-binlog

Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section 14.7.10, “Replication and Master or Slave Shutdowns”
Section 5.1.2, “Server Command Options”
Section 5.3.4, “The Binary Log”

innodb-status-file

Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.4.1, “Changes in MySQL/InnoDB-4.0.21, September 10, 2004”
Section C.4.2, “Changes in MySQL/InnoDB-4.1.4, August 31, 2004”
Section C.2.9, “Changes in Release 4.0.23 (18 December 2004)”
Section 13.2.14.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”

--innodb-status-file

Section C.4.1, “Changes in MySQL/InnoDB-4.0.21, September 10, 2004”
Section C.4.2, “Changes in MySQL/InnoDB-4.1.4, August 31, 2004”
Section 13.2.4, “InnoDB Startup Options and System Variables”

--innodb-xxx

Section 5.1.2, “Server Command Options”

--innodb_buffer_pool_awe_mem_mb

Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”

--innodb_file_per_table

Section C.1.9, “Changes in MySQL 4.1.17 (Not released)”
Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section 13.2.3.1, “Using Per-Table Tablespaces”
Section 7.10.3, “Using Symbolic Links for Databases on Windows”

innodb_table_locks

Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

--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.7.1.2, “Starting Multiple Windows Servers as Services”
Section 2.3.11, “Starting MySQL as a Windows Service”

--install-manual

Section 5.1.2, “Server Command Options”
Section 5.7.1.2, “Starting Multiple Windows Servers as Services”
Section 2.3.11, “Starting MySQL as a Windows Service”

--interactive-timeout

Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”

J

[index top]

-j

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

--join

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

K

[index top]

-K

Section 4.5.4, “mysqldump — A Database Backup Program”

-k

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

--keepold

Section 4.6.8, “mysqlhotcopy — A Database Backup Program”

--key_buffer_size

Section 5.1.2, “Server Command Options”

--key_cache_block_size

Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”

--keys

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

--keys-used

Section 4.6.2.3, “myisamchk Repair Options”

L

[index top]

-L

Section 17.6.3.1, “Building C API Client Programs”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.2.5, “Changes in Release 4.0.27 (06 May 2006)”
Section 2.12.1.3, “Linux Source Distribution Notes”
Section 4.5.1.1, “mysql Options”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 2.14.3, “Problems Using the Perl DBI/DBD Interface”
Section 5.4.5, “Security Issues with LOAD DATA LOCAL”
Section 9.3, “Setting the Error Message Language”
Section 2.12.3, “Solaris Notes”

-l

Section 2.12.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 17.6.3.1, “Building C API Client Programs”
Section 17.6.12, “C API Embedded Server Function Descriptions”
Section 17.6.5, “C API Function Overview”
Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section C.3.21, “Changes in Release 3.23.39 (12 June 2001)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section 17.5.1, “Compiling Programs with libmysqld”
Section 2.9.4, “Dealing with Problems Compiling MySQL”
Section 4.6.1, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.2.3, “myisamchk Repair Options”
Section 17.6.6.37, “mysql_library_end()”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.7, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 15.4.15, “ndb_select_all — Print Rows from an NDB Table”
Section 15.4.17, “ndb_show_tables — Display List of NDB Tables”
Section 2.14.3, “Problems Using the Perl DBI/DBD Interface”
Section 2.12.5.8, “SCO UNIX and OpenServer 5.0.x Notes”
Section 5.1.2, “Server Command Options”
Section 2.12.3.1, “Solaris 2.7/2.8 Notes”
Section 2.12.3, “Solaris Notes”
Section 5.3.2, “The General Query Log”

--language

Section 5.1.2, “Server Command Options”
Section 9.3, “Setting the Error Message Language”

--ldata

Section 4.4.6, “mysql_install_db — Initialize MySQL Data Directory”

--ledir

Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--length

Section 4.6.1, “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 C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section 4.7.2, “mysql_config — Display Options for Compiling Clients”

--line-numbers

Section 4.5.1.1, “mysql Options”

--lines-terminated-by

Section C.3.31, “Changes in Release 3.23.30 (04 January 2001)”
Section 6.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”

--local

Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section 12.2.5, “LOAD DATA INFILE Syntax”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 5.4.5, “Security Issues with LOAD DATA LOCAL”
Section 18.1.2, “The MySQL Test Suite”

--local-infile

Section 12.2.5, “LOAD DATA INFILE Syntax”
Section 4.5.1.1, “mysql Options”
Section 5.4.5, “Security Issues with LOAD DATA LOCAL”
Section 5.4.4, “Security-Related mysqld Options”

--local-load

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”

--lock

Section 15.4.15, “ndb_select_all — Print Rows from an NDB Table”

--lock-all-tables

Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
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”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”

--log

Section 5.5.7, “Causes of Access-Denied Errors”
Section 18.4.1.6, “Making a Test Case If You Experience Table Corruption”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 5.7, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.2, “Server Command Options”
Section 5.3.6, “Server Log Maintenance”
Section 5.3.2, “The General Query Log”
Section 18.4.1.5, “Using Server Logs to Find Causes of Errors in mysqld”

--log-bin

Section 6.3.3, “Backup Strategy Summary”
Section 14.8.4, “Binary Log Options and Variables”
Section 12.5.2.1, “CHANGE MASTER TO Syntax”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.1.17, “Changes in MySQL 4.1.9 (2005-01-11)”
Section C.3.36, “Changes in Release 3.23.25 (29 September 2000)”
Section C.3.10, “Changes in Release 3.23.50 (21 April 2002)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section 6.2, “Database Backup Methods”
Section 6.3.1, “Establishing a Backup Policy”
Section 14.12, “How to Report Replication Bugs or Problems”
Section 18.4.1.6, “Making a Test Case If You Experience Table Corruption”
Section B.5.8.4, “Open Issues in MySQL”
Section 6.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
Section 12.5.1.1, “PURGE BINARY LOGS Syntax”
Section 14.10, “Replication FAQ”
Section 14.8.3, “Replication Slave Options and Variables”
Section 5.7, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.2, “Server Command Options”
Section 5.3.6, “Server Log Maintenance”
Section 5.1.3, “Server System Variables”
Section 5.3.4, “The Binary Log”
Section 5.3.2, “The General Query Log”
Section 14.11, “Troubleshooting Replication”
Section 6.3.2, “Using Backups for Recovery”

--log-bin-index

Section 14.8.4, “Binary Log Options and Variables”
Section 5.3.4, “The Binary Log”

--log-error

Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section C.2.22, “Changes in Release 4.0.10 (29 January 2003)”
Section 12.4.6.2, “FLUSH Syntax”
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.7, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.2, “Server Command Options”
Section 5.3.6, “Server Log Maintenance”
Section 5.3.1, “The Error Log”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

--log-isam

Section C.3.36, “Changes in Release 3.23.25 (29 September 2000)”
Section 5.7, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.2, “Server Command Options”

--log-long-format

Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section 5.1.2, “Server Command Options”
Section 5.3.5, “The Slow Query Log”

--log-queries-not-using-indexes

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section 5.1.2, “Server Command Options”
Section 5.3.5, “The Slow Query Log”

--log-short-format

Section 5.1.2, “Server Command Options”
Section 5.3.5, “The Slow Query Log”

--log-slave-updates

Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section 14.12, “How to Report Replication Bugs or Problems”
Section 14.7.21, “Other Replication Features”
Section 14.10, “Replication FAQ”
Section 14.8.3, “Replication Slave Options and Variables”
Section 5.3.4, “The Binary Log”

--log-slow-admin-statements

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section 5.1.2, “Server Command Options”
Section 5.3.5, “The Slow Query Log”

--log-slow-queries

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.3.39, “Changes in Release 3.23.22 (31 July 2000)”
Section C.3.35, “Changes in Release 3.23.26 (18 October 2000)”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section C.3.5, “Changes in Release 3.23.55 (23 January 2003)”
Section C.3.52, “Changes in Release 3.23.9 (29 January 2000)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section 5.1.2, “Server Command Options”
Section 5.3.6, “Server Log Maintenance”
Section 5.1.3, “Server System Variables”
Section 5.3.5, “The Slow Query Log”
Section 18.4.1.5, “Using Server Logs to Find Causes of Errors in mysqld”

--log-update

Section 5.7, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.2, “Server Command Options”
Section 5.3.6, “Server Log Maintenance”
Section 5.3.3, “The Update Log”

--log-warnings

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section B.5.2.11, “Communication Errors and Aborted Connections”
Section 14.4, “How to Set Up Replication”
Section B.5.2.9, “MySQL server has gone away”
Section 14.8.3, “Replication Slave Options and Variables”
Section 5.1.2, “Server Command Options”
Section 5.3.1, “The Error Log”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

--loops

Section 15.4.17, “ndb_show_tables — Display List of NDB Tables”

--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 C.3.50, “Changes in Release 3.23.11 (16 February 2000)”
Section C.3.20, “Changes in Release 3.23.40 (18 July 2001)”
Section 7.6.3, “Concurrent Inserts”
Section 12.2.4, “INSERT Syntax”
Section 14.10, “Replication FAQ”
Section 5.1.2, “Server Command Options”
Section 7.6.2, “Table Locking Issues”

--lower-case-table-names

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.3.5, “Changes in Release 3.23.55 (23 January 2003)”
Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section C.2.21, “Changes in Release 4.0.11 (20 February 2003)”
Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section C.2.26, “Changes in Release 4.0.6 (14 December 2002: Gamma)”
Section 8.2.2, “Identifier Case Sensitivity”

--lower_case_table_names

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.3.18, “Changes in Release 3.23.42 (08 September 2001)”

M

[index top]

-m

Section 2.9.5, “Compiling and Linking an Optimized mysqld Server”
Section 2.12.5.3, “IBM-AIX notes”
Section 4.6.2.2, “myisamchk Check Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 15.4.14, “ndb_restore — Restore a MySQL Cluster Backup”
Section 2.3.8, “Selecting a MySQL Server Type”
Section 2.12.3, “Solaris Notes”

--master-connect-retry

Section 14.7.10, “Replication and Master or Slave Shutdowns”
Section 14.2, “Replication Implementation Overview”
Section 7.11.5, “Replication Slave I/O Thread States”
Section 14.8.3, “Replication Slave Options and Variables”
Section 12.4.5.21, “SHOW SLAVE STATUS Syntax”

--master-data

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.3.3, “Changes in Release 3.23.57 (06 June 2003)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section 6.3.1, “Establishing a Backup Policy”
Section 4.5.4, “mysqldump — A Database Backup Program”

--master-host

Section 14.8.3, “Replication Slave Options and Variables”

--master-info-file

Section 14.8.3, “Replication Slave Options and Variables”
Section 14.3.3, “The Slave Status Files”

--master-password

Section 14.8.3, “Replication Slave Options and Variables”

--master-port

Section 14.8.3, “Replication Slave Options and Variables”

--master-retry-count

Section 12.5.2.1, “CHANGE MASTER TO Syntax”
Section 14.8.3, “Replication Slave Options and Variables”

--master-ssl

Section 14.8.3, “Replication Slave Options and Variables”

--master-ssl*

Section 5.6.6.3, “SSL Command Options”

--master-ssl-ca

Section 14.8.3, “Replication Slave Options and Variables”

--master-ssl-capath

Section 14.8.3, “Replication Slave Options and Variables”

--master-ssl-cert

Section 14.8.3, “Replication Slave Options and Variables”

--master-ssl-cipher

Section 14.8.3, “Replication Slave Options and Variables”

--master-ssl-key

Section 14.8.3, “Replication Slave Options and Variables”

--master-user

Section 14.8.3, “Replication Slave Options and Variables”

--max

Section 4.2.3.4, “Using Options to Set Program Variables”

--max-binlog-dump-events

Section 14.8.4, “Binary Log Options and Variables”

--max-binlog-size

Section 14.8.3, “Replication Slave Options and Variables”

--max-connections

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”

--max-record-length

Section 4.6.2.3, “myisamchk Repair Options”
Section 12.4.2.6, “REPAIR TABLE Syntax”

--max-relay-log-size

Section 14.8.3, “Replication Slave Options and Variables”

--max-seeks-for-key

Section 7.3.1.11, “How to Avoid Table Scans”
Section B.5.6, “Optimizer-Related Issues”

--max_a

Section 4.2.3.4, “Using Options to Set Program Variables”

--max_connect_errors

Section 12.4.6.2, “FLUSH Syntax”

--max_join_size

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

--max_sort_length

Section 10.4.3, “The BLOB and TEXT Types”

--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.2.2, “myisamchk Check Options”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--memlock

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.3.36, “Changes in Release 3.23.25 (29 September 2000)”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 13.2.3.2, “Using Raw Devices for the Shared Tablespace”

--method

Section 4.6.8, “mysqlhotcopy — A Database Backup Program”

myisam-block-size

Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”

--myisam-block-size

Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section 7.5.1.5, “Key Cache Block Size”
Section 5.1.2, “Server Command Options”

--myisam-recover

Section C.3.35, “Changes in Release 3.23.26 (18 October 2000)”
Section 13.1.1, “MyISAM Startup Options”
Section 7.3.3, “Other Optimization Tips”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section B.5.2.19, “Table-Corruption Issues”
Section 13.1, “The MyISAM Storage Engine”
Section 18.4.1.5, “Using Server Logs to Find Causes of Errors in mysqld”

--mysql-version

Section C.3.23, “Changes in Release 3.23.37 (17 April 2001)”

--mysqladmin

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--mysqld

Section C.3.31, “Changes in Release 3.23.30 (04 January 2001)”
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”

-n

Section 15.5.2, “Commands in the MySQL Cluster Management Client”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 4.6.2.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.7, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.6.8, “mysqlhotcopy — A Database Backup Program”
Section 15.4.14, “ndb_restore — Restore a MySQL Cluster Backup”
Section 15.4.19, “ndb_waiter — Wait for MySQL Cluster to Reach a Given Status”
Section 15.4.1, “ndbd — The MySQL Cluster Data Node Daemon”
Section 4.7.4, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 2.3.8, “Selecting a MySQL Server Type”

--named-commands

Section 4.5.1.1, “mysql Options”

--ndb

Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section 4.8.1, “perror — Explain Error Codes”

--ndb-cluster

Section 5.2, “The mysqld-max Extended MySQL Server”

--ndb-connectstring

Section 15.6, “MySQL 4.1 FAQ: MySQL Cluster”
Section 15.1.1, “MySQL Cluster Core Concepts”
Section 15.5.4, “MySQL Server Usage for MySQL Cluster”
Section 15.3.4.2, “mysqld Command Options for MySQL Cluster”
Section 15.4.4, “ndb_config — Extract MySQL Cluster Configuration Information”

--ndb-mgmd-host

Section 15.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”

--ndb-nodeid

Section 15.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”

--ndb-optimized-node-selection

Section 15.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”

--ndbcluster

Section 15.6, “MySQL 4.1 FAQ: MySQL Cluster”
Section 15.5.9.2, “MySQL Cluster and MySQL Privileges”
Section 15.3, “MySQL Cluster Configuration”
Section 15.1.1, “MySQL Cluster Core Concepts”
Section 15.5.4, “MySQL Server Usage for MySQL Cluster”
Section 15.3.4.2, “mysqld Command Options for MySQL Cluster”
Section 5.2, “The mysqld-max Extended MySQL Server”

net_retry_count

Section 14.3, “Replication Implementation Details”

net_write_timeout

Section 14.3, “Replication Implementation Details”

--new

Section C.2.20, “Changes in Release 4.0.12 (15 March 2003: Production)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section 10.1.2, “Date and Time Type Overview”
Section 8.1.4, “Hexadecimal Literals”
Section 5.1.2, “Server Command Options”
Section 10.3.1.1, “TIMESTAMP Properties Prior to MySQL 4.1”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”
Section 4.2.3.3, “Using Option Files”

--nice

Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

--no-auto-rehash

Section 4.5.1.1, “mysql Options”

--no-autocommit

Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section 4.5.4, “mysqldump — A Database Backup Program”

--no-beep

Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 4.5.1.1, “mysql Options”

--no-contact

Section 15.4.19, “ndb_waiter — Wait for MySQL Cluster to Reach a Given Status”

--no-create-db

Section 4.5.4, “mysqldump — A Database Backup Program”

--no-create-info

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

--no-data

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section 6.4.5.3, “Dumping Table Definitions and Content Separately”
Section 4.5.4, “mysqldump — A Database Backup Program”

--no-defaults

Section 5.5.7, “Causes of Access-Denied Errors”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.3.44, “Changes in Release 3.23.17 (07 June 2000)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
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.2, “mysqld_safe — MySQL Server Startup Script”

--no-log

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--no-named-commands

Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section 4.5.1.1, “mysql Options”

--no-pager

Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section 4.5.1.1, “mysql Options”

--no-set-names

Section 4.5.4, “mysqldump — A Database Backup Program”

--no-symlinks

Section 4.6.2.3, “myisamchk Repair Options”

--no-tee

Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section 4.5.1.1, “mysql Options”

--nodaemon

Section 15.4.2, “ndb_mgmd — The MySQL Cluster Management Server Daemon”
Section 15.4.1, “ndbd — The MySQL Cluster Data Node Daemon”

--nodata

Section 15.4.15, “ndb_select_all — Print Rows from an NDB Table”

--nodeid

Section 15.4.4, “ndb_config — Extract MySQL Cluster Configuration Information”

--nodes

Section 15.4.4, “ndb_config — Extract MySQL Cluster Configuration Information”

--noindices

Section 4.6.8, “mysqlhotcopy — A Database Backup Program”

--nostart

Section 15.4.1, “ndbd — The MySQL Cluster Data Node Daemon”

--not-started

Section 15.4.19, “ndb_waiter — Wait for MySQL Cluster to Reach a Given Status”

--numeric-dump-file

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

O

[index top]

-O

Section 2.12.5.6, “Alpha-DEC-OSF/1 Notes”
Section C.3.30, “Changes in Release 3.23.31 (17 January 2001: Production)”
Section C.3.7, “Changes in Release 3.23.53 (09 October 2002)”
Section C.3.55, “Changes in Release 3.23.6 (15 December 1999)”
Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section 2.9.4, “Dealing with Problems Compiling MySQL”
Section 2.12.5.1, “HP-UX Version 10.20 Notes”
Section 2.12.5.3, “IBM-AIX notes”
Section 4.6.2.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 2.12.3, “Solaris Notes”
Section 7.8.2, “Tuning Server Parameters”

-o

Section 18.2.2.5, “Compiling and Installing User-Defined Functions”
Section 17.5.1, “Compiling Programs with libmysqld”
Section 7.9, “Disk Issues”
Section 4.6.2.3, “myisamchk Repair Options”
Section 4.6.3, “myisamlog — Display MyISAM Log File Contents”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 15.4.15, “ndb_select_all — Print Rows from an NDB Table”
Section 5.1.2, “Server Command Options”

--offset

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

--old-passwords

Section B.5.2.4, “Client does not support authentication protocol”
Section 5.4.2.3, “Password Hashing in MySQL”
Section 14.7.6, “Replication and System Functions”
Section B.5.4.1.3, “Resetting the Root Password: Generic Instructions”
Section 5.4.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

--old-protocol

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section B.5.2.15, “Ignoring user”
Section 17.6.6.50, “mysql_real_connect()”
Section 5.1.2, “Server Command Options”

--old-rpl-compat

Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”

--old_server

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

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”

--open-files

Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.3.31, “Changes in Release 3.23.30 (04 January 2001)”

open-files-limit

Section B.5.2.7, “Too many connections”

--open-files-limit

Section B.5.2.18, “'File' Not Found and Similar Errors”
Section C.3.31, “Changes in Release 3.23.30 (04 January 2001)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”
Section 2.12.4.1, “FreeBSD Notes”
Section 7.7.2, “How MySQL Opens and Closes Tables”
Section 13.2.4, “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”

open_files_limit

Section D.3.3, “Windows Platform Limitations”

--opt

Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section 2.11.5, “Copying MySQL Databases to Another Machine”
Section 13.2.14.1, “InnoDB Performance Tuning Tips”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 2.11.4, “Rebuilding or Repairing Tables or Indexes”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

--opt_name

Section 4.2.3.3, “Using Option Files”

--optimize

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--order

Section 15.4.15, “ndb_select_all — Print Rows from an NDB Table”

--order-by-primary

Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section 4.5.4, “mysqldump — A Database Backup Program”

P

[index top]

-P

Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.5.1.1, “mysql Options”
Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 4.6.5, “mysqlaccess — Client for Checking Access Privileges”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “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.6.8, “mysqlhotcopy — 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 15.4.2, “ndb_mgmd — The MySQL Cluster Management Server Daemon”
Section 5.1.2, “Server Command Options”

-p

Section 5.6.2, “Adding User Accounts”
Section 2.12.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 5.5.7, “Causes of Access-Denied Errors”
Section C.3.1, “Changes in Release 3.23.59 (Not released)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section 4.2.2, “Connecting to the MySQL Server”
Section 5.4.2.2, “End-User Guidelines for Password Security”
Section 2.7, “Installing MySQL on NetWare”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.6.2.3, “myisamchk Repair Options”
Section 4.6.3, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.12, “mysql_explain_log — Use EXPLAIN on Statements in Query Log”
Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 4.6.5, “mysqlaccess — Client for Checking Access Privileges”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “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.6.8, “mysqlhotcopy — 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 15.4.7, “ndb_desc — Describe NDB Tables”
Section 15.4.17, “ndb_show_tables — Display List of NDB Tables”
Section B.5.2.5, “Password Fails When Entered Interactively”
Section 2.10.3, “Securing the Initial MySQL Accounts”
Section 2.3.11, “Starting MySQL as a Windows Service”
Section 2.3.10, “Starting MySQL from the Windows Command Line”
Section 2.3.12, “Testing The MySQL Installation”
Section 2.3.14, “Upgrading MySQL on Windows”
Section 5.6.1, “User Names and Passwords”
Section 4.2.3.1, “Using Options on the Command Line”
Section 2.10.1, “Windows Postinstallation Procedures”

--packlength

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

--pager

Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”

--parallel-recover

Section 4.6.2.3, “myisamchk Repair Options”

--parsable

Section 15.4.17, “ndb_show_tables — Display List of NDB Tables”

--password

Section 5.6.2, “Adding User Accounts”
Section 5.5.7, “Causes of Access-Denied Errors”
Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section C.3.1, “Changes in Release 3.23.59 (Not released)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section 4.2.2, “Connecting to the MySQL Server”
Section 5.4.2.2, “End-User Guidelines for Password Security”
Section 6.3, “Example Backup and Recovery Strategy”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.5.1.1, “mysql Options”
Section 4.6.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.12, “mysql_explain_log — Use EXPLAIN on Statements in Query Log”
Section 4.6.15, “mysql_setpermission — Interactively Set Permissions in Grant Tables”
Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 4.6.5, “mysqlaccess — Client for Checking Access Privileges”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.8, “mysqlhotcopy — 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 B.5.2.5, “Password Fails When Entered Interactively”
Section 5.6.1, “User Names and Passwords”
Section 4.2.3.1, “Using Options on the Command Line”

pid-file

Section 2.10.2.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.7, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--pipe

Section 4.2.2, “Connecting to the MySQL Server”
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 2.3.12, “Testing The MySQL Installation”

--plan

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

--port

Section 5.5.7, “Causes of Access-Denied Errors”
Section C.3.7, “Changes in Release 3.23.53 (09 October 2002)”
Section 4.2.2, “Connecting to the MySQL Server”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.5.1.1, “mysql Options”
Section 2.9.3, “MySQL Source-Configuration Options”
Section 4.7.2, “mysql_config — Display Options for Compiling Clients”
Section 4.6.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.15, “mysql_setpermission — Interactively Set Permissions in Grant Tables”
Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.8, “mysqlhotcopy — 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.7, “Running Multiple MySQL Servers on the Same Machine”
Section 5.7.2, “Running Multiple Servers on Unix”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 2.10.2.3, “Starting and Troubleshooting the MySQL Server”
Section 5.7.3, “Using Client Programs in a Multiple-Server Environment”

--position

Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”

--prefix

Section 2.9.2, “Installing MySQL from a Development Source Tree”
Section 15.2.1, “MySQL Cluster Multi-Computer Installation”
Section 2.9.3, “MySQL Source-Configuration Options”
Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 5.7.2, “Running Multiple Servers on Unix”

--preview

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

--print

Section 15.4.14, “ndb_restore — Restore a MySQL Cluster Backup”

--print-defaults

Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
Section 2.11.1, “Upgrading MySQL”

--print-full-config

Section 15.4.2, “ndb_mgmd — The MySQL Cluster Management Server Daemon”

--print-libgcc-file

Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”

--printerror

Section 4.6.12, “mysql_explain_log — Use EXPLAIN on Statements in Query Log”

--prompt

Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”

--protocol

Section 4.2.2, “Connecting to the MySQL Server”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “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.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 5.7.2, “Running Multiple Servers on Unix”
Section 2.3.9, “Starting the Server for the First Time”
Section 2.3.12, “Testing The MySQL Installation”
Section 1.3.2, “The Main Features of MySQL”
Section 5.7.3, “Using Client Programs in a Multiple-Server Environment”

Q

[index top]

-Q

Section 4.5.4, “mysqldump — A Database Backup Program”

-q

Section 2.12.5.3, “IBM-AIX notes”
Section 4.6.2.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.8, “mysqlhotcopy — A Database Backup Program”
Section 15.4.4, “ndb_config — Extract MySQL Cluster Configuration Information”

--query

Section 15.4.4, “ndb_config — Extract MySQL Cluster Configuration Information”

--query-cache-size

Section 7.6.4, “External Locking”

--quick

Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section 4.6.2.6, “myisamchk Memory Usage”
Section 4.6.2.3, “myisamchk Repair Options”
Section 4.5.1.1, “mysql Options”
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 B.5.2.8, “Out of memory”
Section 6.6.1, “Using myisamchk for Crash Recovery”
Section 4.2.3.3, “Using Option Files”

--quiet

Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 4.6.8, “mysqlhotcopy — A Database Backup Program”

--quote-names

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.3.55, “Changes in Release 3.23.6 (15 December 1999)”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 2.11.4, “Rebuilding or Repairing Tables or Indexes”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

R

[index top]

-R

Section 2.12.4.1, “FreeBSD Notes”
Section 6.6.4, “MyISAM Table Optimization”
Section 4.6.3, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.2.4, “Other myisamchk Options”

-r

Section 18.2.2, “Adding a New User-Defined Function”
Section C.3.40, “Changes in Release 3.23.21 (04 July 2000)”
Section 6.6.3, “How to Repair MyISAM Tables”
Section 2.8, “Installing MySQL from Generic Binaries on Other Unix-Like Systems”
Section 4.6.2.2, “myisamchk Check Options”
Section 4.6.2.3, “myisamchk Repair Options”
Section 4.6.3, “myisamlog — Display MyISAM Log File Contents”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “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.6.7, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 15.4.4, “ndb_config — Extract MySQL Cluster Configuration Information”
Section 5.1.2, “Server Command Options”

--raw

Section 4.5.1.1, “mysql Options”

--read-from-remote-server

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”

--read-only

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.3.47, “Changes in Release 3.23.14 (09 April 2000)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section 4.6.2.2, “myisamchk Check Options”
Section 14.8.3, “Replication Slave Options and Variables”

--reconnect

Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section 4.5.1.1, “mysql Options”

--record_log_pos

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section 4.6.8, “mysqlhotcopy — A Database Backup Program”

--recover

Section 4.6.2.2, “myisamchk Check Options”
Section 4.6.2.1, “myisamchk General Options”
Section 4.6.2.6, “myisamchk Memory Usage”
Section 4.6.2.3, “myisamchk Repair Options”

--regexp

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

--relative

Section C.3.56, “Changes in Release 3.23.5 (20 October 1999)”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

--relay-log

Section 12.5.2.1, “CHANGE MASTER TO Syntax”
Section 14.8.3, “Replication Slave Options and Variables”
Section 14.3.2, “The Slave Relay Log”

--relay-log-index

Section 14.8.3, “Replication Slave Options and Variables”
Section 14.3.2, “The Slave Relay Log”

--relay-log-info-file

Section 14.8.3, “Replication Slave Options and Variables”
Section 14.3.3, “The Slave Status Files”

--relay-log-purge

Section 14.8.3, “Replication Slave Options and Variables”

--relay-log-space-limit

Section 14.8.3, “Replication Slave Options and Variables”

--relnotes

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

--remove

Section 5.1.2, “Server Command Options”
Section 5.7.1.2, “Starting Multiple Windows Servers as Services”
Section 2.3.11, “Starting MySQL as a Windows Service”

--repair

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--replace

Section 4.5.5, “mysqlimport — A Data Import Program”

--replicate-*

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section 14.9, “How Servers Evaluate Replication Filtering Rules”
Section 14.9.3, “Replication Rule Application”
Section 14.8.3, “Replication Slave Options and Variables”

--replicate-*-db

Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section 14.9.3, “Replication Rule Application”

--replicate-*-do-*

Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”

--replicate-*-do-table

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”

--replicate-*-ignore-*

Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”

--replicate-*-ignore-table

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”

--replicate-*-table

Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.3.1, “Changes in Release 3.23.59 (Not released)”
Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section 14.9.3, “Replication Rule Application”

--replicate-do

Section C.1.8, “Changes in MySQL 4.1.18 (2006-01-27)”
Section C.2.26, “Changes in Release 4.0.6 (14 December 2002: Gamma)”

--replicate-do-db

Section 14.8.4, “Binary Log Options and Variables”
Section C.3.45, “Changes in Release 3.23.16 (16 May 2000)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section 14.9.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 14.9, “How Servers Evaluate Replication Filtering Rules”
Section 14.7.15, “Replication and Reserved Words”
Section 14.8.3, “Replication Slave Options and Variables”
Section 12.4.5.21, “SHOW SLAVE STATUS Syntax”
Section 5.3.4, “The Binary Log”

--replicate-do-table

Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section 14.9.2, “Evaluation of Table-Level Replication Options”
Section 14.7.15, “Replication and Reserved Words”
Section 14.8.3, “Replication Slave Options and Variables”
Section 12.4.5.21, “SHOW SLAVE STATUS Syntax”

--replicate-ignore

Section C.1.8, “Changes in MySQL 4.1.18 (2006-01-27)”

--replicate-ignore-db

Section 14.8.4, “Binary Log Options and Variables”
Section C.3.45, “Changes in Release 3.23.16 (16 May 2000)”
Section 14.9.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 14.9, “How Servers Evaluate Replication Filtering Rules”
Section 14.7.15, “Replication and Reserved Words”
Section 14.9.3, “Replication Rule Application”
Section 14.8.3, “Replication Slave Options and Variables”
Section 12.4.5.21, “SHOW SLAVE STATUS Syntax”
Section 5.3.4, “The Binary Log”

--replicate-ignore-table

Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.3.1, “Changes in Release 3.23.59 (Not released)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section 14.9.2, “Evaluation of Table-Level Replication Options”
Section 14.7.15, “Replication and Reserved Words”
Section 14.8.3, “Replication Slave Options and Variables”
Section 12.4.5.21, “SHOW SLAVE STATUS Syntax”

--replicate-rewrite-db

Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.3.35, “Changes in Release 3.23.26 (18 October 2000)”
Section 14.9, “How Servers Evaluate Replication Filtering Rules”
Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”
Section 14.8.3, “Replication Slave Options and Variables”

--replicate-same-server-id

Section 12.5.2.1, “CHANGE MASTER TO Syntax”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section 14.7.21, “Other Replication Features”
Section 14.8.3, “Replication Slave Options and Variables”

--replicate-wild-*

Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”

--replicate-wild-*-table

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”

--replicate-wild-do-table

Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section 14.9.2, “Evaluation of Table-Level Replication Options”
Section 14.9, “How Servers Evaluate Replication Filtering Rules”
Section 14.8.3, “Replication Slave Options and Variables”
Section 12.4.5.21, “SHOW SLAVE STATUS Syntax”

--replicate-wild-ignore-table

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section 14.9.2, “Evaluation of Table-Level Replication Options”
Section 14.7.13, “Replication and User Privileges”
Section 14.10, “Replication FAQ”
Section 14.8.3, “Replication Slave Options and Variables”
Section 12.4.5.21, “SHOW SLAVE STATUS Syntax”

--report-host

Section 14.8.3, “Replication Slave Options and Variables”
Section 12.4.5.20, “SHOW SLAVE HOSTS Syntax”

--report-password

Section 14.8.3, “Replication Slave Options and Variables”

--report-port

Section 14.8.3, “Replication Slave Options and Variables”

--report-user

Section 14.8.3, “Replication Slave Options and Variables”

--resetmaster

Section 4.6.8, “mysqlhotcopy — A Database Backup Program”

--resetslave

Section 4.6.8, “mysqlhotcopy — A Database Backup Program”

--result-file

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

--rhost

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

--rollback

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

--rowid

Section 15.4.15, “ndb_select_all — Print Rows from an NDB Table”

--rows

Section 4.6.13, “mysql_find_rows — Extract SQL Statements from Files”
Section 15.4.4, “ndb_config — Extract MySQL Cluster Configuration Information”

--rpm

Section 4.4.6, “mysql_install_db — Initialize MySQL Data Directory”

S

[index top]

-S

Section 4.2.2, “Connecting to the MySQL Server”
Section 4.2.1, “Invoking MySQL Programs”
Section 6.6.4, “MyISAM Table Optimization”
Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”
Section 4.6.12, “mysql_explain_log — Use EXPLAIN on Statements in Query Log”
Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “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.6.8, “mysqlhotcopy — 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.6.2.4, “Other myisamchk Options”

-s

Section 2.9.5, “Compiling and Linking an Optimized mysqld Server”
Section 6.6.2, “How to Check MyISAM Tables for Errors”
Section 6.6.3, “How to Repair MyISAM Tables”
Section 2.4, “Installing MySQL from RPM Packages on Linux”
Section 2.12.1.2, “Linux Binary Distribution Notes”
Section 4.6.1, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.2.1, “myisamchk General Options”
Section 4.6.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.18, “mysql_zap — Kill Processes That Match a Pattern”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.6.7, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.8.2, “replace — A String-Replacement Utility”
Section 4.7.4, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”

--safe-mode

Section 18.4.1, “Debugging a MySQL Server”
Section 12.4.2.5, “OPTIMIZE TABLE Syntax”
Section 5.1.2, “Server Command Options”

--safe-recover

Section 4.6.2.1, “myisamchk General Options”
Section 4.6.2.6, “myisamchk Memory Usage”
Section 4.6.2.3, “myisamchk Repair Options”

--safe-show-database

Section C.3.31, “Changes in Release 3.23.30 (04 January 2001)”
Section 5.1.2, “Server Command Options”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

--safe-updates

Section C.3.50, “Changes in Release 3.23.11 (16 February 2000)”
Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”
Section 4.5.1.6.2, “Using the --safe-updates Option”

--safe-user-create

Section C.3.19, “Changes in Release 3.23.41 (11 August 2001)”
Section C.3.17, “Changes in Release 3.23.43 (04 October 2001)”
Section 5.4.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”

--safemalloc-mem-limit

Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”

--secure-auth

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 4.5.1.1, “mysql Options”
Section 5.4.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--secure-file-priv

Section C.1.1, “Changes in MySQL 4.1.25 (2008-12-01)”
Section 2.10.2, “Unix Postinstallation Procedures”

--select_limit

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

--server-id

Section 14.8, “Replication and Binary Logging Options and Variables”
Section 5.1.3, “Server System Variables”
Section 12.4.5.20, “SHOW SLAVE HOSTS Syntax”
Section 14.11, “Troubleshooting Replication”

server-id

Section 14.4, “How to Set Up Replication”
Section 14.8, “Replication and Binary Logging Options and Variables”
Section 14.8.2, “Replication Master Options and Variables”
Section 14.8.3, “Replication Slave Options and Variables”

--set-auto-increment

Section 4.6.2.4, “Other myisamchk Options”

--set-character-set

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section 4.6.2.3, “myisamchk Repair Options”

--set-charset

Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”

--set-collation

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section 4.6.2.3, “myisamchk Repair Options”

--set-variable

Section C.3.27, “Changes in Release 3.23.34 (10 March 2001)”
Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section 13.2.4, “InnoDB Startup Options and System Variables”
Section 4.6.2.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 5.1.2, “Server Command Options”
Section 7.8.2, “Tuning Server Parameters”
Section 4.2.3.3, “Using Option Files”
Section 4.2.3.4, “Using Options to Set Program Variables”

--shared-memory

Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section 4.2.2, “Connecting to the MySQL Server”
Section 5.1.2, “Server Command Options”
Section 5.7.1.1, “Starting Multiple Windows Servers at the Command Line”
Section 2.3.9, “Starting the Server for the First Time”
Section 1.3.2, “The Main Features of MySQL”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

--shared-memory-base-name

Section 4.2.2, “Connecting to the MySQL Server”
Section 17.6.6.47, “mysql_options()”
Section 5.7, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.2, “Server Command Options”
Section 5.7.1.1, “Starting Multiple Windows Servers at the Command Line”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”
Section 5.7.3, “Using Client Programs in a Multiple-Server Environment”

--short-form

Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.2.9, “Changes in Release 4.0.23 (18 December 2004)”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”

--show-slave-auth-info

Section 14.8.3, “Replication Slave Options and Variables”

--show-temp-status

Section 15.4.17, “ndb_show_tables — Display List of NDB Tables”

--sigint-ignore

Section C.1.20, “Changes in MySQL 4.1.6 (2004-10-10)”
Section 4.5.1.1, “mysql Options”

--silent

Section 4.4.2, “make_win_src_distribution — Create Source Distribution for Windows”
Section 4.6.2.1, “myisamchk General Options”
Section 4.6.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
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.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”

--single-transaction

Section 13.2.7, “Backing Up and Recovering an InnoDB Database”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section 6.2, “Database Backup Methods”
Section 6.3.1, “Establishing a Backup Policy”
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”

--skip-

Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”

--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 4.5.1.1, “mysql Options”
Section 13.2.14.4, “Troubleshooting InnoDB Data Dictionary Operations”

--skip-bdb

Section 13.5.3, “BDB Startup Options”
Section C.3.27, “Changes in Release 3.23.34 (10 March 2001)”
Section 13.5.1, “Operating Systems Supported by BDB”
Section 14.10, “Replication FAQ”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--skip-character-set-client-handshake

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

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-concurrent-insert

Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section 5.1.2, “Server Command Options”

--skip-delay-key-write

Section C.3.50, “Changes in Release 3.23.11 (16 February 2000)”
Section 5.1.2, “Server Command Options”

--skip-disable-keys

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-engine_name

Section 5.2, “The mysqld-max Extended MySQL Server”

--skip-extended-insert

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-external-locking

Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section 7.6.4, “External Locking”
Section 7.11.2, “General Thread States”
Section 2.7, “Installing MySQL on NetWare”
Section 5.1.2, “Server Command Options”
Section 7.8.1, “System Factors and Startup Parameter Tuning”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

--skip-gemini

Section C.3.27, “Changes in Release 3.23.34 (10 March 2001)”

--skip-grant-tables

Section 5.5.7, “Causes of Access-Denied Errors”
Section 18.2.2.5, “Compiling and Installing User-Defined Functions”
Section 12.4.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 2.10.2.1, “Problems Running mysql_install_db”
Section B.5.4.1.3, “Resetting the Root Password: Generic Instructions”
Section 5.4.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 4.2.3.1, “Using Options on the Command Line”
Section 5.5.6, “When Privilege Changes Take Effect”

--skip-host-cache

Section 5.5.7, “Causes of Access-Denied Errors”
Section 7.8.5, “How MySQL Uses DNS”
Section 5.1.2, “Server Command Options”

--skip-innodb

Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.3.27, “Changes in Release 3.23.34 (10 March 2001)”
Section 13.2.3, “InnoDB Configuration”
Section 13.2.4, “InnoDB Startup Options and System Variables”
Section 14.10, “Replication FAQ”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 5.2, “The mysqld-max Extended MySQL Server”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

--skip-isam

Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server 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.6, “mysqlshow — Display Database, Table, and Column Information”

--skip-locking

Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section 7.6.4, “External Locking”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

--skip-merge

Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 13.3, “The MERGE Storage Engine”

--skip-name-resolve

Section 5.5.7, “Causes of Access-Denied Errors”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section 2.12.4.1, “FreeBSD Notes”
Section 7.8.5, “How MySQL Uses DNS”
Section 4.4.6, “mysql_install_db — Initialize MySQL Data Directory”
Section 5.4.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 2.3.12, “Testing The MySQL Installation”

--skip-named-commands

Section 4.5.1.1, “mysql Options”

--skip-ndbcluster

Section 15.3.4.3, “MySQL Cluster System Variables”
Section 15.3.4.2, “mysqld Command Options for MySQL Cluster”

--skip-networking

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 5.5.7, “Causes of Access-Denied Errors”
Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.3.31, “Changes in Release 3.23.30 (04 January 2001)”
Section 7.8.5, “How MySQL Uses DNS”
Section B.5.2.9, “MySQL server has gone away”
Section 5.4.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--skip-new

Section 18.4.1, “Debugging a MySQL Server”
Section 12.4.2.5, “OPTIMIZE TABLE Syntax”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

--skip-opt

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

--skip-pager

Section 4.5.1.1, “mysql Options”

--skip-quick

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-quote-names

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

--skip-reconnect

Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section 17.6.14, “Controlling Automatic Reconnection Behavior”
Section 4.5.1.6.3, “Disabling mysql Auto-Reconnect”
Section 4.5.1.1, “mysql Options”

--skip-safemalloc

Section C.3.23, “Changes in Release 3.23.37 (17 April 2001)”
Section 2.9.5, “Compiling and Linking an Optimized mysqld Server”
Section 18.4.1.1, “Compiling MySQL for Debugging”
Section 5.1.2, “Server Command Options”

--skip-set-charset

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip-show-database

Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”
Section C.3.7, “Changes in Release 3.23.53 (09 October 2002)”
Section 5.5.1, “Privileges Provided by MySQL”
Section 5.4.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 12.4.5.8, “SHOW DATABASES Syntax”
Section 1.10.5, “Supporters of MySQL”

--skip-slave-start

Section 12.5.2.1, “CHANGE MASTER TO Syntax”
Section C.3.35, “Changes in Release 3.23.26 (18 October 2000)”
Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section 14.4, “How to Set Up Replication”
Section 14.8.3, “Replication Slave Options and Variables”
Section 12.5.2.7, “START SLAVE Syntax”
Section 14.11, “Troubleshooting Replication”

--skip-ssl

Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section 5.6.6.3, “SSL Command Options”

--skip-stack-trace

Section C.3.22, “Changes in Release 3.23.38 (09 May 2001)”
Section 18.4.1.3, “Debugging mysqld under gdb”
Section 5.1.2, “Server Command Options”

--skip-symbolic-links

Section 12.1.5, “CREATE TABLE Syntax”
Section 5.4.3, “Making MySQL Secure Against Attackers”
Section 5.1.2, “Server Command Options”
Section 7.10.3, “Using Symbolic Links for Databases on Windows”
Section 7.10.2, “Using Symbolic Links for Tables on Unix”

--skip-symlink

Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section 5.1.2, “Server Command Options”

--skip-sync-bdb-logs

Section 13.5.3, “BDB Startup Options”

--skip-tee

Section 4.5.1.1, “mysql Options”

--skip-thread-priority

Section 2.12.4.5, “BSD/OS Version 3.x Notes”
Section 2.12.2.1, “Mac OS X 10.x (Darwin)”
Section 5.1.2, “Server Command Options”

--skip-use-db

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

--skip-xxx

Section 4.5.4, “mysqldump — A Database Backup Program”

--skip_grant_tables

Section 4.2.3.1, “Using Options on the Command Line”

--slave-load-tmpdir

Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section 6.2, “Database Backup Methods”
Section 14.8.3, “Replication Slave Options and Variables”

--slave-net-timeout

Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section 14.8.3, “Replication Slave Options and Variables”

--slave-skip-errors

Section 14.8.3, “Replication Slave Options and Variables”
Section 14.7.16, “Slave Errors During Replication”

--slave_compressed_protocol

Section 14.8.3, “Replication Slave Options and Variables”

--sleep

Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

--socket

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 5.5.7, “Causes of Access-Denied Errors”
Section 4.2.2, “Connecting to the MySQL Server”
Section B.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.5.1.1, “mysql Options”
Section 2.9.3, “MySQL Source-Configuration Options”
Section 4.7.2, “mysql_config — Display Options for Compiling Clients”
Section 4.6.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.12, “mysql_explain_log — Use EXPLAIN on Statements in Query Log”
Section 4.6.15, “mysql_setpermission — Interactively Set Permissions in Grant Tables”
Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.8, “mysqlhotcopy — 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.7, “Running Multiple MySQL Servers on the Same Machine”
Section 5.7.2, “Running Multiple Servers on Unix”
Section 5.1.2, “Server Command Options”
Section 2.3.12, “Testing The MySQL Installation”
Section 5.7.3, “Using Client Programs in a Multiple-Server Environment”

--sort-index

Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section 6.6.4, “MyISAM Table Optimization”
Section 4.6.2.4, “Other myisamchk Options”

--sort-records

Section 6.6.4, “MyISAM Table Optimization”
Section 4.6.2.4, “Other myisamchk Options”

--sort-recover

Section C.3.28, “Changes in Release 3.23.33 (09 February 2001)”
Section 4.6.2.1, “myisamchk General Options”
Section 4.6.2.6, “myisamchk Memory Usage”
Section 4.6.2.3, “myisamchk Repair Options”

--sort_buffer_size

Section 4.6.2.6, “myisamchk Memory Usage”

--spassword

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

--sporadic-binlog-dump-fail

Section 14.8.4, “Binary Log Options and Variables”

sql-mode

Section 5.1.6, “Server SQL Modes”

--sql-mode

Section 11.10, “Cast Functions and Operators”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.6, “Changes in MySQL 4.1.20 (2006-05-24)”
Section C.3.19, “Changes in Release 3.23.41 (11 August 2001)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Chapter 11, Functions and Operators
Section 1.9.2, “Selecting SQL Modes”
Section 5.1.2, “Server Command Options”
Section 5.1.6, “Server SQL Modes”
Section 10.3.1.2, “TIMESTAMP Properties as of MySQL 4.1”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

--ssl

Section 4.2.2, “Connecting to the MySQL Server”
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 14.8.3, “Replication Slave Options and Variables”
Section 5.4.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.6.6.3, “SSL Command Options”
Section 5.6.6.2, “Using SSL Connections”

--ssl*

Section 4.2.2, “Connecting to the MySQL Server”
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 5.4.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”

--ssl-ca

Section 12.4.1.2, “GRANT Syntax”
Section 14.8.3, “Replication Slave Options and Variables”
Section 5.6.6.3, “SSL Command Options”
Section 5.6.6.2, “Using SSL Connections”

--ssl-capath

Section 14.8.3, “Replication Slave Options and Variables”
Section 5.6.6.3, “SSL Command Options”

--ssl-cert

Section 12.4.1.2, “GRANT Syntax”
Section 14.8.3, “Replication Slave Options and Variables”
Section 5.6.6.3, “SSL Command Options”
Section 5.6.6.2, “Using SSL Connections”

--ssl-cipher

Section 14.8.3, “Replication Slave Options and Variables”
Section 5.6.6.3, “SSL Command Options”

--ssl-key

Section 12.4.1.2, “GRANT Syntax”
Section 14.8.3, “Replication Slave Options and Variables”
Section 5.6.6.3, “SSL Command Options”
Section 5.6.6.2, “Using SSL Connections”

--ssl-xxx

Section 12.5.2.1, “CHANGE MASTER TO Syntax”

--standalone

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

--start-datetime

Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 6.5.1, “Point-in-Time Recovery Using Event Times”

--start-position

Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 6.5.2, “Point-in-Time Recovery Using Event Positions”

--start_row

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

--static

Section 2.12.3, “Solaris Notes”

--stats

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

--status

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

--stop-datetime

Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 6.5.1, “Point-in-Time Recovery Using Event Times”

--stop-position

Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 6.5.2, “Point-in-Time Recovery Using Event Positions”

--suffix

Section 4.4.2, “make_win_src_distribution — Create Source Distribution for Windows”
Section 4.6.8, “mysqlhotcopy — A Database Backup Program”

--superuser

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

--symbolic-links

Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section 5.1.2, “Server Command Options”
Section 7.10.3, “Using Symbolic Links for Databases on Windows”

--symbols-file

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

--sync-bdb-logs

Section 13.5.3, “BDB Startup Options”

--sysconfdir

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”

T

[index top]

-T

Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section 4.6.2.2, “myisamchk Check Options”
Section 4.6.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 5.1.2, “Server Command Options”

-t

Section 4.6.2.3, “myisamchk Repair Options”
Section 4.6.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.18, “mysql_zap — Kill Processes That Match a Pattern”
Section 4.6.5, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.7, “mysqldumpslow — Summarize Slow Query Log Files”
Section 15.4.6, “ndb_delete_all — Delete All Rows from an NDB Table”
Section 15.4.15, “ndb_select_all — Print Rows from an NDB Table”
Section 15.4.17, “ndb_show_tables — Display List of NDB Tables”
Section 15.4.19, “ndb_waiter — Wait for MySQL Cluster to Reach a Given Status”
Section 5.1.2, “Server Command Options”

--tab

Section 6.1, “Backup and Recovery Types”
Section 6.2, “Database Backup Methods”
Section 6.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 6.4, “Using mysqldump for Backups”

--table

Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section 4.5.1.1, “mysql Options”
Section 4.6.5, “mysqlaccess — Client for Checking Access Privileges”

--table-cache

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”

--table_cache

Section 7.7.2, “How MySQL Opens and Closes Tables”

--tables

Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”

--tar

Section 4.4.2, “make_win_src_distribution — Create Source Distribution for Windows”

--tbl-status

Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”

--tcp-ip

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

--tee

Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”

--temp-pool

Section C.3.28, “Changes in Release 3.23.33 (09 February 2001)”
Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section 5.1.2, “Server Command Options”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

--test

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

Text

Section 1.2, “Typographical and Syntax Conventions”

--thread-safe-clients

Section C.3.50, “Changes in Release 3.23.11 (16 February 2000)”

--thread-stack

Section C.2.22, “Changes in Release 4.0.10 (29 January 2003)”
Section 2.12.1.5, “Linux x86 Notes”

--thread_cache_size

Section 18.4.1.3, “Debugging mysqld under gdb”

--thread_stack

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

--timeout

Section 15.4.19, “ndb_waiter — Wait for MySQL Cluster to Reach a Given Status”

--timezone

Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section 9.7, “MySQL Server Time Zone Support”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 14.7.18, “Replication and Time Zones”
Section 5.1.3, “Server System Variables”
Section B.5.4.6, “Time Zone Problems”

--tmp

Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section 4.4.2, “make_win_src_distribution — Create Source Distribution for Windows”

--tmp_table_size

Section B.5.2.12, “The table is full”

--tmpdir

Section B.5.2.13, “Can't create/write to file”
Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.3.36, “Changes in Release 3.23.25 (29 September 2000)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section 4.6.2.6, “myisamchk Memory Usage”
Section 4.6.2.3, “myisamchk Repair Options”
Section 4.6.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.8, “mysqlhotcopy — A Database Backup Program”
Section 5.7, “Running Multiple MySQL Servers on the Same Machine”
Section 5.1.2, “Server Command Options”
Section B.5.4.4, “Where MySQL Stores Temporary Files”

--to-last-log

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”

--transaction-isolation

Section 5.1.2, “Server Command Options”
Section 12.3.6, “SET TRANSACTION Syntax”
Section 13.2.9, “The InnoDB Transaction Model and Locking”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

--transactional

Section 15.4.6, “ndb_delete_all — Delete All Rows from an NDB Table”

--try-reconnect

Section 15.4.3, “ndb_mgm — The MySQL Cluster Management Client”

--tupscan

Section 15.4.15, “ndb_select_all — Print Rows from an NDB Table”

--type

Section 4.6.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 15.4.4, “ndb_config — Extract MySQL Cluster Configuration Information”
Section 15.4.17, “ndb_show_tables — Display List of NDB Tables”

U

[index top]

-U

Section 4.6.2.2, “myisamchk Check Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.5, “mysqlaccess — Client for Checking Access Privileges”

-u

Section 4.2.2, “Connecting to the MySQL Server”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.6.2.3, “myisamchk Repair Options”
Section 4.6.3, “myisamlog — Display MyISAM Log File Contents”
Section 4.5.1.1, “mysql Options”
Section 4.6.12, “mysql_explain_log — Use EXPLAIN on Statements in Query Log”
Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 4.6.5, “mysqlaccess — Client for Checking Access Privileges”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “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.6.8, “mysqlhotcopy — 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 15.4.17, “ndb_show_tables — Display List of NDB Tables”
Section 5.1.2, “Server Command Options”
Section 2.3.12, “Testing The MySQL Installation”
Section 5.6.1, “User Names and Passwords”
Section 2.10.1, “Windows Postinstallation Procedures”

--unbuffered

Section 4.5.1.1, “mysql Options”

--unpack

Section C.1.6, “Changes in MySQL 4.1.20 (2006-05-24)”
Section C.2.5, “Changes in Release 4.0.27 (06 May 2006)”
Section 13.1.3, “MyISAM Table Storage Formats”
Section 4.6.2.3, “myisamchk Repair Options”
Section 4.6.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”

--unqualified

Section 15.4.17, “ndb_show_tables — Display List of NDB Tables”

--update-state

Section C.3.47, “Changes in Release 3.23.14 (09 April 2000)”
Section 6.6.3, “How to Repair MyISAM Tables”
Section 4.6.2.2, “myisamchk Check Options”
Section 13.1, “The MyISAM Storage Engine”

--usage

Section 15.4.4, “ndb_config — Extract MySQL Cluster Configuration Information”
Section 15.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”

--use-frm

Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

--use-symbolic-links

Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”

--useHexFormat

Section 15.4.15, “ndb_select_all — Print Rows from an NDB Table”

--user

Section B.5.2.18, “'File' Not Found and Similar Errors”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.3.46, “Changes in Release 3.23.15 (08 May 2000)”
Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 4.2.2, “Connecting to the MySQL Server”
Section 6.3, “Example Backup and Recovery Strategy”
Section 5.4.6, “How to Run MySQL as a Normal User”
Section 2.9.1, “Installing MySQL from a Standard Source Distribution”
Section 4.2.1, “Invoking MySQL Programs”
Section 2.12.1.2, “Linux Binary Distribution Notes”
Section 5.4.3, “Making MySQL Secure Against Attackers”
Section 15.5.9.3, “MySQL Cluster and MySQL Security Procedures”
Section 4.5.1.1, “mysql Options”
Section 4.6.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.12, “mysql_explain_log — Use EXPLAIN on Statements in Query Log”
Section 4.4.6, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.6.15, “mysql_setpermission — Interactively Set Permissions in Grant Tables”
Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 4.6.5, “mysqlaccess — Client for Checking Access Privileges”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.8, “mysqlhotcopy — 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.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
Section B.5.4.1.2, “Resetting the Root Password: Unix Systems”
Section 5.1.2, “Server Command Options”
Section 2.12.3, “Solaris Notes”
Section 2.10.2, “Unix Postinstallation Procedures”
Section 5.6.1, “User Names and Passwords”
Section 4.2.3.3, “Using Option Files”

V

[index top]

-V

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 4.6.2.1, “myisamchk General Options”
Section 4.6.3, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.17, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “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.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 15.4.4, “ndb_config — Extract MySQL Cluster Configuration Information”
Section 15.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.8.2, “replace — A String-Replacement Utility”
Section 4.7.4, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
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 6.6.2, “How to Check MyISAM Tables for Errors”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 4.6.1, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.2.1, “myisamchk General Options”
Section 4.6.3, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.17, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.6.5, “mysqlaccess — Client for Checking Access Privileges”
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.6.7, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.6.2.5, “Obtaining Table Information with myisamchk”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.8.2, “replace — A String-Replacement Utility”
Section 5.1.2, “Server Command Options”
Section 4.2.3.1, “Using Options on the Command Line”

--var_name

Section 13.2.4, “InnoDB Startup Options and System Variables”
Section 4.6.2.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 5.1.2, “Server Command Options”
Section 7.8.2, “Tuning Server Parameters”

--verbose

Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section 4.5.1.5, “Executing SQL Statements from a Text File”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 4.6.1, “myisam_ftdump — Display Full-Text Index information”
Section 4.6.2.1, “myisamchk General Options”
Section 4.6.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.6.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.4.6, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.6.17, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.1, “mysqld — The MySQL Server”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.7, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.6.2.4, “Other myisamchk Options”
Section 4.8.1, “perror — Explain Error Codes”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 2.10.2.3, “Starting and Troubleshooting the MySQL Server”
Section 2.3.10, “Starting MySQL from the Windows Command Line”
Section 7.8.2, “Tuning Server Parameters”
Section 4.2.3.3, “Using Option Files”
Section 4.2.3.1, “Using Options on the Command Line”

--version

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section C.2.25, “Changes in Release 4.0.7 (20 December 2002)”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 4.6.2.1, “myisamchk General Options”
Section 4.6.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.1.1, “mysql Options”
Section 4.7.2, “mysql_config — Display Options for Compiling Clients”
Section 4.6.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.6.17, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.6.5, “mysqlaccess — Client for Checking Access Privileges”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
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 15.4.4, “ndb_config — Extract MySQL Cluster Configuration Information”
Section 15.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”
Section 4.8.1, “perror — Explain Error Codes”
Section 4.7.4, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
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”

--vertical

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

W

[index top]

-W

Section 4.2.2, “Connecting to the MySQL Server”
Section 2.12.5.3, “IBM-AIX notes”
Section 2.12.1.3, “Linux Source Distribution Notes”
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 5.1.2, “Server Command Options”
Section 2.12.3, “Solaris Notes”

-w

Section 4.6.2.1, “myisamchk General Options”
Section 4.6.3, “myisamlog — Display MyISAM Log File Contents”
Section 4.6.4, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
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”

--wait

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

--warnings

Section C.3.20, “Changes in Release 3.23.40 (18 July 2001)”
Section B.5.2.11, “Communication Errors and Aborted Connections”
Section 5.1.2, “Server Command Options”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

warnings

Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

--where

Section 4.5.4, “mysqldump — A Database Backup Program”

--windows

Section 4.4.6, “mysql_install_db — Initialize MySQL Data Directory”

--with-archive-storage-engine

Section 13.7, “The ARCHIVE Storage Engine”

--with-bdb

Section 5.2, “The mysqld-max Extended MySQL Server”

--with-berkeley-db

Section 2.1.2.2, “Choosing a Distribution Format”
Section 13.5.2, “Installing BDB”

--with-big-tables

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section 2.9.3, “MySQL Source-Configuration Options”
Section 5.1.3, “Server System Variables”

--with-blackhole-storage-engine

Section 13.9, “The BLACKHOLE Storage Engine”
Section 5.2, “The mysqld-max Extended MySQL Server”

--with-charset

Section 9.4, “Adding a New Character Set”
Section B.5.2.17, “Can't initialize character set”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section 2.9.5, “Compiling and Linking an Optimized mysqld Server”
Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 2.9.3, “MySQL Source-Configuration Options”
Section 9.1.3.1, “Server Character Set and Collation”

--with-collation

Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 2.9.3, “MySQL Source-Configuration Options”
Section 9.1.3.1, “Server Character Set and Collation”

--with-comment

Section 5.1.3, “Server System Variables”

--with-csv-storage-engine

Section 13.8, “The CSV Storage Engine”

--with-debug

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section 2.1.2.2, “Choosing a Distribution Format”
Section 2.9.5, “Compiling and Linking an Optimized mysqld Server”
Section 18.4.1.1, “Compiling MySQL for Debugging”
Section 18.4.2, “Debugging a MySQL Client”
Section 2.9.1, “Installing MySQL from a Standard Source Distribution”
Section 2.9.3, “MySQL Source-Configuration Options”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.1.2, “Server Command Options”
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

--with-embedded-privilege-control

Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section 17.5, “libmysqld, the Embedded MySQL Server Library”

--with-embedded-server

Section 17.5.1, “Compiling Programs with libmysqld”
Section 2.9.3, “MySQL Source-Configuration Options”

--with-example-storage-engine

Section 13.6, “The EXAMPLE Storage Engine”
Section 5.2, “The mysqld-max Extended MySQL Server”

--with-extra-charsets

Section B.5.2.17, “Can't initialize character set”
Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section 2.9.3, “MySQL Source-Configuration Options”

--with-innodb

Section 13.2.2, “InnoDB in MySQL 3.23”
Section 5.2, “The mysqld-max Extended MySQL Server”

--with-libwrap

Section 2.1.2.2, “Choosing a Distribution Format”

--with-low-memory

Section 2.12.4.4, “BSD/OS Version 2.x Notes”
Section 2.9.4, “Dealing with Problems Compiling MySQL”

--with-mit-threads

Section 2.12.4.1, “FreeBSD Notes”
Section 2.9.6, “MIT-pthreads Notes”

--with-mysqld-ldflags

Section 18.2.2, “Adding a New User-Defined Function”
Section 2.12.1.7, “Linux Alpha Notes”

--with-named-thread-libs

Section 2.12.5.6, “Alpha-DEC-OSF/1 Notes”

--with-named-z-libs

Section 2.1.2.2, “Choosing a Distribution Format”
Section 2.12.3.1, “Solaris 2.7/2.8 Notes”
Section 2.12.3, “Solaris Notes”

--with-ndb-ccflags

Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”

--with-ndb-sci

Section 15.3.5.1, “Configuring MySQL Cluster to use SCI Sockets”
Section 15.3.2.10, “SCI Transport Connections in MySQL Cluster”

--with-ndb-shm

Section 15.3.2.1, “MySQL Cluster Configuration: Basic Example”
Section 15.3.2.9, “MySQL Cluster Shared-Memory Connections”

--with-ndbcluster

Section 15.5.4, “MySQL Server Usage for MySQL Cluster”
Section 5.2, “The mysqld-max Extended MySQL Server”

--with-openssl

Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section 5.6.6.2, “Using SSL Connections”

--with-openssl-includes

Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”

--with-openssl-libs

Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”

--with-pstack

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section 5.1.2, “Server Command Options”

--with-raid

Section 2.1.2.2, “Choosing a Distribution Format”
Section 12.1.5, “CREATE TABLE Syntax”
Section 2.9.4, “Dealing with Problems Compiling MySQL”

--with-server-suffix

Section 5.2, “The mysqld-max Extended MySQL Server”

--with-tcp-port

Section 2.9.2, “Installing MySQL from a Development Source Tree”
Section 2.9.3, “MySQL Source-Configuration Options”

with-unix-socket-path

Section 2.9.3, “MySQL Source-Configuration Options”

--with-unix-socket-path

Section B.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
Section 2.9.2, “Installing MySQL from a Development Source Tree”

--with-version-suffix

Section C.3.29, “Changes in Release 3.23.32 (22 January 2001)”

--with-vio

Section 5.6.6.2, “Using SSL Connections”

--with-zlib-dir

Section 2.9.3, “MySQL Source-Configuration Options”

--without-geometry

Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”

--without-innodb

Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

--without-man

Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”

--without-query-cache

Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 7.5.3, “The MySQL Query Cache”

--without-server

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section 2.9.6, “MIT-pthreads Notes”
Section 2.9.3, “MySQL Source-Configuration Options”

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”
Section 2.12.3, “Solaris Notes”

-x

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 15.4.15, “ndb_select_all — Print Rows from an NDB Table”

--xml

Section C.3.12, “Changes in Release 3.23.48 (07 February 2002)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”

Z

[index top]

-z

Section 15.4.15, “ndb_select_all — Print Rows from an NDB Table”