Skip to main content
Made into an answer
Source Link
Paul White
  • 90.3k
  • 30
  • 424
  • 663

The solution was provided to me in percona forum. Thank you Precona-lorraine for this solution as well. The solution can be found here in the percona forum:

I did this and it worked:

ssh [email protected] "xtrabackup --user=root --password=root
  --backup --stream=xbstream --databases="uniquedb" --target-dir=./" >
  backup.xbstream 2>backup.log

https://www.percona.com/forums/questions-discussions/51705-mysql-backup-of-remote-server-in-my-local-machine-using-percona-xtrabackup This creates the backup of database named uniquedb from 192.168.0.154 to 192.168.0.109 (this is my local machine for now).

The solution was provided to me in percona forum. Thank you Precona-lorraine for this solution as well. The solution can be found here :

https://www.percona.com/forums/questions-discussions/51705-mysql-backup-of-remote-server-in-my-local-machine-using-percona-xtrabackup

The solution was provided to me in the percona forum:

I did this and it worked:

ssh [email protected] "xtrabackup --user=root --password=root
  --backup --stream=xbstream --databases="uniquedb" --target-dir=./" >
  backup.xbstream 2>backup.log

This creates the backup of database named uniquedb from 192.168.0.154 to 192.168.0.109 (this is my local machine for now).

Source Link

The solution was provided to me in percona forum. Thank you Precona-lorraine for this solution as well. The solution can be found here :

https://www.percona.com/forums/questions-discussions/51705-mysql-backup-of-remote-server-in-my-local-machine-using-percona-xtrabackup