# Output formats of xtra backup

**URL:** <https://forums.percona.com/t/output-formats-of-xtra-backup/2904>\
**Category:** Percona XtraBackup\
**Created:** [August 25, 2013, 2:50am UTC](https://forums.percona.com/t/output-formats-of-xtra-backup/2904 "2013-08-25T02:50:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mavera2](https://avatars.discourse-cdn.com/v4/letter/m/7feea3/32.png) [@mavera2](https://forums.percona.com/u/mavera2)\
**Post date:** [August 25, 2013, 2:50am UTC](https://forums.percona.com/t/output-formats-of-xtra-backup/2904/1 "2013-08-25T02:50:47Z")

</div>

I successfully created a full backup with innobackupex.  
It created some frm ibd and other files.

1. Is it possible to create an output that is same as an export created by phpmyadmin ? A dump?  
Or xtra backup only creates binary files in percona format ?
2. I want to store some of the backups in my local machine. Is it possible to create a full backup inside 1 file.  
So I can download that file rather than whole folder.  
Thank you

---

<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:** [August 26, 2013, 10:13am UTC](https://forums.percona.com/t/output-formats-of-xtra-backup/2904/2 "2013-08-26T10:13:01Z")

</div>

Xtrabackup is for creating binary backups. If you want a logical backup (like you are creating from phpMyAdmin), then you will want to use mysqldump. You may however archive/compress the backup that Xtrabackup made into a single file using tar:

I.e.:

cmd\> tar cvzf my-backup.tar.gz /path/to/backup

Then to open/uncompress the archive after downloading it to your computer:

cmd\> tar -xvf my-backup.tar.gz

---

<div class="post-metadata">

**Author:** ![mavera2](https://avatars.discourse-cdn.com/v4/letter/m/7feea3/32.png) [@mavera2](https://forums.percona.com/u/mavera2)\
**Post date:** [August 26, 2013, 3:48pm UTC](https://forums.percona.com/t/output-formats-of-xtra-backup/2904/3 "2013-08-26T15:48:49Z")

</div>

Thank you very much scott.
