519 mysqlpump — A Database Backup Program those tables are not dumped. To include stored routines and events in a dump made using  --all- databases , use the  --routines  and  --events  options explicitly. On a computer having multiple network interfaces, use this option to select which interface to use for connecting to the MySQL server. The directory where character sets are installed. See Section 10.15, “Character Set Configuration” . Add  ANALYZE TABLE  statements to the output to generate histogram statistics for dumped tables when the dump file is reloaded. This option is disabled by default because histogram generation for large tables can take a long time. Write complete  INSERT  statements that include column names. Compress all information sent between the client and the server if possible. See Section 4.2.8, “Connection Compression Control” . As of MySQL 8.0.18, this option is deprecated. Expect it to be removed in a future version of MySQL. See Configuring Legacy Connection Compression. By default,  mysqlpump  does not compress output. This option specifies output compression using the specified algorithm. Permitted algorithms are  LZ4  and  ZLIB . To uncompress compressed output, you must have an appropriate utility. If the system commands lz4  and  openssl zlib  are not available, MySQL distributions include  lz4_decompress  and zlib_decompress  utilities that can be used to decompress  mysqlpump  output that was compressed using the  --compress-output=LZ4  and  --compress-output=ZLIB  options. For more information, see Section 4.8.1, “lz4_decompress — Decompress mysqlpump LZ4-Compressed Output” , and Section 4.8.3, “zlib_decompress — Decompress mysqlpump ZLIB-Compressed Output” . The permitted compression algorithms for connections to the server. The available algorithms are the same as for the  protocol_compression_algorithms  system variable. The default value is uncompressed . For more information, see Section 4.2.8, “Connection Compression Control” . This option was added in MySQL 8.0.18. • --compression-algorithms= value • --compress-output= algorithm • --compress ,  -C • --complete-insert • --column-statistics • --character-sets-dir= path • --bind-address= ip_address