ERROR 1832 ER_DISTRIBUTED_RESTORE_FAILED: Restoring partitions on `X_DB`. Couldn't find backup file for partition 0 of database `X_DB` (there are 4 partitions without backup files)

Help
1

Hi Team,

I have 2 servers and I need to restore DB from one server to another

I have taken a backup under /data/backup-dir and then copied these files to another server
after that, I am trying to restore from the backup files using the ‘RESTORE DATABASE’ command

But facing the above error mentioned in the title.
Please help me with that

2

See

Double check that no files are missing from the new copy of the backup, and that the user running the memsqld process can read those files. And use a full backup path name when restoring, like “/data/backup-dir/mydb.backup”. Don’t rely on file name completion by the RESTORE operation itself.

3

Hi,
Facing the same issue
after executing command
RESTORE DATABASE X FROM “/data/backup/x.backup”; (full name)

A backup file is copied from another server and backup is taken when 4 leaf nodes were there and now I am trying to restore the same file on another server having 1 leaf node.