Perform XtraBackup and zip to a file
In the previous article, we have discussed how to perform a hot backup on InnoDB with XtraBackup , but is it possible to zip the result directly to a file?
Sure, you can use the wrapper script came with the XtraBackup - innobackupex
For example, to backup and zip the result files to zipped files, you can use:
# innobackupex --stream=tar ./ | gzip - > backup.tar.gz