Xtrabackup fails with OS errno 2

[Yadvendra_kushwaha]

I am trying to take a full backup remotely as below

sudo xtrabackup --user=root --password=password --host=1.1.1.1 --backup --target-dir=./data.resync

But backup failes with below error

[Note] [MY-011825] [Xtrabackup] Finished backing up non-InnoDB tables and files
[Note] [MY-011825] [Xtrabackup] Executing FLUSH NO_WRITE_TO_BINLOG BINARY LOGS
[Note] [MY-011825] [Xtrabackup] Selecting LSN and binary log position from p_s.log_status
xtrabackup: File '/foo/bar/mysql-bin.019658' not found (OS errno 2 - No such file or directory)

Xtrabackup complaining about the file mysql-bin.019658 exists in the master server and is the most recent bin file

The closest thread I have found around my problem is

Xtrabackup: File '/var/lib/mysql/binlog.000010' not found (OS errno 2 - No such file or directory)

I’m first time using percona Xtrabackups 8.0. And, while taking full backup with it, I see this error message at the end of log: Below command I used to take backup: xtrabackup --backup --host=xx.xxx.xx.x --user=root --password=xxxx --target-dir=/home/taramaakijay049/backup --datadir=/var/lib/mysql Detailed log: https://ctxt.io/2/AABw5ztaEQ That’s true that there’s no binlog.000010 at the moment. But, I’m not sure why is it looking for it and then throwing this error message. But, there are …

But this hasen’t helped much

I have looked around other posts and but couldn’t found any relevant solution

[Mughees_Ahmed]

I will highly recommend to do it this way Streaming MySQL Backups with Percona XtraBackup - Another Alternative