Announcement Module
No announcement yet.

Remote Backup using innobackupex

Page Title Module
Move Remove Collapse
Conversation Detail Module
  • 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

    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?

    Join us at the annual Percona Live MySQL Users Conference -