O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required