Command Index

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

Symbols

[index top]

4OS2.EXE

Section 2.20.6, “OS/2 Notes”

A

[index top]

aCC

Section 21.3, “Debugging and Porting MySQL”

Access

Section 13.2.2, “DELETE Syntax”

addgroup

Section 17.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”
Section 2.16, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 2.17.1, “Installing MySQL Using a Standard Source Distribution”

adduser

Section 17.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”
Section 2.16, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 2.17.1, “Installing MySQL Using a Standard Source Distribution”

ALL STATUS

Section 17.5.8, “MySQL Cluster Single User Mode”

APF

Section 17.5.10.1, “MySQL Cluster Security and Networking Issues”

autoconf

Section 2.17.2, “Installing MySQL Using a Development Source Tree”

automake

Section 2.17.2, “Installing MySQL Using a Development Source Tree”

autoreconf

Section 2.17.2, “Installing MySQL Using a Development Source Tree”

autorun.sh

Section 2.17.2, “Installing MySQL Using a Development Source Tree”

B

[index top]

bash

Section 2.20.4.4, “BSD/OS Version 2.x Notes”
Section 2.20.4.5, “BSD/OS Version 3.x Notes”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 2.11, “Installing MySQL on Mac OS X”
Section 4.2.1, “Invoking MySQL Programs”
Section 16.1.2.3, “Replication Slave Options and Variables”
Section 4.2.10, “Setting Environment Variables”
Section 2.10.8.4, “Testing a Windows Source Build”
Section 1.2, “Typographical and Syntax Conventions”

bison

Section 2.17.4, “Dealing with Problems Compiling MySQL”
Section 2.10.8, “Installing MySQL from Source on Windows”
Section 2.17.2, “Installing MySQL Using a Development Source Tree”

bzr

Section 2.17.2, “Installing MySQL Using a Development Source Tree”

C

[index top]

c++

Section 2.17.4, “Dealing with Problems Compiling MySQL”

c++filt

Section 21.3.1.5, “Using a Stack Trace”

cat

Section 4.5.1.1, “mysql Options”

CC

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

cc

Section 2.20.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 2.20.5.2, “HP-UX Version 11.x Notes”
Section 2.22.3, “Problems Using the Perl DBI/DBD Interface”

chkconfig

Section 17.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”
Section 2.18.1.2, “Starting and Stopping MySQL Automatically”

chroot

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

CMake

Section 2.10.8.1, “Building MySQL from the Standard Source Distribution”
Section 21.2.2.5, “Compiling and Installing User-Defined Functions”
Section 2.10.8, “Installing MySQL from Source on Windows”

cmake

Section 2.10.8.1, “Building MySQL from the Standard Source Distribution”
Section 21.2.2.5, “Compiling and Installing User-Defined Functions”

cmd

Section B.5.4.1.1, “Resetting the Root Password: Windows Systems”

CMD.EXE

Section 2.20.6, “OS/2 Notes”

cmd.exe

Section 4.2.1, “Invoking MySQL Programs”
Section 1.2, “Typographical and Syntax Conventions”

command.com

Section 4.2.1, “Invoking MySQL Programs”
Section 1.2, “Typographical and Syntax Conventions”

comp_err

Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.1, “Overview of MySQL Programs”

compile-amd64-max-sci

Section 17.3.5.1, “Configuring MySQL Cluster to use SCI Sockets”

compile-pentium64-max-sci

Section 17.3.5.1, “Configuring MySQL Cluster to use SCI Sockets”

configure

Section 10.3, “Adding a Character Set”
Section 2.20.5.6, “Alpha-DEC-OSF/1 Notes”
Section 2.20.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 2.20.4.4, “BSD/OS Version 2.x Notes”
Section 2.20.4.6, “BSD/OS Version 4.x Notes”
Section 17.2.1.3, “Building MySQL Cluster from Source on Linux”
Section B.5.2.17, “Can't initialize character set”
Section 21.2.2.5, “Compiling and Installing User-Defined Functions”
Section 2.17.5, “Compiling and Linking an Optimized mysqld Server”
Section 21.3.1.1, “Compiling MySQL for Debugging”
Section 6.3.6.2, “Configuring MySQL for SSL”
Section 2.17.4, “Dealing with Problems Compiling MySQL”
Section 21.3, “Debugging and Porting MySQL”
Section 17.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”
Section 2.21, “Environment Variables”
Section B.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
Section 1.7, “How to Report Bugs or Problems”
Section 2.20.5.1, “HP-UX Version 10.20 Notes”
Section 2.20.5.2, “HP-UX Version 11.x Notes”
Section 2.20.5.3, “IBM-AIX notes”
Section 14.5.2, “Installing BDB”
Section 2.17, “Installing MySQL from Source”
Section 2.17.2, “Installing MySQL Using a Development Source Tree”
Section 2.17.1, “Installing MySQL Using a Standard Source Distribution”
Section 20.5, “libmysqld, the Embedded MySQL Server Library”
Section 2.20.1.7, “Linux Alpha Notes”
Section 2.20.1.10, “Linux IA-64 Notes”
Section 2.20.1.3, “Linux Source Distribution Notes”
Section 2.20.1.5, “Linux x86 Notes”
Section 2.20.2.1, “Mac OS X 10.x (Darwin)”
Section 17.5.4, “MySQL Server Usage for MySQL Cluster”
Section 2.17.3, “MySQL Source-Configuration Options”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 2.20.5.9, “SCO OpenServer 6.0.x Notes”
Section 2.20.5.8, “SCO UNIX and OpenServer 5.0.x Notes”
Section 2.20.5.10, “SCO UnixWare 7.1.x and OpenUNIX 8.0.0 Notes”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”
Section 10.1.3.1, “Server Character Set and Collation”
Section 5.1.4, “Server System Variables”
Section 2.20.5.7, “SGI Irix Notes”
Section 2.20.3.1, “Solaris 2.7/2.8 Notes”
Section 2.20.3, “Solaris Notes”
Section 2.20.3.2, “Solaris x86 Notes”
Section 2.20.5.4, “SunOS 4 Notes”
Section 14.8, “The ARCHIVE Storage Engine”
Section 14.10, “The BLACKHOLE Storage Engine”
Section 14.9, “The CSV Storage Engine”
Section 14.6, “The EXAMPLE Storage Engine”
Section 14.7, “The FEDERATED Storage Engine”
Section 14.1, “The MyISAM Storage Engine”
Section 8.6.3, “The MySQL Query Cache”
Section 1.2, “Typographical and Syntax Conventions”
Section 4.2.6, “Using Option Files”
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

configure.js

Section 2.17.3, “MySQL Source-Configuration Options”

configure; make; make install

Section 2.20.1.3, “Linux Source Distribution Notes”

copy

Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”

coreadm

Section 5.1.3, “Server Command Options”
Section 2.20.3, “Solaris Notes”

cp

Section 16.3.1.2, “Backing Up Raw Data from a Slave”
Section 7.1, “Backup and Recovery Types”
Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”

crash-me

Section 8.1.2, “Designing Applications for Portability”
Section 8.1.3, “The MySQL Benchmark Suite”

cron

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 13.7.2.3, “CHECK TABLE Syntax”
Section 14.1.1, “MyISAM Startup Options”
Section 5.2.5, “Server Log Maintenance”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 3.5, “Using mysql in Batch Mode”

csh

Section 2.20.4.4, “BSD/OS Version 2.x Notes”
Section 2.20.4.5, “BSD/OS Version 3.x Notes”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.2.10, “Setting Environment Variables”
Section 1.2, “Typographical and Syntax Conventions”

cxx

Section 2.20.5.5, “Alpha-DEC-UNIX Notes (Tru64)”

D

[index top]

df

Section B.5.1, “How to Determine What Is Causing a Problem”

drwtsn32.exe

Section 21.3.1.3, “Using pdb to create a Windows crashdump”

DSPLIB

Section 2.14, “Installing MySQL on i5/OS”

dump

Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”

dyld

Section 21.2.2.5, “Compiling and Installing User-Defined Functions”

E

[index top]

egcs

Section 2.20.5.5, “Alpha-DEC-UNIX Notes (Tru64)”

EXIT SINGLE USER MODE

Section 17.5.8, “MySQL Cluster Single User Mode”

F

[index top]

FCC

Section 2.20.1.3, “Linux Source Distribution Notes”

fsadm

Section 2.20.5.10, “SCO UnixWare 7.1.x and OpenUNIX 8.0.0 Notes”

G

[index top]

g++

Section 2.17.4, “Dealing with Problems Compiling MySQL”

gcc

Section 2.20.5.6, “Alpha-DEC-OSF/1 Notes”
Section 2.20.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 2.20.4.4, “BSD/OS Version 2.x Notes”
Section 21.2.2.5, “Compiling and Installing User-Defined Functions”
Section 2.17.5, “Compiling and Linking an Optimized mysqld Server”
Section 21.3.1.1, “Compiling MySQL for Debugging”
Section 2.17.4, “Dealing with Problems Compiling MySQL”
Section 21.3, “Debugging and Porting MySQL”
Section 2.20.4.1, “FreeBSD Notes”
Section 2.20.5.1, “HP-UX Version 10.20 Notes”
Section 2.20.5.2, “HP-UX Version 11.x Notes”
Section 2.20.5.3, “IBM-AIX notes”
Section 2.17, “Installing MySQL from Source”
Section 2.20.1.7, “Linux Alpha Notes”
Section 2.20.1.10, “Linux IA-64 Notes”
Section 2.20.1.9, “Linux MIPS Notes”
Section 2.20.1.3, “Linux Source Distribution Notes”
Section 2.20.1.5, “Linux x86 Notes”
Section 2.17.3, “MySQL Source-Configuration Options”
Section 2.22.3, “Problems Using the Perl DBI/DBD Interface”
Section 2.20.5.9, “SCO OpenServer 6.0.x Notes”
Section 2.20.5.8, “SCO UNIX and OpenServer 5.0.x Notes”
Section 2.20.5.10, “SCO UnixWare 7.1.x and OpenUNIX 8.0.0 Notes”
Section 2.20.5.7, “SGI Irix Notes”
Section 2.20.3.1, “Solaris 2.7/2.8 Notes”
Section 2.20.3, “Solaris Notes”
Section 2.20.3.2, “Solaris x86 Notes”

