xtrabackup_tablespaces: No such file or directory

MySQL & MariaDB Percona XtraBackup
1

sql1 - master server

percona-xtrabackup-80

sql2 - slave

percona-xtrabackup-80

sql1-zone-a:

sudo xtrabackup -uroot -p$root_pass --backup --target-dir=/home/dinky/backup/percona

sudo xtrabackup -uroot -p$root_pass --prepare --target-dir=/home/dinky/backup/percona

rsync -avpP -e ssh /home/dinky/backup/percona/ dinky@sql2:/home/dinky/backup/percona/

sql2-zone-c:

sudo xtrabackup -uroot -p$root_pass --move-back --target-dir=/home/dinky/backup/percona/ --datadir=/var/lib/mysql/

xtrabackup: Error: cannot open file ‘./xtrabackup_tablespaces’

I can’t find solution.

2

Hi dinky_sam

can you please share the full log of backup command, prepare and move-back?

Also, can you run on sql2-zone-c:

ls -lah /home/dinky/backup/percona/

This error means the file xtrabackup_tablespaces has not been found at /home/dinky/backup/percona/ on the server you are executing --move-back.

Another possibility is that on source you are using PXB 2.4 and on destination, where you are trying to do the move-back you have PXB version 8.0