# Percona xtrabackup tablewise backup and restore

**URL:** <https://forums.percona.com/t/percona-xtrabackup-tablewise-backup-and-restore/7248>\
**Category:** Percona XtraBackup\
**Created:** [October 18, 2019, 4:18am UTC](https://forums.percona.com/t/percona-xtrabackup-tablewise-backup-and-restore/7248 "2019-10-18T04:18:06Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![hemantrocks](https://avatars.discourse-cdn.com/v4/letter/h/77aa72/32.png) [@hemantrocks](https://forums.percona.com/u/hemantrocks)\
**Post date:** [October 18, 2019, 4:18am UTC](https://forums.percona.com/t/percona-xtrabackup-tablewise-backup-and-restore/7248/1 "2019-10-18T04:18:06Z")

</div>

Hi,

I am working to take table-wise backup of my database 31 GB so whenever i take xtrabackup it create 5.3 GB of ibdata1 in every table backup so total size of backup comes out to me is 512 GB…  
Is there any solution for tablewise backup in xtrabackup or I need to use mysqldump only for this use case.

---

<div class="post-metadata">

**Author:** ![hemantrocks](https://avatars.discourse-cdn.com/v4/letter/h/77aa72/32.png) [@hemantrocks](https://forums.percona.com/u/hemantrocks)\
**Post date:** [October 21, 2019, 12:38am UTC](https://forums.percona.com/t/percona-xtrabackup-tablewise-backup-and-restore/7248/2 "2019-10-21T00:38:41Z")

</div>

Hi Percona xtrabckup great people,

Please say something over it.