gcc-c++

Section 2.17.4, “Dealing with Problems Compiling MySQL”

gdb

Section 21.3.1.1, “Compiling MySQL for Debugging”
Section 21.3.1.4, “Debugging mysqld under gdb”
Section 2.20.1.7, “Linux Alpha Notes”
Section 2.20.3.2, “Solaris x86 Notes”
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

gmake

Section 2.20.4.1, “FreeBSD Notes”
Section 2.20.5.3, “IBM-AIX notes”
Section 2.17, “Installing MySQL from Source”
Section 2.17.2, “Installing MySQL Using a Development Source Tree”
Section 2.20.5.9, “SCO OpenServer 6.0.x Notes”
Section 2.20.5.10, “SCO UnixWare 7.1.x and OpenUNIX 8.0.0 Notes”

GnuPG

Section 2.6.2, “Signature Checking Using GnuPG”

gnutar

Section 2.17, “Installing MySQL from Source”
Section 2.16, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 2.20.2, “Mac OS X Notes”

gpg

Section 2.6.2, “Signature Checking Using GnuPG”

grep

Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 3.3.4.7, “Pattern Matching”

groupadd

Section 17.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”
Section 2.12, “Installing MySQL on Linux Using RPM Packages”
Section 2.16, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 2.17.1, “Installing MySQL Using a Standard Source Distribution”

gtar

Section 2.20.5.1, “HP-UX Version 10.20 Notes”
Section 2.20.5.2, “HP-UX Version 11.x Notes”
Section 2.17, “Installing MySQL from Source”
Section 2.13, “Installing MySQL on Solaris”
Section 2.16, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 2.20.3, “Solaris Notes”

gunzip

Section 2.16, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 2.17.1, “Installing MySQL Using a Standard Source Distribution”

gzip

Section 1.7, “How to Report Bugs or Problems”

H

[index top]

hdparm

Section 14.2.2, “InnoDB Startup Options and System Variables”

help contents

Section 4.5.1.4, “mysql Server-Side Help”

hostname

Section B.5.2.2, “Can't connect to [local] MySQL server”

I

[index top]

ibbackup

Section 7.1, “Backup and Recovery Types”

icc

Section 2.8, “Compiler-Specific Build Characteristics”
Section 21.3, “Debugging and Porting MySQL”
Section 2.22.3, “Problems Using the Perl DBI/DBD Interface”

idtune

Section 2.20.5.9, “SCO OpenServer 6.0.x Notes”
Section 2.20.5.8, “SCO UNIX and OpenServer 5.0.x Notes”
Section 2.20.5.10, “SCO UnixWare 7.1.x and OpenUNIX 8.0.0 Notes”

idtune name parameter

Section 2.20.5.9, “SCO OpenServer 6.0.x Notes”
Section 2.20.5.8, “SCO UNIX and OpenServer 5.0.x Notes”
Section 2.20.5.10, “SCO UnixWare 7.1.x and OpenUNIX 8.0.0 Notes”

innochecksum

Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.1, “Overview of MySQL Programs”

InnoDB Hot Backup

Section 14.2.1.1, “Using Per-Table Tablespaces”

INSTALL.CMD

Section 2.20.6, “OS/2 Notes”

iptables

Section 17.5.10.1, “MySQL Cluster Security and Networking Issues”

K

[index top]

kill

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 17.4.1, “ndbd — The MySQL Cluster Data Node Daemon”
Section 17.5.5, “Performing a Rolling Restart of a MySQL Cluster”
Section D.5, “Restrictions on XA Transactions”

L

[index top]

ld

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

ld-elf.so.1

Section 21.2.2.5, “Compiling and Installing User-Defined Functions”

ld.so

Section 21.2.2.5, “Compiling and Installing User-Defined Functions”

ldconfig

Section 21.2.2.5, “Compiling and Installing User-Defined Functions”

less

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

libtool

Section 2.20.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 21.2.2.5, “Compiling and Installing User-Defined Functions”
Section 2.17, “Installing MySQL from Source”
Section 2.17.2, “Installing MySQL Using a Development Source Tree”
Section 2.20.5.4, “SunOS 4 Notes”

ln

Section 8.9.6.2, “Using Symbolic Links for MyISAM Tables on Unix”

lsof +L1

Section B.5.4.4, “Where MySQL Stores Temporary Files”

M

[index top]

m4

Section 2.17.2, “Installing MySQL Using a Development Source Tree”

make

Section 2.20.5.6, “Alpha-DEC-OSF/1 Notes”
Section 2.20.4.4, “BSD/OS Version 2.x Notes”
Section 2.20.4.5, “BSD/OS Version 3.x Notes”
Section 2.20.4.6, “BSD/OS Version 4.x Notes”
Section 21.2.2.5, “Compiling and Installing User-Defined Functions”
Section 2.17.4, “Dealing with Problems Compiling MySQL”
Section 2.20.4.1, “FreeBSD Notes”
Section 2.20.5.3, “IBM-AIX notes”
Section 2.17, “Installing MySQL from Source”
Section 2.17.2, “Installing MySQL Using a Development Source Tree”
Section 2.17.3, “MySQL Source-Configuration Options”
Section 2.20.4.2, “NetBSD Notes”
Section 2.22.3, “Problems Using the Perl DBI/DBD Interface”
Section 2.20.5.8, “SCO UNIX and OpenServer 5.0.x Notes”
Section 2.20.3.1, “Solaris 2.7/2.8 Notes”
Section 2.20.5.4, “SunOS 4 Notes”

make && make install

Section 17.2.1.3, “Building MySQL Cluster from Source on Linux”

make distclean

Section 2.17.4, “Dealing with Problems Compiling MySQL”

make install

Section 17.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 2.17.2, “Installing MySQL Using a Development Source Tree”
Section 2.17.1, “Installing MySQL Using a Standard Source Distribution”
Section 2.20.1.5, “Linux x86 Notes”
Section 2.20.5.8, “SCO UNIX and OpenServer 5.0.x Notes”

make perl

Section 2.22.3, “Problems Using the Perl DBI/DBD Interface”

make realclean

Section 2.22.3, “Problems Using the Perl DBI/DBD Interface”

make test

Section 2.17.2, “Installing MySQL Using a Development Source Tree”
Section 2.22.1, “Installing Perl on Unix”
Section 21.1.2, “The MySQL Test Suite”

make_binary_distribution

Section 4.1, “Overview of MySQL Programs”

make_win_bin_dist

Section 4.4.2, “make_win_bin_dist — Package MySQL Distribution as Zip Archive”
Section 2.10.8.3, “Installing MySQL from a Source Build on Windows”
Section 4.1, “Overview of MySQL Programs”

make_win_src_distribution

Section 4.4.3, “make_win_src_distribution — Create Source Distribution for Windows”
Section 2.10.8.5, “Creating a Windows Source Package from the Bazaar Repository”
Section 4.1, “Overview of MySQL Programs”

md5

Section 2.6.1, “Verifying the MD5 Checksum”

md5.exe

Section 2.6.1, “Verifying the MD5 Checksum”

md5sum

Section 2.6.1, “Verifying the MD5 Checksum”

memcached

Section 15.6, “Using MySQL with memcached

mgmd

Section 17.2, “MySQL Cluster Installation and Upgrades”

mkdev aio

Section 2.20.5.8, “SCO UNIX and OpenServer 5.0.x Notes”

mkdev mysql

Section 2.20.5.9, “SCO OpenServer 6.0.x Notes”

mkdir

Section 13.1.6, “CREATE DATABASE Syntax”

more

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

msql2mysql

Section 4.7.1, “msql2mysql — Convert mSQL Programs for Use with MySQL”
Section 4.8.2, “replace — A String-Replacement Utility”
Section 4.1, “Overview of MySQL Programs”

msql2mysqlC-source-file ...

Section 4.7.1, “msql2mysql — Convert mSQL Programs for Use with MySQL”

mv

Section 5.2.5, “Server Log Maintenance”

my_print_defaults

Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 4.7, “MySQL Program Development Utilities”
Section 4.1, “Overview of MySQL Programs”

myisam_ftdump

Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 12.9, “Full-Text Search Functions”
Section 4.1, “Overview of MySQL Programs”

myisamchk

Section 4.6.3, “myisamchk — MyISAM Table-Maintenance Utility”
Section 13.7.2.1, “ANALYZE TABLE Syntax”
Section 10.5, “Character Set Configuration”
Section 13.7.2.3, “CHECK TABLE Syntax”
Section 2.10.2.1.2, “Choosing an Installation Type”
Section 14.1.3.3, “Compressed Table Characteristics”
Section 14.1.4.1, “Corrupted MyISAM Tables”
Section 7.2, “Database Backup Methods”
Section 21.3.1, “Debugging a MySQL Server”
Section 13.2.2, “DELETE Syntax”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 14.1.3.2, “Dynamic Table Characteristics”
Section 8.2.2, “EXPLAIN Output Format”
Section 8.7.4, “External Locking”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 7.6.2, “How to Check MyISAM Tables for Errors”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 1.7, “How to Report Bugs or Problems”
Section 2.15, “Installing MySQL on NetWare”
Section D.7.3, “Limits on Table Size”
Section 13.7.6.4, “LOAD INDEX INTO CACHE Syntax”
Section 21.3.1.7, “Making a Test Case If You Experience Table Corruption”
Section 8.5.4, “MyISAM Index Statistics Collection”
Section 14.1.1, “MyISAM Startup Options”
Section 7.6, “MyISAM Table Maintenance and Crash Recovery”
Section 7.6.4, “MyISAM Table Optimization”
Section 14.1.3, “MyISAM Table Storage Formats”
Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.3.6, “myisamchk Memory Usage”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.6.3.5, “Obtaining Table Information with myisamchk”
Section 4.6.3.4, “Other myisamchk Options”
Section 8.3.3, “Other Optimization Tips”
Section 4.1, “Overview of MySQL Programs”
Section 14.1.4.2, “Problems from Tables Not Being Closed Properly”
Section 13.7.2.6, “REPAIR TABLE Syntax”
Section 5.1.3, “Server Command Options”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 13.7.5.18, “SHOW INDEX Syntax”
Section 13.7.5.33, “SHOW TABLE STATUS Syntax”
Section 8.3.2.1, “Speed of INSERT Statements”
Section 8.3.2.4, “Speed of REPAIR TABLE Statements”
Section 8.3.1.1, “Speed of SELECT Statements”
Section 14.1.3.1, “Static (Fixed-Length) Table Characteristics”
Section 8.9.1, “System Factors and Startup Parameter Tuning”
Section 14.1, “The MyISAM Storage Engine”
Section 7.6.1, “Using myisamchk for Crash Recovery”
Section 21.3.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 8.9.6.2, “Using Symbolic Links for MyISAM Tables on Unix”
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

