3079
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 C.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.3.3, “Using Option Files”
mysqld_safe options
Section 4.3.2, “
mysqld_safe
— MySQL Server
Startup Script”
mysqldump
Section 4.5.1.1, “
mysql
Options”
Section 4.5.4, “
mysqldump
— A Database Backup
Program”
Section 7.4.5, “
mysqldump
Tips”
Section 13.7.2.2, “
BACKUP TABLE
Syntax”
Section 13.1.8, “
CREATE INDEX
Syntax”
Section 13.1.12, “
CREATE VIEW
Syntax”
Section 12.17.2, “
DECIMAL
Data Type Changes”
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 11.1.5.4, “
YEAR(2)
Limitations and Migrating
to
YEAR(4)
”
Section 14.2.4, “Adding, Removing, or Resizing
InnoDB
Data and Log Files”
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 6.2.7, “Causes of Access-Denied Errors”
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 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 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.5.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 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 5.2, “MySQL Server Logs”
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 C.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 E.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 C.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”
Summary of Contents for 5.0
Page 1: ...MySQL 5 0 Reference Manual ...
Page 18: ...xviii ...
Page 60: ...40 ...
Page 396: ...376 ...
Page 578: ...558 ...
Page 636: ...616 ...
Page 844: ...824 ...
Page 1234: ...1214 ...
Page 1427: ...MySQL Proxy Scripting 1407 ...
Page 1734: ...1714 ...
Page 1752: ...1732 ...
Page 1783: ...Configuring Connector ODBC 1763 ...
Page 1793: ...Connector ODBC Examples 1773 ...
Page 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Page 2850: ...2830 ...
Page 2854: ...2834 ...
Page 2928: ...2908 ...
Page 3000: ...2980 ...
Page 3122: ...3102 ...
Page 3126: ...3106 ...
Page 3174: ...3154 ...
Page 3232: ...3212 ...
