Announcement

Announcement Module
Collapse
No announcement yet.

Remote Backup using innobackupex

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Remote Backup using innobackupex

    Please pardon me if this is a stupid question - I'm very new to Percona.
    I need to perform a backup of a database from a central server.

    I thought the command to use was:

    innobackupex-1.5.1 --user=root --password=xxxxxx --host=dtcs-clalcpm01-mgt /data/percona_backups

    This seems to connect to the remote database server but it still attempts to backup a local instance of the database.

  • #2
    J_Grieb,

    XtraBackup has to be run from the server where MySQL is running because it will need to copy the files. You can create a wrapper script for the innobackupex command to be called remotely instead.
    Our documentation has a lot of answers about common questions on Percona software, have you checked there before posting that question here? http://www.percona.com/forums/core/i...lies/smile.png

    Join us at the annual Percona Live MySQL Users Conference - http://www.percona.com/live/mysql-conference-2014/

    Comment


    • #3
      Originally posted by revin View Post
      J_Grieb,

      XtraBackup has to be run from the server where MySQL is running because it will need to copy the files. You can create a wrapper script for the innobackupex command to be called remotely instead.
      Since innobackup just run in local machine, why innobackup has option '--host'?

      Comment

      Working...
      X