myisamchk *.MYI

Section 7.6.3, “How to Repair MyISAM Tables”

myisamchk tbl_name

Section 7.6.2, “How to Check MyISAM Tables for Errors”

myisamlog

Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 4.1, “Overview of MySQL Programs”

myisampack

Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 14.1.3.3, “Compressed Table Characteristics”
Section 13.1.10, “CREATE TABLE Syntax”
Section 8.7.4, “External Locking”
Section D.7.3, “Limits on Table Size”
Section 14.3.1, “MERGE Table Advantages and Disadvantages”
Section 14.1.3, “MyISAM Table Storage Formats”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.6.3.5, “Obtaining Table Information with myisamchk”
Section 4.1, “Overview of MySQL Programs”
Section 13.1.10.3, “Silent Column Specification Changes”
Section 8.3.2.1, “Speed of INSERT Statements”
Section 14.3, “The MERGE Storage Engine”
Section 14.1, “The MyISAM Storage Engine”

mysql

Section 1.8.2.5, “'--' as the Start of a Comment”
Section 4.5.1, “mysql — The MySQL Command-Line Tool”
Section 6.3.2, “Adding User Accounts”
Section 2.20.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 14.2.5, “Backing Up and Recovering an InnoDB Database”
Section 7.1, “Backup and Recovery Types”
Section 13.6.1, “BEGIN ... END Compound-Statement Syntax”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 2.10.2.1.5, “Changes Made by MySQL Installation Wizard”
Section 2.10.2.1.2, “Choosing an Installation Type”
Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 9.6, “Comment Syntax”
Section 10.1.5, “Configuring the Character Set and Collation for Applications”
Section 3.1, “Connecting to and Disconnecting from the Server”
Section 4.6.10.6, “Connecting to MySQL Instance Manager”
Section 4.2.2, “Connecting to the MySQL Server”
Section 10.1.4, “Connection Character Sets and Collations”
Section 20.6.15, “Controlling Automatic Reconnection Behavior”
Section 2.19.5, “Copying MySQL Databases to Another Machine”
Section 13.1.9, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 3.3.1, “Creating and Selecting a Database”
Section 14.2.1.3, “Creating the InnoDB Tablespace”
Section 2.10.4.6, “Customizing the PATH for MySQL Tools”
Section 21.3.2, “Debugging a MySQL Client”
Section 18.1, “Defining Stored Programs”
Section 17.4.3, “ndb_mgm — The MySQL Cluster Management Client”
Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.4.2, “make_win_bin_dist — Package MySQL Distribution as Zip Archive”
Section 4.4.5, “mysql_fix_privilege_tables — Upgrade MySQL System Tables”
Section 4.4.8, “mysql_tzinfo_to_sql — Load the Time Zone Tables”
Section 2.2, “Determining Your Current MySQL Version”
Section 4.5.1.6.4, “Disabling mysql Auto-Reconnect”
Section 2.19.2, “Downgrading MySQL”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 3.2, “Entering Queries”
Section 2.21, “Environment Variables”
Section 7.3, “Example Backup and Recovery Strategy”
Section 20.6.3, “Example C API Client Programs”
Section 3.6, “Examples of Common Queries”
Section 4.5.1.5, “Executing SQL Statements from a Text File”
Chapter 12, Functions and Operators
Section 13.7.1.3, “GRANT Syntax”
Section 13.8.3, “HELP Syntax”
Section 14.2.7.9, “How to Cope with Deadlocks”
Section B.5.1, “How to Determine What Is Causing a Problem”
Section 1.7, “How to Report Bugs or Problems”
Section 6.1.5, “How to Run MySQL as a Normal User”
Section B.5.2.15, “Ignoring user”
Section 12.13, “Information Functions”
Section 4.5.1.6.1, “Input-Line Editing”
Section 17.2.1.2, “Installing MySQL Cluster from RPM”
Section 2.11, “Installing MySQL on Mac OS X”
Section 4.2.1, “Invoking MySQL Programs”
Section 17.1.5.8, “Issues Exclusive to MySQL Cluster”
Section B.5.8, “Known Issues in MySQL”
Section 13.4.2.2, “LOAD DATA FROM MASTER Syntax”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.4.2.3, “LOAD TABLE tbl_name FROM MASTER Syntax”
Section 7.4.5.1, “Making a Copy of a Database”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 17.3, “MySQL Cluster Configuration”
Section 17.2.4, “MySQL Cluster Example with Tables and Data”
Section 4.5.1.2, “mysql Commands”
Section 4.5.1.3, “mysql Logging”
Section 4.5.1.1, “mysql Options”
Section 15.7, “MySQL Proxy”
Section 10.6, “MySQL Server Time Zone Support”
Section 17.5.4, “MySQL Server Usage for MySQL Cluster”
Section 4.5.1.4, “mysql Server-Side Help”
Section 2.17.3, “MySQL Source-Configuration Options”
Section 4.5.1.6, “mysql Tips”
Section 20.6.7.14, “mysql_errno()”
Section 20.6.7.66, “mysql_sqlstate()”
Section 8.3.1.15, “Optimizing LIMIT Queries”
Section 8.3.1, “Optimizing SELECT Statements”
Section 4.2.9, “Option Defaults, Options Expecting Values, and the = Sign”
Section B.5.2.8, “Out of memory”
Section 4.1, “Overview of MySQL Programs”
Section B.5.2.10, “Packet Too Large”
Section 6.1.2.4, “Password Hashing in MySQL”
Section 7.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
Section 2.18.1.1, “Problems Running mysql_install_db”
Section 4.2.5, “Program Option Modifiers”
Section 2.19.4, “Rebuilding or Repairing Tables or Indexes”
Section 7.4.4, “Reloading Delimited-Text Format Backups”
Section 7.4.2, “Reloading SQL-Format Backups”
Section B.5.4.1.3, “Resetting the Root Password: Generic Instructions”
Section 13.7.1.5, “REVOKE Syntax”
Section 2.18.2, “Securing the Initial MySQL Accounts”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”
Section 13.2.8.1, “SELECT ... INTO Syntax”
Section 5.1.3, “Server Command Options”
Section B.3, “Server Error Codes and Messages”
Section 5.1.4, “Server System Variables”
Section 5.1.8, “Server-Side Help”
Section 14.2.12.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 13.7.5.31, “SHOW SLAVE STATUS Syntax”
Section 4.2.3, “Specifying Program Options”
Section 13.5, “SQL Syntax for Prepared Statements”
Section 2.18.1.2, “Starting and Stopping MySQL Automatically”
Section 2.10.4.7, “Starting MySQL as a Windows Service”
Section 2.10.3.1, “Starting the MySQL Server Instance Configuration Wizard”
Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
Section 9.1.1, “String Literals”
Section 2.10.8.4, “Testing a Windows Source Build”
Section 11.4.3, “The BLOB and TEXT Types”
Section 18.3.1, “Trigger Syntax and Examples”
Section 14.2.12.4, “Troubleshooting InnoDB Data Dictionary Operations”
Chapter 3, Tutorial
Section 1.2, “Typographical and Syntax Conventions”
Section 2.18.1, “Unix Postinstallation Procedures”
Section 7.3.2, “Using Backups for Recovery”
Section 3.5, “Using mysql in Batch Mode”
Section 7.4, “Using mysqldump for Backups”
Section 4.2.6, “Using Option Files”
Section 4.2.4, “Using Options on the Command Line”
Section 4.2.8, “Using Options to Set Program Variables”
Section 21.3.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 6.3.6.3, “Using SSL Connections”
Section 4.5.1.6.3, “Using the --safe-updates Option”
Section 2.10.7, “Windows Postinstallation Procedures”

mysql ...

Section 21.3.1.1, “Compiling MySQL for Debugging”

mysql mysql < mysql.dump

Section 2.19.2.1, “Downgrading to MySQL 4.1”

mysql stop

Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”

mysql {start|stop}

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

mysql-server

Section 2.20.4.1, “FreeBSD Notes”

mysql-test-run.pl

Section 2.10.8.4, “Testing a Windows Source Build”
Section 21.1.2, “The MySQL Test Suite”

mysql-test-run.pl test_name

Section 21.1.2, “The MySQL Test Suite”

mysql.server

Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 21.2.2.5, “Compiling and Installing User-Defined Functions”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 17.2.1.2, “Installing MySQL Cluster from RPM”
Section 2.20.1.4, “Linux Postinstallation Notes”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 4.1, “Overview of MySQL Programs”
Section 5.1.3, “Server Command Options”
Section 2.18.1.2, “Starting and Stopping MySQL Automatically”
Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
Section B.5.4.6, “Time Zone Problems”

mysql.server stop

Section 2.18.1.2, “Starting and Stopping MySQL Automatically”

mysql_config

Section 4.7.2, “mysql_config — Display Options for Compiling Clients”
Section 20.6.4.1, “Building C API Client Programs”
Section 2.17.4, “Dealing with Problems Compiling MySQL”
Section 4.1, “Overview of MySQL Programs”

mysql_config options

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

mysql_convert_table_format

Section 4.6.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
Section 4.1, “Overview of MySQL Programs”

mysql_explain_log

Section 4.6.12, “mysql_explain_log — Use EXPLAIN on Statements in Query Log”
Section 4.1, “Overview of MySQL Programs”

mysql_find_rows

Section 4.6.13, “mysql_find_rows — Extract SQL Statements from Files”
Section 21.3.1.7, “Making a Test Case If You Experience Table Corruption”
Section 4.1, “Overview of MySQL Programs”

mysql_fix_extensions

Section 4.6.14, “mysql_fix_extensions — Normalize Table File Name Extensions”
Section 4.1, “Overview of MySQL Programs”

mysql_fix_extensions data_dir

Section 4.6.14, “mysql_fix_extensions — Normalize Table File Name Extensions”

