2

I have percona xtrabackup installed in my ubuntu client machine. My local machine IP address is 192.168.0.100. The database that i need to backup is in 192.168.0.200. Is it possible to do the backup of remote server in local server using percona xtrabackup? I tried doing the same using mysqldump in the past but i need to use percona xtrabackup in particular ? Thank you for the response.

ram
  • 21
  • 1
  • 2

2 Answers2

3

You need to install Percona Xtrabackup on the remote server and then SSH from your local server to the remote server. From this position, you can initiate the backup and stream to your local server.

Xtrabackup requires access to MySQL's data directory (and MySQL instance as well), so it can't be run on another server. However, it can be triggered by another server with SSH (or alternative solution) and you can stream the backup to the local server.

For example:

ssh serverA "innobackupex --stream=xbstream /var/lib/mysql" > backup.xbstream
greenweeds
  • 241
  • 1
  • 5
1

It's complicated, xtrabackup needs access to the filesystem, because it's copy database files, when mysqldump connects to the MySQL server and make database dump.

But if you still want to use xtrabackup from remote host, you could try solution from this forum post.

Alexander Tolkachev
  • 4,608
  • 3
  • 14
  • 23