# Restoring single InnoDB table from lvm backup in 5.5??

**URL:** <https://forums.percona.com/t/restoring-single-innodb-table-from-lvm-backup-in-5-5/3075>\
**Category:** Other Tools\
**Created:** [November 12, 2013, 1:27pm UTC](https://forums.percona.com/t/restoring-single-innodb-table-from-lvm-backup-in-5-5/3075 "2013-11-12T13:27:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dgolliner](https://avatars.discourse-cdn.com/v4/letter/d/858c86/32.png) [@dgolliner](https://forums.percona.com/u/dgolliner)\
**Post date:** [November 12, 2013, 1:27pm UTC](https://forums.percona.com/t/restoring-single-innodb-table-from-lvm-backup-in-5-5/3075/1 "2013-11-12T13:27:39Z")

</div>

Hi guys,

We currently use the holland backup from rackspace, and certain scenarios have been brought up from my development team (For example, a table being dropped (not corrupt)) and I was wondering if it is possible to restore a single table instead of the entire data directory from an lvm backup.

I’m able to find ways using mysqldump, but unfortunately our environment is too large for that utility.

Any help would be appreciated.

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [November 18, 2013, 6:42am UTC](https://forums.percona.com/t/restoring-single-innodb-table-from-lvm-backup-in-5-5/3075/2 "2013-11-18T06:42:56Z")

</div>

You may be interested in this manual page:  
[url][http://dev.mysql.com/doc/refman/5.6/en/tablespace-copying.html[/url]](http://dev.mysql.com/doc/refman/5.6/en/tablespace-copying.html%5B/url%5D)

Also:  
[url][Percona XtraBackup](http://www.percona.com/doc/percona-xtrabackup/2.1/xtrabackup_bin/partial_backups.html%5B/url%5D)

---

<div class="post-metadata">

**Author:** ![dgolliner](https://avatars.discourse-cdn.com/v4/letter/d/858c86/32.png) [@dgolliner](https://forums.percona.com/u/dgolliner)\
**Post date:** [November 18, 2013, 10:05am UTC](https://forums.percona.com/t/restoring-single-innodb-table-from-lvm-backup-in-5-5/3075/3 "2013-11-18T10:05:22Z")

</div>

Thank you sir!