mysql_fix_privilege_tables

Section 4.4.5, “mysql_fix_privilege_tables — Upgrade MySQL System Tables”
Section 4.4.9, “mysql_upgrade — Check Tables for MySQL Upgrade”
Section 2.19.2.1, “Downgrading to MySQL 4.1”
Section 4.1, “Overview of MySQL Programs”

mysql_install_db

Section 4.4.6, “mysql_install_db — Initialize MySQL Data Directory”
Section 6.3.2, “Adding User Accounts”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 2.7, “Installation Layouts”
Section 2.11, “Installing MySQL on Mac OS X”
Section 2.15, “Installing MySQL on NetWare”
Section 2.17.1, “Installing MySQL Using a Standard Source Distribution”
Section 14.2.13, “Limits on InnoDB Tables”
Section 2.20.1.2, “Linux Binary Distribution Notes”
Section 4.1, “Overview of MySQL Programs”
Section 2.18.1.1, “Problems Running mysql_install_db”
Section 2.18.2, “Securing the Initial MySQL Accounts”
Section 5.1.3, “Server Command Options”
Section 5.1.8, “Server-Side Help”
Section 5.3.1, “Setting Up Multiple Data Directories”
Section 2.18.1, “Unix Postinstallation Procedures”

mysql_secure_installation

Section 4.4.7, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.1, “Overview of MySQL Programs”
Section 2.18.2, “Securing the Initial MySQL Accounts”

mysql_setpermission

Section 4.6.15, “mysql_setpermission — Interactively Set Permissions in Grant Tables”
Section 2.17.1, “Installing MySQL Using a Standard Source Distribution”
Section 4.1, “Overview of MySQL Programs”
Section 2.18.1, “Unix Postinstallation Procedures”

mysql_setpermissions

Section 4.6.15, “mysql_setpermission — Interactively Set Permissions in Grant Tables”

mysql_stmt_execute()

Section 5.1.6, “Server Status Variables”

mysql_stmt_prepare()

Section 5.1.6, “Server Status Variables”

mysql_tableinfo

Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 4.1, “Overview of MySQL Programs”

mysql_tzinfo_to_sql

Section 4.4.8, “mysql_tzinfo_to_sql — Load the Time Zone Tables”
Section 10.6, “MySQL Server Time Zone Support”
Section 4.1, “Overview of MySQL Programs”

mysql_tzinfo_to_sql arguments

Section 4.4.8, “mysql_tzinfo_to_sql — Load the Time Zone Tables”

mysql_upgrade

Section 4.4.9, “mysql_upgrade — Check Tables for MySQL Upgrade”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 2.19.3, “Checking Whether Tables or Indexes Must Be Rebuilt”
Section 13.7.3.1, “CREATE FUNCTION Syntax for User-defined Functions”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.4.5, “mysql_fix_privilege_tables — Upgrade MySQL System Tables”
Section 2.19.2, “Downgrading MySQL”
Section 4.1, “Overview of MySQL Programs”
Section 6.1.2.4, “Password Hashing in MySQL”
Section 2.19.4, “Rebuilding or Repairing Tables or Indexes”
Section 5.1.3, “Server Command Options”
Section 2.19.1.2, “Upgrading from MySQL 4.1 to 5.0”
Section 2.19.1, “Upgrading MySQL”
Section 2.10.6, “Upgrading MySQL on Windows”

mysql_waitpid

Section 4.6.17, “mysql_waitpid — Kill Process and Wait for Its Termination”
Section 4.1, “Overview of MySQL Programs”

mysql_waitpid()

Section 4.6.17, “mysql_waitpid — Kill Process and Wait for Its Termination”

mysql_zap

Section 4.6.18, “mysql_zap — Kill Processes That Match a Pattern”
Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 4.1, “Overview of MySQL Programs”

mysqlaccess

Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 1.7, “How to Report Bugs or Problems”
Section 4.1, “Overview of MySQL Programs”
Section 2.18.1, “Unix Postinstallation Procedures”

mysqladmin

Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 6.3.5, “Assigning Account Passwords”
Section 16.3.1.1, “Backing Up a Slave Using mysqldump”
Section 2.20.4.6, “BSD/OS Version 4.x Notes”
Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 4.2.2, “Connecting to the MySQL Server”
Section 13.1.6, “CREATE DATABASE Syntax”
Section 2.10.4.6, “Customizing the PATH for MySQL Tools”
Section 21.3.1, “Debugging a MySQL Server”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 13.1.13, “DROP DATABASE Syntax”
Section 20.6.3, “Example C API Client Programs”
Section 13.7.6.2, “FLUSH Syntax”
Section B.5.1, “How to Determine What Is Causing a Problem”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 1.7, “How to Report Bugs or Problems”
Section 2.14, “Installing MySQL on i5/OS”
Section 2.11, “Installing MySQL on Mac OS X”
Section 2.15, “Installing MySQL on NetWare”
Section 5.2, “MySQL Server Logs”
Section 4.1, “Overview of MySQL Programs”
Section 6.2.1, “Privileges Provided by MySQL”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 2.18.2, “Securing the Initial MySQL Accounts”
Section 2.10.4.7, “Starting MySQL as a Windows Service”
Section 2.10.4.5, “Starting MySQL from the Windows Command Line”
Section 5.1.10, “The Shutdown Process”
Section 8.9.2, “Tuning Server Parameters”
Section 2.18.1, “Unix Postinstallation Procedures”
Section 2.10.6, “Upgrading MySQL on Windows”
Section 4.2.6, “Using Option Files”
Section 4.2.4, “Using Options on the Command Line”
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

mysqladmin create

Section 2.20.5.7, “SGI Irix Notes”

mysqladmin debug

Section 21.3.1, “Debugging a MySQL Server”
Section 13.7.1.3, “GRANT Syntax”
Section 6.2.1, “Privileges Provided by MySQL”

mysqladmin extended-status

Section 13.2.5.2, “INSERT DELAYED Syntax”
Section 13.7.5.32, “SHOW STATUS Syntax”

mysqladmin flush-hosts

Section 6.2.7, “Causes of Access-Denied Errors”
Section 8.9.8, “DNS Lookup Optimization and the Host Cache”
Section B.5.2.6, “Host 'host_name' is blocked”
Section 5.1.4, “Server System Variables”

mysqladmin flush-logs

Section 7.3.3, “Backup Strategy Summary”
Section 7.3.1, “Establishing a Backup Policy”
Section 5.2.5, “Server Log Maintenance”
Section 5.2.3, “The Binary Log”
Section 5.2.1, “The Error Log”
Section 16.2.2.1, “The Slave Relay Log”

mysqladmin flush-privileges

Section 6.2.7, “Causes of Access-Denied Errors”
Section 2.19.5, “Copying MySQL Databases to Another Machine”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 2.19.2.1, “Downgrading to MySQL 4.1”
Section 6.2.2, “Privilege System Grant Tables”
Section 2.18.1.1, “Problems Running mysql_install_db”
Section 5.1.3, “Server Command Options”
Section 6.2.6, “When Privilege Changes Take Effect”

mysqladmin flush-tables

Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 8.7.4, “External Locking”
Section 8.8.3, “How MySQL Opens and Closes Tables”
Section 8.9.4, “How MySQL Uses Memory”
Section 8.3.2.1, “Speed of INSERT Statements”
Section 7.6.1, “Using myisamchk for Crash Recovery”

mysqladmin flush-xxx

Section 6.3.2, “Adding User Accounts”

mysqladmin kill

Section 2.20.5.6, “Alpha-DEC-OSF/1 Notes”
Section B.5.4.3, “How MySQL Handles a Full Disk”
Section 2.20.5.3, “IBM-AIX notes”
Section 13.7.6.3, “KILL Syntax”
Section 12.15, “Miscellaneous Functions”
Section B.5.2.9, “MySQL server has gone away”
Section 6.2.1, “Privileges Provided by MySQL”
Section D.7.6, “Windows Platform Limitations”

mysqladmin password

Section 6.3.5, “Assigning Account Passwords”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

mysqladmin processlist

Section 6.3.2, “Adding User Accounts”
Section 8.10, “Examining Thread Information”
Section 13.7.6.3, “KILL Syntax”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 21.1.1, “MySQL Threads”
Section 20.6.7.43, “mysql_list_processes()”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.7.5.27, “SHOW PROCESSLIST Syntax”

mysqladmin processlist status

Section 21.3.1, “Debugging a MySQL Server”

mysqladmin refresh

Section 6.3.2, “Adding User Accounts”
Section 8.8.3, “How MySQL Opens and Closes Tables”
Section B.5.8, “Known Issues in MySQL”
Section 5.2.5, “Server Log Maintenance”

mysqladmin reload

Section 6.3.2, “Adding User Accounts”
Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”
Section 1.7, “How to Report Bugs or Problems”
Section 6.2.2, “Privilege System Grant Tables”
Section 2.18.1.1, “Problems Running mysql_install_db”
Section 5.1.3, “Server Command Options”
Section 6.3.4, “Setting Account Resource Limits”
Section 6.2.6, “When Privilege Changes Take Effect”

mysqladmin reload version

Section 1.7, “How to Report Bugs or Problems”

mysqladmin shutdown

Section 6.2.5, “Access Control, Stage 2: Request Verification”
Section 2.20.5.6, “Alpha-DEC-OSF/1 Notes”
Section 14.2.1.3, “Creating the InnoDB Tablespace”
Section 21.3.1.2, “Creating Trace Files”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 13.7.1.3, “GRANT Syntax”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 6.1.5, “How to Run MySQL as a Normal User”
Section 2.20.5.3, “IBM-AIX notes”
Section 2.11, “Installing MySQL on Mac OS X”
Section 21.3.1.7, “Making a Test Case If You Experience Table Corruption”
Section 6.2.1, “Privileges Provided by MySQL”
Section 16.4.1.15, “Replication and Temporary Tables”
Section 17.2.5, “Safe Shutdown and Restart of MySQL Cluster”
Section 2.18.1.2, “Starting and Stopping MySQL Automatically”
Section 2.10.4.7, “Starting MySQL as a Windows Service”
Section 5.1.10, “The Shutdown Process”
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”
Section D.7.6, “Windows Platform Limitations”

