MySQL 5.6 Reference Manual
v
3.7 Using MySQL with Apache ............................................................................................... 260
4 MySQL Programs ........................................................................................................................ 261
4.1 Overview of MySQL Programs .......................................................................................... 262
4.2 Using MySQL Programs ................................................................................................... 267
4.2.1 Invoking MySQL Programs ..................................................................................... 267
4.2.2 Connecting to the MySQL Server ........................................................................... 267
4.2.3 Specifying Program Options ................................................................................... 271
4.2.4 Using Options on the Command Line ..................................................................... 272
4.2.5 Program Option Modifiers ....................................................................................... 274
4.2.6 Using Option Files ................................................................................................. 274
4.2.7 Command-Line Options that Affect Option-File Handling .......................................... 280
4.2.8 Using Options to Set Program Variables ................................................................. 281
4.2.9 Option Defaults, Options Expecting Values, and the = Sign ...................................... 282
4.2.10 Setting Environment Variables .............................................................................. 286
4.3 MySQL Server and Server-Startup Programs ..................................................................... 287
4.3.1 mysqld — The MySQL Server ............................................................................... 287
4.3.2 mysqld_safe — MySQL Server Startup Script ...................................................... 287
4.3.3 mysql.server — MySQL Server Startup Script .................................................... 292
4.3.4 mysqld_multi — Manage Multiple MySQL Servers ............................................... 295
4.4 MySQL Installation-Related Programs ................................................................................ 299
4.4.1 comp_err — Compile MySQL Error Message File .................................................. 299
4.4.2 mysqlbug — Generate Bug Report ....................................................................... 300
4.4.3 mysql_install_db — Initialize MySQL Data Directory ......................................... 300
4.4.4 mysql_plugin — Configure MySQL Server Plugins .............................................. 304
4.4.5 mysql_secure_installation — Improve MySQL Installation Security ................ 306
4.4.6 mysql_tzinfo_to_sql — Load the Time Zone Tables ......................................... 306
4.4.7 mysql_upgrade — Check and Upgrade MySQL Tables ......................................... 307
4.5 MySQL Client Programs ................................................................................................... 313
4.5.1 mysql — The MySQL Command-Line Tool ............................................................ 313
4.5.2 mysqladmin — Client for Administering a MySQL Server ....................................... 337
4.5.3 mysqlcheck — A Table Maintenance Program ...................................................... 346
4.5.4 mysqldump — A Database Backup Program .......................................................... 354
4.5.5 mysqlimport — A Data Import Program ............................................................... 375
4.5.6 mysqlshow — Display Database, Table, and Column Information ............................ 382
4.5.7 mysqlslap — Load Emulation Client ..................................................................... 387
4.6 MySQL Administrative and Utility Programs ....................................................................... 395
4.6.1 innochecksum — Offline InnoDB File Checksum Utility .......................................... 395
4.6.2 myisam_ftdump — Display Full-Text Index information .......................................... 396
4.6.3 myisamchk — MyISAM Table-Maintenance Utility .................................................. 397
4.6.4 myisamlog — Display MyISAM Log File Contents .................................................. 415
4.6.5 myisampack — Generate Compressed, Read-Only MyISAM Tables ........................ 416
4.6.6 mysql_config_editor — MySQL Configuration Utility ......................................... 422
4.6.7 mysqlaccess — Client for Checking Access Privileges .......................................... 428
4.6.8 mysqlbinlog — Utility for Processing Binary Log Files .......................................... 431
4.6.9 mysqldumpslow — Summarize Slow Query Log Files ............................................ 452
4.6.10 mysqlhotcopy — A Database Backup Program .................................................. 454
4.6.11 mysql_convert_table_format — Convert Tables to Use a Given Storage
Engine ............................................................................................................................ 457
4.6.12 mysql_find_rows — Extract SQL Statements from Files .................................... 458
4.6.13 mysql_fix_extensions — Normalize Table File Name Extensions .................... 459
4.6.14 mysql_setpermission — Interactively Set Permissions in Grant Tables .............. 460
4.6.15 mysql_waitpid — Kill Process and Wait for Its Termination ................................ 460
4.6.16 mysql_zap — Kill Processes That Match a Pattern .............................................. 461
4.7 MySQL Program Development Utilities .............................................................................. 462
评论0