+1-208-473-2904 (USA - Sales)
0-800-051-8984 (UK - Sales)
0-800-181-0665 (GER - Sales)
Besides using the --stream for sending the backup to another host via piping (see Streaming and Compressing Backups), innobackupex can do it directly with the --remote-host
$ innobackupex --remote-host=REMOTEUSER@REMOTEHOST /path/IN/REMOTE/HOST/to/backup/
innobackupex will test the connection to REMOTEHOST via ssh and create the backup directories needed as the REMOTEUSER you specified. The options for ssh can be specified with --sshopt
The path you provide for storing the backup will be created at REMOTEHOST, not at the local host.
Then all the log files will be written to a temporary file on a local system (you can choose where to store this file with the --tmpdir option) and will be copied via scp. The options for scp can be specified with --options-scp (-Cp -c arcfour by default), for example:
$ innobackupex --remote-host=REMOTEUSER@REMOTEHOST /path/IN/REMOTE/HOST/to/backup/ \ --tmpdir=/tmp --scpopt="-Cp -c arcfour"
SSH public key authentication should be set up to avoid the login prompt when doing the backup to the remote host.