mysqladmin status

Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 8.8.3, “How MySQL Opens and Closes Tables”
Section 20.6.7.68, “mysql_stat()”

mysqladmin variables

Section B.5.2.9, “MySQL server has gone away”
Section 13.7.5.36, “SHOW VARIABLES Syntax”

mysqladmin variables extended-status processlist

Section 1.7, “How to Report Bugs or Problems”

mysqladmin ver

Section 21.3.1.1, “Compiling MySQL for Debugging”

mysqladmin version

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 1.7, “How to Report Bugs or Problems”
Section B.5.2.9, “MySQL server has gone away”
Section 2.18.1, “Unix Postinstallation Procedures”
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

mysqlanalyze

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

mysqlbinlog

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 14.2.5, “Backing Up and Recovering an InnoDB Database”
Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 16.4.5, “How to Report Replication Bugs or Problems”
Section B.5.8, “Known Issues in MySQL”
Section 12.15, “Miscellaneous Functions”
Section 4.1, “Overview of MySQL Programs”
Section 7.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
Section 7.5.2, “Point-in-Time Recovery Using Event Positions”
Section 7.5.1, “Point-in-Time Recovery Using Event Times”
Section 16.4.1.28, “Replication and Variables”
Section 13.7.4, “SET Syntax”
Section 13.7.5.2, “SHOW BINLOG EVENTS Syntax”
Section 13.4.2.7, “START SLAVE Syntax”
Section 5.2.3, “The Binary Log”
Section 16.2.2.1, “The Slave Relay Log”
Section 7.3.2, “Using Backups for Recovery”

mysqlbinlog binary-log-file | mysql

Section 21.3.1.7, “Making a Test Case If You Experience Table Corruption”

mysqlbinlog|mysql

Section B.5.8, “Known Issues in MySQL”

mysqlbug

Section 4.4.4, “mysqlbug — Generate Bug Report”

mysqlcheck

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 2.19.3, “Checking Whether Tables or Indexes Must Be Rebuilt”
Section 4.7.3, “my_print_defaults — Display Options from Option Files”
Section 4.4.9, “mysql_upgrade — Check Tables for MySQL Upgrade”
Section 7.6, “MyISAM Table Maintenance and Crash Recovery”
Section 4.1, “Overview of MySQL Programs”
Section 2.19.4, “Rebuilding or Repairing Tables or Indexes”
Section 5.1.4, “Server System Variables”
Section 14.1, “The MyISAM Storage Engine”

mysqld

Section B.5.2.18, “'File' Not Found and Similar Errors”
Section 4.3.1, “mysqld — The MySQL Server”
Section 21.2.2, “Adding a New User-Defined Function”
Section 21.2, “Adding New Functions to MySQL”
Section 2.20.5.6, “Alpha-DEC-OSF/1 Notes”
Section 2.20.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 14.2.5, “Backing Up and Recovering an InnoDB Database”
Section 14.5.3, “BDB Startup Options”
Section 16.1.2.4, “Binary Log Options and Variables”
Section 2.20.4.5, “BSD/OS Version 3.x Notes”
Section 2.20.4.6, “BSD/OS Version 4.x Notes”
Section 17.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 2.10.8.1, “Building MySQL from the Standard Source Distribution”
Section B.5.2.2, “Can't connect to [local] MySQL server”
Section B.5.2.13, “Can't create/write to file”
Section B.5.2.17, “Can't initialize character set”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 14.2.4, “Changing the Number or Size of InnoDB Log Files and Resizing the InnoDB Tablespace”
Section 14.5.4, “Characteristics of BDB Tables”
Section 2.4.3.2, “Choosing a Distribution Format”
Section B.5.2.4, “Client does not support authentication protocol”
Section 17.5.2, “Commands in the MySQL Cluster Management Client”
Section 9.6, “Comment Syntax”
Section B.5.2.11, “Communication Errors and Aborted Connections”
Section 21.2.2.5, “Compiling and Installing User-Defined Functions”
Section 2.17.5, “Compiling and Linking an Optimized mysqld Server”
Section 21.3.1.1, “Compiling MySQL for Debugging”
Section 14.2.1, “Configuring InnoDB”
Section 6.3.6.2, “Configuring MySQL for SSL”
Section 14.1.4.1, “Corrupted MyISAM Tables”
Section 13.7.3.1, “CREATE FUNCTION Syntax for User-defined Functions”
Section 13.1.12, “CREATE VIEW Syntax”
Section 14.2.1.3, “Creating the InnoDB Tablespace”
Section 21.3.1.2, “Creating Trace Files”
Section 14.2.1.4, “Dealing with InnoDB Initialization Problems”
Section 2.17.4, “Dealing with Problems Compiling MySQL”
Section 21.3.1, “Debugging a MySQL Server”
Section 21.3, “Debugging and Porting MySQL”
Section 21.3.1.4, “Debugging mysqld under gdb”
Section 17.3.2.6, “Defining SQL and Other API Nodes in a MySQL Cluster”
Section 17.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”
Section 17.4.17, “ndb_show_tables — Display List of NDB Tables”
Section 4.6.3, “myisamchk — MyISAM Table-Maintenance Utility”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.7.4, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 4.4.6, “mysql_install_db — Initialize MySQL Data Directory”
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 2.3.1, “Enterprise Server Distribution Types”
Section 2.21, “Environment Variables”
Section 14.5.6, “Errors That May Occur When Using BDB Tables”
Section 8.7.4, “External Locking”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 13.7.6.2, “FLUSH Syntax”
Section 14.2.5.2, “Forcing InnoDB Recovery”
Section 2.20.4.1, “FreeBSD Notes”
Section 8.10.2, “General Thread States”
Section B.5.2.6, “Host 'host_name' is blocked”
Section 8.8.3, “How MySQL Opens and Closes Tables”
Section 8.9.4, “How MySQL Uses Memory”
Section 8.3.1.16, “How to Avoid Table Scans”
Section B.5.1, “How to Determine What Is Causing a Problem”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 1.7, “How to Report Bugs or Problems”
Section 6.1.5, “How to Run MySQL as a Normal User”
Section 2.20.5.3, “IBM-AIX notes”
Section 9.2.2, “Identifier Case Sensitivity”
Section B.5.2.15, “Ignoring user”
Section 12.13, “Information Functions”
Section 17.2.2, “Initial Configuration of MySQL Cluster”
Section 17.2.3, “Initial Startup of MySQL Cluster”
Section 14.2.12.3, “InnoDB General Troubleshooting”
Section 14.2.2, “InnoDB Startup Options and System Variables”
Section 13.2.5.2, “INSERT DELAYED Syntax”
Section 2.7, “Installation Layouts”
Section 17.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”
Section 17.2.1.2, “Installing MySQL Cluster from RPM”
Section 17.2.1, “Installing MySQL Cluster on Linux”
Section 2.14, “Installing MySQL on i5/OS”
Section 2.12, “Installing MySQL on Linux Using RPM Packages”
Section 2.11, “Installing MySQL on Mac OS X”
Section 2.16, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 2.17.1, “Installing MySQL Using a Standard Source Distribution”
Section 17.1.5.8, “Issues Exclusive to MySQL Cluster”
Section 13.7.6.3, “KILL Syntax”
Section B.5.8, “Known Issues in MySQL”
Section 2.20.1.7, “Linux Alpha Notes”
Section 2.20.1.2, “Linux Binary Distribution Notes”
Section 2.20.1.1, “Linux Operating System Notes”
Section 2.20.1.4, “Linux Postinstallation Notes”
Section 2.20.1.3, “Linux Source Distribution Notes”
Section 2.20.1.5, “Linux x86 Notes”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 2.20.2.1, “Mac OS X 10.x (Darwin)”
Section 21.3.1.7, “Making a Test Case If You Experience Table Corruption”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 14.1.1, “MyISAM Startup Options”
Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.1, “myisamchk General Options”
Section 17.5.10.3, “MySQL Cluster and MySQL Security Procedures”
Section 17.3, “MySQL Cluster Configuration”
Section 17.3.2.1, “MySQL Cluster Configuration: Basic Example”
Section 17.1.1, “MySQL Cluster Core Concepts”
Section 17.1.4.1, “MySQL Cluster Developement in MySQL 5.0”
Section 17.2, “MySQL Cluster Installation and Upgrades”
Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 17.4, “MySQL Cluster Programs”
Section 17.3.4.1, “MySQL Cluster Server Option and Variable Reference”
Section 17.3.4.3, “MySQL Cluster System Variables”
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 4.6.10.2, “MySQL Instance Manager Configuration Files”
Chapter 5, MySQL Server Administration
Section 4.3, “MySQL Server and Server-Startup Programs”
Section B.5.2.9, “MySQL server has gone away”
Section 5.2, “MySQL Server Logs”
Section 10.6, “MySQL Server Time Zone Support”
Section 17.5.4, “MySQL Server Usage for MySQL Cluster”
Section 2.17.3, “MySQL Source-Configuration Options”
Section 1.8, “MySQL Standards Compliance”
Section 21.1.1, “MySQL Threads”
Section 20.6.7.1, “mysql_affected_rows()”
Section 20.6.7.49, “mysql_options()”
Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
Section 14.5.1, “Operating Systems Supported by BDB”
Section 13.7.2.5, “OPTIMIZE TABLE Syntax”
Section B.5.6, “Optimizer-Related Issues”
Section 17.3.3, “Overview of MySQL Cluster Configuration Parameters”
Section 4.1, “Overview of MySQL Programs”
Section B.5.2.10, “Packet Too Large”
Section 17.5.5, “Performing a Rolling Restart of a MySQL Cluster”
Section 6.2.2, “Privilege System Grant Tables”
Section 14.1.4.2, “Problems from Tables Not Being Closed Properly”
Section 2.18.1.1, “Problems Running mysql_install_db”
Section B.5.3.1, “Problems with File Permissions”
Section 4.2.5, “Program Option Modifiers”
Section 8.6.3.3, “Query Cache Configuration”
Section 16.1.2.1, “Replication and Binary Logging Option and Variable Reference”
Section 16.1.2, “Replication and Binary Logging Options and Variables”
Section 16.1.2.2, “Replication Master Options and Variables”
Section B.5.4.1.3, “Resetting the Root Password: Generic Instructions”
Section B.5.4.1.2, “Resetting the Root Password: Unix Systems”
Section 14.5.5, “Restrictions on BDB Tables”
Section B.5.5.5, “Rollback Failure for Nontransactional Tables”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 2.20.5.8, “SCO UNIX and OpenServer 5.0.x Notes”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”
Section 6.1.4, “Security-Related mysqld Options and Variables”
Section 13.2.8.1, “SELECT ... INTO Syntax”
Section 2.10.4.3, “Selecting a MySQL Server Type”
Section 10.1.3.1, “Server Character Set and Collation”
Section 5.1.3, “Server Command Options”
Section 5.1.9, “Server Response to Signals”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 13.3.6, “SET TRANSACTION Syntax”
Section 10.2, “Setting the Error Message Language”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 2.20.5.7, “SGI Irix Notes”
Section 14.2.12.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 13.7.5.36, “SHOW VARIABLES Syntax”
Section 20.6.2, “Simultaneous MySQL Server and MySQL Connector/C Installations”
Section 2.20.3, “Solaris Notes”
Section 2.20.3.2, “Solaris x86 Notes”
Section 2.18.1.2, “Starting and Stopping MySQL Automatically”
Section 2.18.1.3, “Starting and Troubleshooting the MySQL Server”
Section 5.3.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 5.3.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 2.10.4.7, “Starting MySQL as a Windows Service”
Section 2.10.4.5, “Starting MySQL from the Windows Command Line”
Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
Section 10.6.1, “Staying Current with Time Zone Changes”
Section 2.20.5.4, “SunOS 4 Notes”
Section 16.3.6, “Switching Masters During Failover”
Section 8.7.2, “Table Locking Issues”
Section B.5.2.19, “Table-Corruption Issues”
Section 2.10.8.4, “Testing a Windows Source Build”
Section 2.10.4.8, “Testing The MySQL Installation”
Section 5.2.3, “The Binary Log”
Section 14.10, “The BLACKHOLE Storage Engine”
Section 21.3.3, “The DBUG Package”
Section 5.2.1, “The Error Log”
Section 5.2.2, “The General Query Log”
Section 14.1, “The MyISAM Storage Engine”
Section 8.6.3, “The MySQL Query Cache”
Section 5.1, “The MySQL Server”
Section 21.1.2, “The MySQL Test Suite”
Section 5.2.4, “The Slow Query Log”
Section B.5.4.6, “Time Zone Problems”
Section B.5.2.7, “Too many connections”
Section 2.10.5, “Troubleshooting a MySQL Installation Under Windows”
Section 8.9.2, “Tuning Server Parameters”
Section 1.2, “Typographical and Syntax Conventions”
Section 2.18.1, “Unix Postinstallation Procedures”
Section 2.19.1.2, “Upgrading from MySQL 4.1 to 5.0”
Section 2.19.1, “Upgrading MySQL”
Section 2.10.6, “Upgrading MySQL on Windows”
Section 21.2.2.6, “User-Defined Function Security Precautions”
Section 21.3.1.5, “Using a Stack Trace”
Section 7.6.1, “Using myisamchk for Crash Recovery”
Section 4.2.6, “Using Option Files”
Section 21.3.1.3, “Using pdb to create a Windows crashdump”
Section 14.2.1.1, “Using Per-Table Tablespaces”
Section 21.3.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 8.9.6.3, “Using Symbolic Links for Databases on Windows”
Section 8.9.6.2, “Using Symbolic Links for MyISAM Tables on Unix”
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”
Section 6.2.6, “When Privilege Changes Take Effect”
Section B.5.4.4, “Where MySQL Stores Temporary Files”

