Catalogue
4.1 MySQL Program overview
4.2 Using the MySQL program
- 4.2.1 Calling MySQL Program
- 4.2.2 Connecting to MySQL server
- 4.2.3 Specifying program options
- 4.2.4 using options on the command line
- 4.2.5 Program Options Editor
- 4.2.6 using the Options file
- 4.2.7 command-line options that affect file option handling
- 4.2.8 using options to Set program variables
- 4.2.9 option default value, option expectation and = symbol
- 4.2.10 Setting Environment variables
4.3 MySQL Server and service startup program
- 4.3.1 mysqld--mysql Server
- 4.3.2 Mysqld_safe--mysql Service startup script
- 4.3.3 Mysql.server--mysql Service startup script
- 4.3.4 mysqld_multi--managing multiple MySQL Servers
4.4 MySQL Installation-related programs
- 4.4.1 comp_err--compiling mysql error message file
- 4.4.2 mysqlbug--Generating Error reports
- 4.4.3 mysql_install_db--initializing MySQL Data directory
- 4.4.4 mysql_plugin--Configuring the MySQL service plugin
- 4.4.5 mysql_secure_installation--improve MySQL installation security
- 4.4.6 mysql_tzinfo_to_sql--Import time Zone table
- mysql_upgrade--checking and updating MySQL data sheet
4.5 MySQL client program
- 4.5.1 mysql--mysql command-line tools
- 4.5.2 mysqladmin--managing clients for MySQL Services
- 4.5.3 mysqlcheck--Table Maintenance Program
- 4.5.4 mysqldump--Database Backup program
- 4.5.5 mysqlimport--Data Entry Program
- 4.5.6 mysqlshow--displaying database, table, and field information
- 4.5.7 mysqlslap--Loading Virtual client
4.6 MySQL Universal Program
- 4.6.1 innochecksum--offline InnoDB file Calibration tool
- 4.6.2 myisam_ftdump--Display Full-text index information
- 4.6.3 Myisamchk--myisam Table Maintenance tool
- 4.6.4 myisamlog--Display MyISAM log file contents
- 4.6.5 myisampack--generate compressed, read-only MyISAM table
- 4.6.6 mysql_config_editor--mysql Configuration Tool
- 4.6.7 mysqlaccess--Verify usage rights
- 4.6.8 mysqlbinlog--Tools for executing binary log files
- 4.6.9 mysqldumpslow--Slow query log file overview
- 4.6.10 mysqlhotcopy--Database Backup program
- 4.6.11 mysql_convert_table_format--using a given storage engine to convert tables
- 4.6.12 mysql_find_rows--extracting SQL statements from a file
- 4.6.13 mysql_fix_extensions--to standardize the table file name extensions
- 4.6.14 mysql_setpermission--to set access permissions for a table
- 4.6.15 mysql_waitpid--kills the process and waits for it to terminate
- 4.6.16 mysql_zap--kills the process of matching patterns
4.7 MySQL Program Development tools
- 4.7.1 msql3mysql--using MySQL to convert msql programs
- 4.7.2 mysql_config--Display compilation options
- 4.7.3 my_print_defaults--display options from the configuration file
- 4.7.4 resolve_stack_dump--Solving value stack tracking storage
4.8 Auxiliary Programs
- 4.8.1 perror--Interpreting error codes
- 4.8.2 replace--String Substitution tool
- 4.8.3 resolveip--resolves host name to IP address
This section provides a brief overview of the MySQL command-line program provided by Oracle Corporation. This chapter also discusses the basic syntax for specifying options when you run these programs. Most programs have their own options, but the syntax for all program options is similar. Finally, this chapter provides a number of detailed descriptions of individual programs, including the option they need to use.
Fourth Chapter MySQL Program
