# Restore backup created by innobackupex

**URL:** <https://forums.percona.com/t/restore-backup-created-by-innobackupex/2522>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [December 17, 2012, 3:49pm UTC](https://forums.percona.com/t/restore-backup-created-by-innobackupex/2522 "2012-12-17T15:49:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sah209](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sah209/32/905_2.png) [@sah209](https://forums.percona.com/u/sah209)\
**Post date:** [December 17, 2012, 3:49pm UTC](https://forums.percona.com/t/restore-backup-created-by-innobackupex/2522/1 "2012-12-17T15:49:15Z")

</div>

wsrep\_provider\_version | 2.2(r137)

Server version: 5.5.28-log Percona XtraDB Cluster (GPL), wsrep\_23.7.r3821

Created a backup with innobackupex, including --galera-info

Please confirm these steps:

If I want to restore the backup,

1. shut down all nodes within the cluster

2. Restore backup  
innobackupex --copy-back /path/to/BACKUP-DIR

3. check files permissions on/in data-dir (/var/lib/mysql), and change as necessary

4. modify my.cnf file parameter wsrep\_cluster\_address to gcomm:// to re-initialize cluster

5. restart mysql

6. start other nodes in cluster, 1 by 1 - should see SST performed

Does that sound about right?

How does the xtrabackup\_galera\_info file come into play?

---

<div class="post-metadata">

**Author:** ![lefred](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lefred/32/16885_2.png) [@lefred](https://forums.percona.com/u/lefred)\
**Post date:** [December 18, 2012, 4:26am UTC](https://forums.percona.com/t/restore-backup-created-by-innobackupex/2522/2 "2012-12-18T04:26:00Z")

</div>

I you want to restore all the nodes like that, you can just ignore the galera\_info, this is used to specifies the position in the replication to be able to perform IST instead of SST.  
If you want to be sure that all your server will perform the SST, you can delete the file grastate.dat (in datadirectory) before starting mysql.

---

<div class="post-metadata">

**Author:** ![sah209](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sah209/32/905_2.png) [@sah209](https://forums.percona.com/u/sah209)\
**Post date:** [December 18, 2012, 8:22am UTC](https://forums.percona.com/t/restore-backup-created-by-innobackupex/2522/3 "2012-12-18T08:22:03Z")

</div>

lefred -  
thanks for the info, however, can you explain further how to restore using the galera\_info?

Say I have a 3-node cluster, and I plan to restore to node 1. How would my steps be modified if I wanted IST for nodes 2 and 3?

Regards,  
Scott