mysqld mysqld.trace

Section 21.3.1.2, “Creating Trace Files”

mysqld-

Section 2.19.1, “Upgrading MySQL”

mysqld-abc.exe

Section 4.4.2, “make_win_bin_dist — Package MySQL Distribution as Zip Archive”

mysqld-debug

Section 2.4.3.2, “Choosing a Distribution Format”
Section 21.3.1.2, “Creating Trace Files”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 2.3.1, “Enterprise Server Distribution Types”
Section 2.10.4.3, “Selecting a MySQL Server Type”
Section 5.1.3, “Server Command Options”
Section 5.3.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”

mysqld-max

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 2.19.1.2, “Upgrading from MySQL 4.1 to 5.0”
Section 2.19.1, “Upgrading MySQL”

mysqld-nt

Section 2.10.4.3, “Selecting a MySQL Server Type”
Section 5.1.3, “Server Command Options”
Section 5.3.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 5.3.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”

mysqld_multi

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.6.10, “mysqlmanager — The MySQL Instance Manager”
Section 4.1, “Overview of MySQL Programs”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”

mysqld_safe

Section B.5.2.18, “'File' Not Found and Similar Errors”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 2.20.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 21.2.2.5, “Compiling and Installing User-Defined Functions”
Section 21.3.1.1, “Compiling MySQL for Debugging”
Section 14.2.1.3, “Creating the InnoDB Tablespace”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 8.9.7, “Enabling Large Page Support”
Section 2.20.4.1, “FreeBSD Notes”
Section B.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
Section 2.20.5.3, “IBM-AIX notes”
Section 14.2.12.3, “InnoDB General Troubleshooting”
Section 17.2.1.2, “Installing MySQL Cluster from RPM”
Section 2.14, “Installing MySQL on i5/OS”
Section 2.11, “Installing MySQL on Mac OS X”
Section 2.15, “Installing MySQL on NetWare”
Section 2.17.1, “Installing MySQL Using a Standard Source Distribution”
Section B.5.8, “Known Issues in MySQL”
Section 2.20.1.4, “Linux Postinstallation Notes”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 17.5.10.3, “MySQL Cluster and MySQL Security Procedures”
Section 10.6, “MySQL Server Time Zone Support”
Section 4.2.9, “Option Defaults, Options Expecting Values, and the = Sign”
Section 4.1, “Overview of MySQL Programs”
Section B.5.2.10, “Packet Too Large”
Section B.5.3.1, “Problems with File Permissions”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 2.20.5.8, “SCO UNIX and OpenServer 5.0.x Notes”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 2.18.1.2, “Starting and Stopping MySQL Automatically”
Section 2.18.1.3, “Starting and Troubleshooting the MySQL Server”
Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
Section 5.2.1, “The Error Log”
Section B.5.4.6, “Time Zone Problems”
Section 8.9.2, “Tuning Server Parameters”
Section 2.18.1, “Unix Postinstallation Procedures”
Section 2.19.1.2, “Upgrading from MySQL 4.1 to 5.0”
Section 2.19.1, “Upgrading MySQL”
Section 4.2.6, “Using Option Files”

mysqld_safe options

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

mysqldump

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 16.3.1.1, “Backing Up a Slave Using mysqldump”
Section 14.2.5, “Backing Up and Recovering an InnoDB Database”
Chapter 7, Backup and Recovery
Section 7.1, “Backup and Recovery Types”
Section 7.3.3, “Backup Strategy Summary”
Section 13.7.2.2, “BACKUP TABLE Syntax”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 14.2.4, “Changing the Number or Size of InnoDB Log Files and Resizing the InnoDB Tablespace”
Section 2.19.3, “Checking Whether Tables or Indexes Must Be Rebuilt”
Section 2.10.2.1.2, “Choosing an Installation Type”
Section 4.2.2, “Connecting to the MySQL Server”
Section 7.4.5.2, “Copy a Database from one Server to Another”
Section 2.19.5, “Copying MySQL Databases to Another Machine”
Section 13.1.8, “CREATE INDEX Syntax”
Section 13.1.12, “CREATE VIEW Syntax”
Section 16.1.1.5, “Creating a Data Snapshot Using mysqldump”
Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 2.10.4.6, “Customizing the PATH for MySQL Tools”
Section 7.2, “Database Backup Methods”
Section 12.17.2, “DECIMAL Data Type Characteristics”
Section 14.2.10.3, “Defragmenting a Table”
Section 17.4.14, “ndb_restore — Restore a MySQL Cluster Backup”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 2.19.2, “Downgrading MySQL”
Section 2.19.2.1, “Downgrading to MySQL 4.1”
Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 7.4.1, “Dumping Data in SQL Format with mysqldump”
Section 7.4.5.3, “Dumping Stored Programs”
Section 7.4.5.4, “Dumping Table Definitions and Content Separately”
Section 14.5.6, “Errors That May Occur When Using BDB Tables”
Section 7.3.1, “Establishing a Backup Policy”
Section 7.3, “Example Backup and Recovery Strategy”
Section 1.8.2.4, “Foreign Keys”
Section 1.7, “How to Report Bugs or Problems”
Section 16.1.1, “How to Set Up Replication”
Section 9.2.2, “Identifier Case Sensitivity”
Section 14.2.12.1, “InnoDB Performance Tuning Tips”
Section 13.4.2.2, “LOAD DATA FROM MASTER Syntax”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.4.2.3, “LOAD TABLE tbl_name FROM MASTER Syntax”
Section 7.4.5.1, “Making a Copy of a Database”
Section 14.2.6, “Moving an InnoDB Database to Another Machine”
Section 17.2.4, “MySQL Cluster Example with Tables and Data”
Section 17.1, “MySQL Cluster Overview”
Section 4.5.1.1, “mysql Options”
Section 5.2, “MySQL Server Logs”
Section 7.4.5, “mysqldump Tips”
Section 11.1.1, “Numeric Type Overview”
Section 16.1.1.4, “Obtaining the Replication Master Binary Log Coordinates”
Section 17.5.3, “Online Backup of MySQL Cluster”
Section 4.1, “Overview of MySQL Programs”
Section 17.5.5, “Performing a Rolling Restart of a MySQL Cluster”
Section B.5.5.8, “Problems with Floating-Point Values”
Section 2.19.4, “Rebuilding or Repairing Tables or Indexes”
Section 7.4.4, “Reloading Delimited-Text Format Backups”
Section 7.4.2, “Reloading SQL-Format Backups”
Section 16.3.4, “Replicating Different Databases to Different Slaves”
Section 14.5.5, “Restrictions on BDB Tables”
Section D.4, “Restrictions on Views”
Section 5.2.5, “Server Log Maintenance”
Section 5.1.7, “Server SQL Modes”
Section 5.1.4, “Server System Variables”
Section 16.1.1.8, “Setting Up Replication with Existing Data”
Section B.5.5.7, “Solving Problems with No Matching Rows”
Section 4.2.3, “Specifying Program Options”
Section 2.10.4.7, “Starting MySQL as a Windows Service”
Section 2.10.3.1, “Starting the MySQL Server Instance Configuration Wizard”
Section 11.4.3, “The BLOB and TEXT Types”
Section 8.6.2, “The InnoDB Buffer Pool”
Section 10.6.2, “Time Zone Leap Second Support”
Section 17.2.6, “Upgrading and Downgrading MySQL Cluster”
Section 2.19.1.2, “Upgrading from MySQL 4.1 to 5.0”
Section 13.1.10.2, “Using FOREIGN KEY Constraints”
Section 7.4, “Using mysqldump for Backups”
Section 16.3.1, “Using Replication for Backups”
Section 16.3.2, “Using Replication with Different Master and Slave Storage Engines”
Section 11.3.4, “YEAR(2) Limitations and Migrating to YEAR(4)”

