Compressed backups

You can specify the --compress option to compress the backup:

shell> mydumper -u root --password=<password> -B employees -T employees -t 8 --trx-consistency-only --compress --outputdir /backups/employees_compress
shell> ls -lhtr /backups/employees_compresstotal 5.3M-rw-r--r-- 1 root root 91 Aug 13 11:01 employees-schema-create.sql.gz-rw-r--r-- 1 root root 263 Aug 13 11:01 employees.employees-schema.sql.gz-rw-r--r-- 1 root root 75 Aug 13 11:01 metadata-rw-r--r-- 1 root root 5.3M Aug 13 11:01 employees.employees.sql.gz

Get MySQL 8 Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.