# xtrabackup + prepare = works (but I only wanted a DDL backup + Data backup)

**URL:** <https://forums.percona.com/t/xtrabackup-prepare-works-but-i-only-wanted-a-ddl-backup-data-backup/6868>\
**Category:** Percona XtraBackup\
**Created:** [February 24, 2019, 11:39pm UTC](https://forums.percona.com/t/xtrabackup-prepare-works-but-i-only-wanted-a-ddl-backup-data-backup/6868 "2019-02-24T23:39:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![usasshp](https://avatars.discourse-cdn.com/v4/letter/u/eb8c5e/32.png) [@usasshp](https://forums.percona.com/u/usasshp)\
**Post date:** [February 24, 2019, 11:39pm UTC](https://forums.percona.com/t/xtrabackup-prepare-works-but-i-only-wanted-a-ddl-backup-data-backup/6868/1 "2019-02-24T23:39:39Z")

</div>

1. Had no problem with xtrabackup + prepare (works great)
2. But what I really want is just a simple DDL backup plus just the data backup (nothing else)
3. I need that backup to be something that I can edit and modify (I can do this already with mysqldump)
4. How do I get this simpler backup without the huge extras? (i.e. ibdata1)

---

<div class="post-metadata">

**Author:** ![vadimtk](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadimtk/32/9528_2.png) [@vadimtk](https://forums.percona.com/u/vadimtk)\
**Post date:** [February 27, 2019, 3:31pm UTC](https://forums.percona.com/t/xtrabackup-prepare-works-but-i-only-wanted-a-ddl-backup-data-backup/6868/2 "2019-02-27T15:31:19Z")

</div>

XtraBackup is a physical backup, you can’t modify it.  
If you need something you want to edit, you should use mysqldump or mydumper.