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

Remote Backup using innobackupex

J_GriebJ_Grieb EntrantInactive User Role Beginner
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.

Comments

  • revinrevin Contributor Current User Role Beginner
    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.
  • leafonswordleafonsword Contributor Inactive User Role Beginner
    revin wrote: »
    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'?
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.