mysqldump mysql

Section 6.2.7, “Causes of Access-Denied Errors”

mysqldumpslow

Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.1, “Overview of MySQL Programs”
Section 5.2.4, “The Slow Query Log”

mysqlfailover

Section 16.3.6, “Switching Masters During Failover”

mysqlhotcopy

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
Chapter 7, Backup and Recovery
Section 7.1, “Backup and Recovery Types”
Section 13.7.2.2, “BACKUP TABLE Syntax”
Section 7.2, “Database Backup Methods”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 13.4.2.2, “LOAD DATA FROM MASTER Syntax”
Section 13.4.2.3, “LOAD TABLE tbl_name FROM MASTER Syntax”
Section 4.1, “Overview of MySQL Programs”

mysqlhotcopy arguments

Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

mysqlimport

Section 4.5.5, “mysqlimport — A Data Import Program”
Section 7.1, “Backup and Recovery Types”
Section 2.19.5, “Copying MySQL Databases to Another Machine”
Section 7.2, “Database Backup Methods”
Section 2.19.2, “Downgrading MySQL”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 4.1, “Overview of MySQL Programs”
Section 7.4.4, “Reloading Delimited-Text Format Backups”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”
Section 2.19.1.2, “Upgrading from MySQL 4.1 to 5.0”

mysqlmanager

Section 4.6.10, “mysqlmanager — The MySQL Instance Manager”
Section 4.6.10.4, “Instance Manager User and Password Management”
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 4.1, “Overview of MySQL Programs”
Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”

mysqloptimize

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

mysqlrepair

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

mysqlshow

Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.2.2, “Connecting to the MySQL Server”
Section 20.6.3, “Example C API Client Programs”
Section 4.1, “Overview of MySQL Programs”
Section 13.7.5.11, “SHOW DATABASES Syntax”
Section 13.7.5.18, “SHOW INDEX Syntax”
Section 13.7.5.33, “SHOW TABLE STATUS Syntax”
Section 2.10.4.8, “Testing The MySQL Installation”
Section 2.10.7, “Windows Postinstallation Procedures”

mysqlshow db_name

Section 13.7.5.34, “SHOW TABLES Syntax”

mysqlshow db_name tbl_name

Section 13.7.5.5, “SHOW COLUMNS Syntax”

mysqlshow mysql user

Section B.5.2.15, “Ignoring user”

mysqltest

Section 21.1.2, “The MySQL Test Suite”

N

[index top]

ndb_config

Section 17.4.4, “ndb_config — Extract MySQL Cluster Configuration Information”
Section 17.4, “MySQL Cluster Programs”

ndb_config options

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

ndb_cpcd

Section 17.4.5, “ndb_cpcd — Automate Testing for NDB Development”

ndb_cpcd options

Section 17.4.5, “ndb_cpcd — Automate Testing for NDB Development”

ndb_delete_all

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

ndb_delete_all options

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

ndb_desc

Section 17.4.7, “ndb_desc — Describe NDB Tables”
Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
Section 17.5.10.3, “MySQL Cluster and MySQL Security Procedures”
Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”

ndb_desc options

Section 17.4.7, “ndb_desc — Describe NDB Tables”

ndb_drop_index

Section 17.4.8, “ndb_drop_index — Drop Index from an NDB Table”

ndb_drop_index options

Section 17.4.8, “ndb_drop_index — Drop Index from an NDB Table”

ndb_drop_table

Section 17.4.9, “ndb_drop_table — Drop an NDB Table”
Section 17.4.8, “ndb_drop_index — Drop Index from an NDB Table”

ndb_drop_table options

Section 17.4.9, “ndb_drop_table — Drop an NDB Table”

ndb_error_reporter

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

ndb_error_reporter options

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

ndb_mgm

Section 17.4.3, “ndb_mgm — The MySQL Cluster Management Client”
Section 17.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 17.5.2, “Commands in the MySQL Cluster Management Client”
Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
Section 17.4.2, “ndb_mgmd — The MySQL Cluster Management Server Daemon”
Section 17.4.14, “ndb_restore — Restore a MySQL Cluster Backup”
Section 17.5.6, “Event Reports Generated in MySQL Cluster”
Section 17.2.3, “Initial Startup of MySQL Cluster”
Section 17.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”
Section 17.2.1.2, “Installing MySQL Cluster from RPM”
Section 17.2.1, “Installing MySQL Cluster on Linux”
Section 17.1.1, “MySQL Cluster Core Concepts”
Section 17.5.6.1, “MySQL Cluster Logging Management Commands”
Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 17.4, “MySQL Cluster Programs”
Section 17.5.10.1, “MySQL Cluster Security and Networking Issues”
Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
Section 17.5.3, “Online Backup of MySQL Cluster”
Section 17.5.5, “Performing a Rolling Restart of a MySQL Cluster”
Section 17.2.5, “Safe Shutdown and Restart of MySQL Cluster”
Section 4.2.4, “Using Options on the Command Line”
Section 17.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”

ndb_mgm options

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

ndb_mgmd

Section 17.4.2, “ndb_mgmd — The MySQL Cluster Management Server Daemon”
Section 17.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 17.5.2, “Commands in the MySQL Cluster Management Client”
Section 17.3.2.4, “Defining a MySQL Cluster Management Server”
Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
Section 17.2.3, “Initial Startup of MySQL Cluster”
Section 17.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”
Section 17.2.1.2, “Installing MySQL Cluster from RPM”
Section 17.2.1, “Installing MySQL Cluster on Linux”
Section 17.3.2.1, “MySQL Cluster Configuration: Basic Example”
Section 17.3.2.2, “MySQL Cluster Connection Strings”
Section 17.1.1, “MySQL Cluster Core Concepts”
Section 17.5.6.1, “MySQL Cluster Logging Management Commands”
Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 17.4, “MySQL Cluster Programs”
Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
Section 17.3.3, “Overview of MySQL Cluster Configuration Parameters”
Section 17.5.5, “Performing a Rolling Restart of a MySQL Cluster”
Section 17.3.1, “Quick Test Setup of MySQL Cluster”
Section 17.2.5, “Safe Shutdown and Restart of MySQL Cluster”
Section 17.5.1, “Summary of MySQL Cluster Start Phases”

ndb_mgmd options

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

ndb_print_backup_file

Section 17.4.11, “ndb_print_backup_file — Print NDB Backup File Contents”
Section 17.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”
Section 17.4.12, “ndb_print_schema_file — Print NDB Schema File Contents”
Section 17.4.13, “ndb_print_sys_file — Print NDB System File Contents”

ndb_print_backup_file file_name

Section 17.4.11, “ndb_print_backup_file — Print NDB Backup File Contents”

ndb_print_schema_file

Section 17.4.12, “ndb_print_schema_file — Print NDB Schema File Contents”
Section 17.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”
Section 17.4.11, “ndb_print_backup_file — Print NDB Backup File Contents”
Section 17.4.13, “ndb_print_sys_file — Print NDB System File Contents”

ndb_print_schema_file file_name

Section 17.4.12, “ndb_print_schema_file — Print NDB Schema File Contents”

ndb_print_sys_file

Section 17.4.13, “ndb_print_sys_file — Print NDB System File Contents”
Section 17.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”
Section 17.4.11, “ndb_print_backup_file — Print NDB Backup File Contents”
Section 17.4.12, “ndb_print_schema_file — Print NDB Schema File Contents”

ndb_print_sys_file file_name

Section 17.4.13, “ndb_print_sys_file — Print NDB System File Contents”

ndb_restore

Section 17.4.14, “ndb_restore — Restore a MySQL Cluster Backup”
Section 7.1, “Backup and Recovery Types”
Section 17.1.1, “MySQL Cluster Core Concepts”
Section 17.1, “MySQL Cluster Overview”
Section 17.4, “MySQL Cluster Programs”
Section 17.5.8, “MySQL Cluster Single User Mode”
Section 17.5.3, “Online Backup of MySQL Cluster”
Section 17.5.5, “Performing a Rolling Restart of a MySQL Cluster”
Section 17.2.6, “Upgrading and Downgrading MySQL Cluster”

ndb_restore options

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

ndb_schema_backup_file

Section 17.4.12, “ndb_print_schema_file — Print NDB Schema File Contents”

ndb_select_all

Section 17.4.15, “ndb_select_all — Print Rows from an NDB Table”
Section 17.4.17, “ndb_show_tables — Display List of NDB Tables”
Section 17.5.10.3, “MySQL Cluster and MySQL Security Procedures”

ndb_select_count

Section 17.4.16, “ndb_select_count — Print Row Counts for NDB Tables”

ndb_show_tables

Section 17.4.17, “ndb_show_tables — Display List of NDB Tables”
Section 17.5.10.3, “MySQL Cluster and MySQL Security Procedures”
Section 17.4, “MySQL Cluster Programs”
Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”

ndb_size.pl

Section 17.4.18, “ndb_size.pl — NDBCLUSTER Size Requirement Estimator”
Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
Section 2.22, “Perl Installation Notes”

ndb_size.pl arguments

Section 17.4.18, “ndb_size.pl — NDBCLUSTER Size Requirement Estimator”

ndb_waiter

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

ndb_waiter options

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

ndbd

