MySQL 8 Cookbook

Compressed backups

You can compress the backup to minimize disk space and network bandwidth. You can use --compress-output=lz4 or --compress-output=zlib.

Note that you should have the appropriate decompress utilities:

shell> mysqlpump -u root -pxxxx --compress-output=lz4 > dump.lz4

To decompress execute this:

shell> lz4_decompress dump.lz4 dump.sql

Using zlib execute this:

shell> mysqlpump -u root -pxxxx --compress-output=zlib > dump.zlib

To decompress execute this:

shell> zlib_decompress dump.zlib dump.sql