# xtrabackup restore one database to percona-server

**URL:** <https://forums.percona.com/t/xtrabackup-restore-one-database-to-percona-server/6279>\
**Category:** Percona XtraBackup\
**Created:** [April 3, 2018, 7:26am UTC](https://forums.percona.com/t/xtrabackup-restore-one-database-to-percona-server/6279 "2018-04-03T07:26:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dmitri](https://avatars.discourse-cdn.com/v4/letter/d/b9bd4f/32.png) [@dmitri](https://forums.percona.com/u/dmitri)\
**Post date:** [April 3, 2018, 7:26am UTC](https://forums.percona.com/t/xtrabackup-restore-one-database-to-percona-server/6279/1 "2018-04-03T07:26:00Z")

</div>

there is a server with several databases, on crowns are made database backups, separately for each database:  
/usr/bin/xtrabackup --defaults-file=/etc/mysql/my.cnf --user=‘root’ --password=‘password’ --datadir=/var/lib/mysql --databases “$DATABASE” --target-dir=$BACKUP\_DIR/$DATABASE --backup 2\>&1

you need to restore one database without changing others, how to do this?

---

<div class="post-metadata">

**Author:** ![scott.nemes](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/scott.nemes/32/5_2.png) [@scott.nemes](https://forums.percona.com/u/scott.nemes)\
**Post date:** [April 3, 2018, 12:46pm UTC](https://forums.percona.com/t/xtrabackup-restore-one-database-to-percona-server/6279/2 "2018-04-03T12:46:54Z")

</div>

Hi dmitri;

The below guide walks you through the backup/prepare/restore process for a partial backup:

[url][https://www.percona.com/doc/percona-xtrabackup/LATEST/innobackupex/partial\_backups\_innobackupex.html[/url]](https://www.percona.com/doc/percona-xtrabackup/LATEST/innobackupex/partial_backups_innobackupex.html%5B/url%5D)

If you’re trying to restore a single database back into an existing server with other existing databases, then you’ll basically be restoring the individual tables.