# Trying to restore partial backup on cluster **URL:** \ **Category:** Percona XtraDB Cluster 5.x\ **Created:** [April 12, 2020, 9:04am UTC](https://forums.percona.com/t/trying-to-restore-partial-backup-on-cluster/7531 "2020-04-12T09:04:41Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![iftaquar](https://avatars.discourse-cdn.com/v4/letter/i/48db29/32.png) [@iftaquar](https://forums.percona.com/u/iftaquar)\ **Post date:** [April 12, 2020, 9:04am UTC](https://forums.percona.com/t/trying-to-restore-partial-backup-on-cluster/7531/1 "2020-04-12T09:04:41Z")
I have a cluster but I want to backup on per databases using --database option. But the problem is restoring a single database back on the cluster. The other nodes is not replicating. Although I have copied it to all datbases,Its not working properly someone please help with steps on restoring particular database on cluster? would be much appreciated ---
**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\ **Post date:** [April 12, 2020, 9:20am UTC](https://forums.percona.com/t/trying-to-restore-partial-backup-on-cluster/7531/2 "2020-04-12T09:20:07Z")
So I’m puzzed - you have running cluster which replicates properly.  You when restored the database taken by mysqldump  to one of the nodes and the database not replicated to others,  do I understand you correctly ? What storage engine do you use and what cluster version ? ---
**Author:** ![iftaquar](https://avatars.discourse-cdn.com/v4/letter/i/48db29/32.png) [@iftaquar](https://forums.percona.com/u/iftaquar)\ **Post date:** [April 13, 2020, 8:59am UTC](https://forums.percona.com/t/trying-to-restore-partial-backup-on-cluster/7531/3 "2020-04-13T08:59:18Z")
Hi, Thanks for coming back.Yes you are right. Yeah I have a cluster version 5.7.26. while I have taken backup of particular database using xtrabackup , I have tried to restore it using the xtrabackup  on one node using restoring individual tables. The restore database is there on that node while its not replicating on other nodes in cluster ---
**Author:** ![iftaquar](https://avatars.discourse-cdn.com/v4/letter/i/48db29/32.png) [@iftaquar](https://forums.percona.com/u/iftaquar)\ **Post date:** [April 13, 2020, 9:04am UTC](https://forums.percona.com/t/trying-to-restore-partial-backup-on-cluster/7531/4 "2020-04-13T09:04:10Z")
I assume the storage engine is INNODb engine by default in Percona cluster ---
**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\ **Post date:** [April 13, 2020, 10:23am UTC](https://forums.percona.com/t/trying-to-restore-partial-backup-on-cluster/7531/5 "2020-04-13T10:23:24Z")
This is expected.  The cluster replicates logical changes to tables while  Percona Xtrabackups   restores physical data file. If you want to install single table to the cluster your better choice to use logical restore  - mysqldump/mysqlpump/mydumper etc  ---
**Author:** ![iftaquar](https://avatars.discourse-cdn.com/v4/letter/i/48db29/32.png) [@iftaquar](https://forums.percona.com/u/iftaquar)\ **Post date:** [April 13, 2020, 11:39am UTC](https://forums.percona.com/t/trying-to-restore-partial-backup-on-cluster/7531/6 "2020-04-13T11:39:35Z")
Keeping in mind the Xtrbackup features,we are using xtrabackup instead of mysqldump.  I m restoring it in all nodes, and then it just disappears from other node. ---
**Author:** ![iftaquar](https://avatars.discourse-cdn.com/v4/letter/i/48db29/32.png) [@iftaquar](https://forums.percona.com/u/iftaquar)\ **Post date:** [April 13, 2020, 11:44am UTC](https://forums.percona.com/t/trying-to-restore-partial-backup-on-cluster/7531/7 "2020-04-13T11:44:20Z")
Also,how safe it would be to restore single tables using mysqldump in prod cluster. will there be any inconsisitency in restoring single datbases in cluster using mysqldump. Could you please suggest any document to refer to restore using mysqldump would be helpful ---
**Author:** ![iftaquar](https://avatars.discourse-cdn.com/v4/letter/i/48db29/32.png) [@iftaquar](https://forums.percona.com/u/iftaquar)\ **Post date:** [April 13, 2020, 11:45am UTC](https://forums.percona.com/t/trying-to-restore-partial-backup-on-cluster/7531/8 "2020-04-13T11:45:27Z")
what i mean, any features to be enabled which restoring for consistency purposes in percona cluster ---
**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\ **Post date:** [April 13, 2020, 11:57am UTC](https://forums.percona.com/t/trying-to-restore-partial-backup-on-cluster/7531/9 "2020-04-13T11:57:47Z")
If you restore MySQLDump backup  the Percona Replication Cluster replication engine will ensure all nodes are in sync.  While restoring such table through you better ensure you’re not using too bulky transactions as it can impact cluster performance