Not the answer you need?
Register and ask your own question!

Full and Incremental backups to Remote Host

bhudzbhudz EntrantCurrent User Role Beginner
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

Comments

  • bhudzbhudz Entrant Current User Role Beginner
    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/
  • bhudzbhudz Entrant Current User Role Beginner
    sorry forgot to put the version xtrabackup 1.6.3-292.lenny
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.