Full and Incremental backups to Remote Host

MySQL & MariaDB Percona XtraBackup
1

Hi,

I am currently using innobackupex and the --remote-host to send the backup data to a remote host. But how do I do an incremental backup with the data remote as the incremental backup requires a basedir to start. Is there someway to tell it that the basedir is on a remote host as well?

thanks

2

I saw this in another posting…

"You can read to_lsn from xtrabackup_checkpoints and use its value as an argument to --incremental-lsn as described here: http://www.percona.com/doc/percona-xtrabackup/innobackupex/i ncremental_backups_innobackupex.html

Which is easier than recreating the directory structure and copying the entire file."

However this still results in a full backup to the remote host?

Full
#innobackupex --user=xtrabkp --password=***** --no-timestamp --remote-host=remotehost /MysqlBackup/current/base

Incr - when the lsn is derived from the to_lsn in the xtrabackup_checkpoints file in the base dir.
#innobackupex --user=xtrabkp --password=***** --remote-host=remotehost --incremental --incremental-lsn=226576624494 /MysqlBackup/current/

3

sorry forgot to put the version xtrabackup 1.6.3-292.lenny