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

How does it work?

mafalbmafalb EntrantInactive User Role Beginner
I began reading the documentation but I am very unsure of how it is supposed to work.
I think it is the following paragraph that is confusing me.

XtraBackup needs to be able to connect to the database server and perform operations on the server and the datadir when creating a backup, when preparing in some scenarios and when restoring it. In order to do so, there are privileges and permission requirements on its execution that must be fulfilled.

What I have now is a database server X to be backuped and I have a machine Y where I do dumps with mysqldump.
I noted that innobackupex has a --host parameter so that suggests that I would install xtrabackup on Y and call it with --host=X
But what is that datadir thing? I have no mysql server running on Y, so I have no datadir. Does it mean that I have to install a mysql server on Y? Or does it mean that I cannot do remote backups despite the --host parameter and have to install and run xtrabackup on X?


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.