Section 17.4.1, “ndbd — The MySQL Cluster Data Node Daemon”
Section 17.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 17.5.2, “Commands in the MySQL Cluster Management Client”
Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
Section 17.4.14, “ndb_restore — Restore a MySQL Cluster Backup”
Section 17.4.19, “ndb_waiter — Wait for MySQL Cluster to Reach a Given Status”
Section 17.2.3, “Initial Startup of MySQL Cluster”
Section 17.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”
Section 17.2.1.2, “Installing MySQL Cluster from RPM”
Section 17.2.1, “Installing MySQL Cluster on Linux”
Section 17.1.5.9, “Limitations Relating to Multiple MySQL Cluster Nodes”
Section 17.5, “Management of MySQL Cluster”
Section 17.3.2.1, “MySQL Cluster Configuration: Basic Example”
Section 17.1.1, “MySQL Cluster Core Concepts”
Section 17.2, “MySQL Cluster Installation and Upgrades”
Section 17.3.5.2, “MySQL Cluster Interconnects and Performance”
Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 17.4, “MySQL Cluster Programs”
Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
Section 17.3.3, “Overview of MySQL Cluster Configuration Parameters”
Section 17.5.5, “Performing a Rolling Restart of a MySQL Cluster”
Section 17.1.5.10, “Previous MySQL Cluster Issues Resolved in MySQL 5.0”
Section 17.3.1, “Quick Test Setup of MySQL Cluster”
Section 17.2.5, “Safe Shutdown and Restart of MySQL Cluster”
Section 17.3.2.10, “SCI Transport Connections in MySQL Cluster”
Section 17.5.1, “Summary of MySQL Cluster Start Phases”
Section 17.5.6.3, “Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client”
Section 17.3.5, “Using High-Speed Interconnects with MySQL Cluster”

ndbd options

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

NET

Section 2.10.4.7, “Starting MySQL as a Windows Service”

NET START

Section 5.3.2.2, “Starting Multiple MySQL Instances as Windows Services”

NET START MySQL

Section 2.10.4.7, “Starting MySQL as a Windows Service”
Section 2.10.5, “Troubleshooting a MySQL Installation Under Windows”
Section 2.10.6, “Upgrading MySQL on Windows”

NET STOP

Section 5.3.2.2, “Starting Multiple MySQL Instances as Windows Services”

NET STOP MySQL

Section 2.10.4.7, “Starting MySQL as a Windows Service”

nm

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

nohup

Section 2.20.5.5, “Alpha-DEC-UNIX Notes (Tru64)”

O

[index top]

openssl

Section 6.3.6.5, “Setting Up SSL Certificates and Keys for MySQL”

openssl md5 package_name

Section 2.6.1, “Verifying the MD5 Checksum”

P

[index top]

perror

Section B.5.2.18, “'File' Not Found and Similar Errors”
Section 4.8.1, “perror — Explain Error Codes”
Section B.5.2.13, “Can't create/write to file”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 14.2.11.2, “Operating System Error Codes”
Section 4.1, “Overview of MySQL Programs”
Section B.1, “Sources of Error Information”

pfexec

Section 2.16, “Installing MySQL on Unix/Linux Using Generic Binaries”

PGP

Section 2.6.2, “Signature Checking Using GnuPG”

pkgadd

Section 2.20.5.9, “SCO OpenServer 6.0.x Notes”

ppm

Section 2.22, “Perl Installation Notes”

ps

Section 4.6.18, “mysql_zap — Kill Processes That Match a Pattern”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 8.9.4, “How MySQL Uses Memory”
Section B.5.1, “How to Determine What Is Causing a Problem”
Section 2.20.1.4, “Linux Postinstallation Notes”
Section 2.18.1.3, “Starting and Troubleshooting the MySQL Server”

ps auxw

Section 4.2.2, “Connecting to the MySQL Server”

ps xa | grep mysqld

Section B.5.2.2, “Can't connect to [local] MySQL server”

R

[index top]

rename

Section 5.2.5, “Server Log Maintenance”

replace

Section 1.8.2.5, “'--' as the Start of a Comment”
Section 4.8.2, “replace — A String-Replacement Utility”
Section 4.7.1, “msql2mysql — Convert mSQL Programs for Use with MySQL”
Section 4.1, “Overview of MySQL Programs”
Section 16.3.3, “Using Replication for Scale-Out”

replace arguments

Section 4.8.2, “replace — A String-Replacement Utility”

resolve_stack_dump

Section 4.7.4, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 4.1, “Overview of MySQL Programs”
Section 21.3.1.5, “Using a Stack Trace”

resolveip

Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Section 2.20.1.2, “Linux Binary Distribution Notes”
Section 4.1, “Overview of MySQL Programs”

rm

Section 13.4.1.1, “PURGE BINARY LOGS Syntax”

rpm

Section 2.17.1, “Installing MySQL Using a Standard Source Distribution”
Section 2.6.4, “Signature Checking Using RPM”

rpmbuild

Section 2.17.1, “Installing MySQL Using a Standard Source Distribution”

rsync

Section 7.1, “Backup and Recovery Types”
Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”

S

[index top]

safe_mysqld

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 2.11, “Installing MySQL on Mac OS X”

scp

Section 7.1, “Backup and Recovery Types”
Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”

sed

Section 3.3.4.7, “Pattern Matching”

SELECT

Section 17.2.4, “MySQL Cluster Example with Tables and Data”

Service Control Manager

Section 2.10, “Installing MySQL on Microsoft Windows”
Section 2.10.4.7, “Starting MySQL as a Windows Service”

Services

Section 2.10.4.7, “Starting MySQL as a Windows Service”

setenv

Section 4.2.10, “Setting Environment Variables”

sh

Section B.5.2.18, “'File' Not Found and Similar Errors”
Section 2.20.4.4, “BSD/OS Version 2.x Notes”
Section 2.20.4.5, “BSD/OS Version 3.x Notes”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.2.10, “Setting Environment Variables”
Section 1.2, “Typographical and Syntax Conventions”

SHOW

Section 17.4.14, “ndb_restore — Restore a MySQL Cluster Backup”
Section 17.3.1, “Quick Test Setup of MySQL Cluster”

ssh

Section 17.5.10.1, “MySQL Cluster Security and Networking Issues”

Start>Run>cmd.exe

Section 6.3.6.5, “Setting Up SSL Certificates and Keys for MySQL”

strings

Section 6.1.1, “Security Guidelines”

su root

Section 17.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”

sudo

Section 17.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”
Section 2.16, “Installing MySQL on Unix/Linux Using Generic Binaries”

sysctl

Section 2.20.4.1, “FreeBSD Notes”

T

[index top]

tar

Section 16.3.1.2, “Backing Up Raw Data from a Slave”
Section 7.1, “Backup and Recovery Types”
Section 2.4.3.2, “Choosing a Distribution Format”
Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 3.3, “Creating and Using a Database”
Section 1.7, “How to Report Bugs or Problems”
Section 2.20.5.1, “HP-UX Version 10.20 Notes”
Section 2.20.5.2, “HP-UX Version 11.x Notes”
Section 2.7, “Installation Layouts”
Section 2.17, “Installing MySQL from Source”
Section 2.11, “Installing MySQL on Mac OS X”
Section 2.13, “Installing MySQL on Solaris”
Section 2.16, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 2.17.1, “Installing MySQL Using a Standard Source Distribution”
Section 2.22.1, “Installing Perl on Unix”
Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
Section 2.20.2, “Mac OS X Notes”
Section 2.4.3.4, “MySQL Binaries Compiled by Oracle Corporation”
Section 2.20.5.9, “SCO OpenServer 6.0.x Notes”
Section 20.6.2, “Simultaneous MySQL Server and MySQL Connector/C Installations”
Section 2.20.3, “Solaris Notes”

tcpdump

Section 6.1.1, “Security Guidelines”

tcsh

Section B.5.2.18, “'File' Not Found and Similar Errors”
Section 2.11, “Installing MySQL on Mac OS X”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.2.10, “Setting Environment Variables”
Section 1.2, “Typographical and Syntax Conventions”

tee

Section 4.5.1.2, “mysql Commands”

telnet

Section 6.1.1, “Security Guidelines”

Text in this style

Section 1.2, “Typographical and Syntax Conventions”

top

Section B.5.1, “How to Determine What Is Causing a Problem”

U

[index top]

ulimit

Section B.5.2.18, “'File' Not Found and Similar Errors”
Section 2.20.4.4, “BSD/OS Version 2.x Notes”
Section 2.20.4.5, “BSD/OS Version 3.x Notes”
Section 17.3.2.5, “Defining MySQL Cluster Data Nodes”
Section 17.4.20, “Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 8.9.7, “Enabling Large Page Support”
Section 2.20.5.3, “IBM-AIX notes”
Section 2.20.1.4, “Linux Postinstallation Notes”
Section B.5.2.10, “Packet Too Large”
Section 5.1.3, “Server Command Options”

update-rc.d

Section 17.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”

UPGMYSQL

Section 2.14, “Installing MySQL on i5/OS”

useradd

Section 17.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”
Section 2.12, “Installing MySQL on Linux Using RPM Packages”
Section 2.16, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 2.17.1, “Installing MySQL Using a Standard Source Distribution”

usermod

Section 2.12, “Installing MySQL on Linux Using RPM Packages”

V

[index top]

vi

Section 17.2.2, “Initial Configuration of MySQL Cluster”
Section 4.5.1.2, “mysql Commands”
Section 3.3.4.7, “Pattern Matching”

W

[index top]

WinDbg

Section 21.3.1.3, “Using pdb to create a Windows crashdump”

winMd5Sum

Section 2.6.1, “Verifying the MD5 Checksum”

WinZip

Section 16.3.1.2, “Backing Up Raw Data from a Slave”
Section 2.10.8.2, “Building MySQL from a Windows Source Distribution”
Section 2.10.8.1, “Building MySQL from the Standard Source Distribution”
Section 2.17, “Installing MySQL from Source”

WordPad

Section 13.2.6, “LOAD DATA INFILE Syntax”

X

[index top]

xlC_r

Section 21.3, “Debugging and Porting MySQL”

Y

[index top]

yacc

Section 21.2.3, “Adding a New Native Function”
Section 2.17.4, “Dealing with Problems Compiling MySQL”
Section 9.3, “Reserved Words”

Z

[index top]

zip

Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 1.7, “How to Report Bugs or Problems”

zsh

Section 4.2.10, “Setting Environment Variables”