Make a Streaming Backup

Stream mode sends the backup to STDOUT in tar format instead of copying it to the directory named by the first argument. You can pipe the output to gzip, or across the network to another server.

To extract the resulting tar file, you must use the -i option, such as tar -ixvf backup.tar.

Warning

Remember to use the -i option for extracting a tarred backup. For more information, see Streaming and Compressing Backups.

Here are some examples:

## Stream the backup into a tar archived named 'backup.tar'
innobackupex --stream=tar ./ > backup.tar

## The same, but compress it
innobackupex --stream=tar ./ | gzip - > backup.tar.gz

## Send it to another server instead of storing it locally
innobackupex --stream=tar ./ | ssh user@desthost "cat - > /data/backups/backup.tar"

## The same thing with ''netcat'' (faster).  On the destination host:
nc -l 9999 | cat - > /data/backups/backup.tar
## On the source host:
innobackupex --stream=tar ./ | nc desthost 9999

## The same thing, but done as a one-liner:
ssh user@desthost "( nc -l 9999 > /data/backups/backup.tar & )" \
&& innobackupex --stream=tar ./  |  nc desthost 9999

## Throttle the throughput to 10MB/sec.  Requires the 'pv' tools; you
## can find them at http://www.ivarch.com/programs/quickref/pv.shtml
innobackupex --stream=tar ./ | pv -q -L10m \
| ssh user@desthost "cat - > /data/backups/backup.tar"
Percona XtraBackup
Call Us
+1-888-316-9775 (USA - Sales)
+1-208-473-2904 (USA - Sales)
+44-208-133-0309 (UK - Sales)
0-800-051-8984 (UK - Sales)
0-800-181-0665 (GER - Sales)
+1-877-862-4316 (Emergency)
+1-855-55TRAIN (Training)
+1-925-271-5054 (Training)

Previous topic

Make a Local Full Backup (Create, Prepare and Restore)

Next topic

Making an Incremental Backup

This Page



© Copyright 2010-2012, Percona Ireland Ltd.
Except where otherwise noted, this documentation is licensed under the following license:
CC Attribution-ShareAlike 2.0 Generic
Created using Sphinx 1.1.3.
This documentation is developed in Launchpad as part of the Percona XtraBackup source code.
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.
]]>