hmmm i have still some problems
on the slave i removed all the datadir files
on the 3rd node of 1 PXC i ran
xtrabackup --backup --target-dir=/backup/backup_20200504
xtrabackup --prepare --target-dir=/backup/backup_20200504
then rsync on the slave /backup directory
then on the slave i did
cd /backup
rm -rf /var/lib/mysql (this is the datadir of Percona mysql)
xtrabackup --move-back --target-dir=/var/lib/mysql
and i get
xtrabackup version 2.3.10 based on MySQL server 5.6.24 Linux (x86_64) (revision id: bd0d4403f36)200504 11:21:31 [01] Moving ibdata1 to /var/lib/mysql/ibdata1Can not move file ibdata1 to /var/lib/mysql/ibdata1: No such file or directory
what i have to do ?
Thanks in advance
Claudio