content_image/844675.jpg
• --show , -s 

my_print_defaults  masks passwords by default. Use this option to display passwords as cleartext. 

## 4.8 Miscellaneous Programs 

• --verbose , -v 

Verbose mode. Print more information about what the program does. 

• --version , -V 

Display version information and exit. 

## 4.8.1 lz4_decompress — Decompress mysqlpump LZ4-Compressed Output 

The lz4_decompress  utility decompresses mysqlpump  output that was created using LZ4 compression. 

<img src='content_image/844675.jpg'>

Invoke lz4_decompress  like this: 

lz4_decompress input_file output_file 

Example: 

mysqlpump --compress-output=LZ4 > dump.lz4 lz4_decompress dump.lz4 dump.txt 

To see a help message, invoke lz4_decompress  with no arguments. 

## Note 

If MySQL was configured with the -DWITH_LZ4=system  option, lz4_decompress  is not built. In this case, the system lz4  command can be used instead. 

To decompress mysqlpump  ZLIB-compressed output, use zlib_decompress . See Section 4.8.3, “zlib_decompress — Decompress mysqlpump ZLIB-Compressed Output” . 

## 4.8.2 perror — Display MySQL Error Message Information 

perror  displays the error message for MySQL or operating system error codes. Invoke perror  like this: 

perror [ options ] errorcode  ... 

perror  attempts to be flexible in understanding its arguments. For example, for the ER_WRONG_VALUE_FOR_VAR  error, perror  understands any of these arguments: 1231 , 001231 , MY-1231 , or MY-001231 , or ER_WRONG_VALUE_FOR_VAR . 

shell> perror 1231 MySQL error code MY-001231 (ER_WRONG_VALUE_FOR_VAR): Variable ’%-.64s’ can’t be set to the value of ’%-.200s’ 

If an error number is in the range where MySQL and operating system errors overlap, perror  displays both error messages: 

shell> perror 1 13 OS error code 1: Operation not permitted MySQL error code MY-000001: Can’t create/write to file ’%s’ (OS errno %d - %s) 

