MySQL 8.0 Reference Manual
v
4 MySQL Programs ........................................................................................................................ 289
4.1 Overview of MySQL Programs .......................................................................................... 290
4.2 Using MySQL Programs ................................................................................................... 294
4.2.1 Invoking MySQL Programs ..................................................................................... 294
4.2.2 Connecting to the MySQL Server ........................................................................... 295
4.2.3 Connecting Using a Path ........................................................................................ 298
4.2.4 Specifying Program Options ................................................................................... 302
4.2.5 Using Options on the Command Line ..................................................................... 303
4.2.6 Program Option Modifiers ....................................................................................... 305
4.2.7 Using Option Files ................................................................................................. 306
4.2.8 Command-Line Options that Affect Option-File Handling .......................................... 311
4.2.9 Using Options to Set Program Variables ................................................................. 312
4.2.10 Option Defaults, Options Expecting Values, and the = Sign .................................... 313
4.2.11 Setting Environment Variables .............................................................................. 317
4.3 MySQL Server and Server-Startup Programs ..................................................................... 318
4.3.1 mysqld — The MySQL Server ............................................................................... 318
4.3.2 mysqld_safe — MySQL Server Startup Script ...................................................... 318
4.3.3 mysql.server — MySQL Server Startup Script .................................................... 324
4.3.4 mysqld_multi — Manage Multiple MySQL Servers ............................................... 327
4.4 MySQL Installation-Related Programs ................................................................................ 331
4.4.1 comp_err — Compile MySQL Error Message File .................................................. 331
4.4.2 mysql_secure_installation — Improve MySQL Installation Security ................ 332
4.4.3 mysql_ssl_rsa_setup — Create SSL/RSA Files ................................................. 335
4.4.4 mysql_tzinfo_to_sql — Load the Time Zone Tables ......................................... 338
4.4.5 mysql_upgrade — Check and Upgrade MySQL Tables ......................................... 338
4.5 MySQL Client Programs ................................................................................................... 346
4.5.1 mysql — The MySQL Command-Line Tool ............................................................ 346
4.5.2 mysqladmin — Client for Administering a MySQL Server ....................................... 373
4.5.3 mysqlcheck — A Table Maintenance Program ...................................................... 383
4.5.4 mysqldump — A Database Backup Program .......................................................... 391
4.5.5 mysqlimport — A Data Import Program ............................................................... 414
4.5.6 mysqlpump — A Database Backup Program .......................................................... 422
4.5.7 mysqlshow — Display Database, Table, and Column Information ............................ 438
4.5.8 mysqlslap — Load Emulation Client ..................................................................... 444
4.6 MySQL Administrative and Utility Programs ....................................................................... 453
4.6.1 ibd2sdi — InnoDB Tablespace SDI Extraction Utility ............................................. 453
4.6.2 innochecksum — Offline InnoDB File Checksum Utility .......................................... 456
4.6.3 myisam_ftdump — Display Full-Text Index information .......................................... 462
4.6.4 myisamchk — MyISAM Table-Maintenance Utility .................................................. 463
4.6.5 myisamlog — Display MyISAM Log File Contents .................................................. 480
4.6.6 myisampack — Generate Compressed, Read-Only MyISAM Tables ........................ 481
4.6.7 mysql_config_editor — MySQL Configuration Utility ......................................... 488
4.6.8 mysqlbinlog — Utility for Processing Binary Log Files .......................................... 494
4.6.9 mysqldumpslow — Summarize Slow Query Log Files ............................................ 516
4.7 MySQL Program Development Utilities .............................................................................. 518
4.7.1 mysql_config — Display Options for Compiling Clients ........................................ 518
4.7.2 my_print_defaults — Display Options from Option Files .................................... 520
4.7.3 resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols ............. 521
4.8 Miscellaneous Programs ................................................................................................... 521
4.8.1 lz4_decompress — Decompress mysqlpump LZ4-Compressed Output .................. 521
4.8.2 perror — Explain Error Codes ............................................................................. 522
4.8.3 resolveip — Resolve Host name to IP Address or Vice Versa .............................. 523
4.8.4 zlib_decompress — Decompress mysqlpump ZLIB-Compressed Output ............... 523
4.9 MySQL Program Environment Variables ............................................................................ 524
