Menu:
zlib-decompress:: zlib_decompress -- Decompress mysqlpump ZLIB-Compressed Output
File: manual.info.tmp, Node: lz4-decompress, Next: perror, Prev: programs-miscellaneous, Up: programs-miscellaneous
The note 'lz4_decompress': lz4-decompress. utility decompresses note 'mysqlpump': mysqlpump. output that was created using LZ4 compression. *note 'lz4_decompress': lz4-decompress. was added in MySQL 5.7.10.
Invoke *note 'lz4_decompress': lz4-decompress. like this:
lz4_decompress INPUT_FILE OUTPUT_FILEExample:
mysqlpump --compress-output=LZ4 > dump.lz4
lz4_decompress dump.lz4 dump.txtTo see a help message, invoke *note 'lz4_decompress': lz4-decompress. with no arguments.
To decompress note 'mysqlpump': mysqlpump. ZLIB-compressed output, use note 'zlib_decompress': zlib-decompress. See *note zlib-decompress::.
File: manual.info.tmp, Node: perror, Next: replace-utility, Prev: lz4-decompress, Up: programs-miscellaneous
For most system errors, MySQL displays, in addition to an internal text message, the system error code in one of the following styles:
message ... (errno: #)
message ... (Errcode: #)You can find out what the error code means by examining the documentation for your system or by using the *note 'perror': perror. utility.
*note 'perror': perror. prints a description for a system error code or for a storage engine (table handler) error code.
Invoke *note 'perror': perror. like this:
perror [OPTIONS] ERRORCODE ...Examples:
$> perror 1231
MySQL error code 1231 (ER_WRONG_VALUE_FOR_VAR): Variable '%-.64s' can't
be set to the value of '%-.200s'
$> perror 13 64
OS error code 13: Permission denied
OS error code 64: Machine is not on the networkTo obtain the error message for a MySQL Cluster error code, use the *note 'ndb_perror': mysql-cluster-programs-ndb-perror. utility.
The meaning of system error messages may be dependent on your operating system. A given error code may mean different things on different operating systems.
*note 'perror': perror. supports the following options.
'--help', '--info', '-I', '-?'
Display a help message and exit.
'--ndb'
Print the error message for an NDB Cluster error code.
This option is deprecated in NDB 7.6.4 and later, where note 'perror': perror. prints a warning if it is used, and is removed in NDB Cluster 8.0. Use the note 'ndb_perror': mysql-cluster-programs-ndb-perror. utility instead.
'--silent', '-s'
Silent mode. Print only the error message.
'--verbose', '-v'
Verbose mode. Print error code and message. This is the default behavior.
'--version', '-V'
Display version information and exit.
File: manual.info.tmp, Node: replace-utility, Next: resolveip, Prev: perror, Up: programs-miscellaneous
The *note 'replace': replace-utility. utility program changes strings in place in files or on the standard input.
Note:
The *note 'replace': replace-utility. utility is deprecated as of MySQL 5.7.18 and is removed in MySQL 8.0.
Invoke *note 'replace': replace-utility. in one of the following ways:
replace FROM TO [FROM TO] ... -- FILE_NAME [FILE_NAME] ...
replace FROM TO [FROM TO] ... < FILE_NAMEFROM represents a string to look for and TO represents its replacement. There can be one or more pairs of strings.
Use the '--' option to indicate where the string-replacement list ends and the file names begin. In this case, any file named on the command line is modified in place, so you may want to make a copy of the original before converting it. REPLACE prints a message indicating which of the input files it actually modifies.
If the '--' option is not given, *note 'replace': replace-utility. reads the standard input and writes to the standard output.
*note 'replace': replace-utility. uses a finite state machine to match longer strings first. It can be used to swap strings. For example, the following command swaps 'a' and 'b' in the given files, 'file1' and 'file2':
replace a b b a -- file1 file2 ...*note 'replace': replace-utility. supports the following options.
'-?', '-I'
Display a help message and exit.
'-#DEBUG_OPTIONS'
Enable debugging.
'-s'
Silent mode. Print less information what the program does.
'-v'
Verbose mode. Print more information about what the program does.
'-V'
Display version information and exit.
File: manual.info.tmp, Node: resolveip, Next: zlib-decompress, Prev: replace-utility, Up: programs-miscellaneous
The *note 'resolveip': resolveip. utility resolves host names to IP addresses and vice versa.
Note:
*note 'resolveip': resolveip. is deprecated and is removed in MySQL 8.0. 'nslookup', 'host', or 'dig' can be used instead.
Invoke *note 'resolveip': resolveip. like this:
resolveip [OPTIONS] {HOST_NAME|IP-ADDR} ...*note 'resolveip': resolveip. supports the following options.
'--help', '--info', '-?', '-I'
Display a help message and exit.
'--silent', '-s'
Silent mode. Produce less output.
'--version', '-V'
Display version information and exit.
File: manual.info.tmp, Node: zlib-decompress, Prev: resolveip, Up: programs-miscellaneous
The note 'zlib_decompress': zlib-decompress. utility decompresses note 'mysqlpump': mysqlpump. output that was created using ZLIB compression. *note 'zlib_decompress': zlib-decompress. was added in MySQL 5.7.10.
Invoke *note 'zlib_decompress': zlib-decompress. like this:
zlib_decompress INPUT_FILE OUTPUT_FILEExample:
mysqlpump --compress-output=ZLIB > dump.zlib
zlib_decompress dump.zlib dump.txtTo see a help message, invoke *note 'zlib_decompress': zlib-decompress. with no arguments.
To decompress note 'mysqlpump': mysqlpump. LZ4-compressed output, use note 'lz4_decompress': lz4-decompress. See *note lz4-decompress::.
File: manual.info.tmp, Node: environment-variables, Next: unix-signal-response, Prev: programs-miscellaneous, Up: programs