- Had no problem with xtrabackup + prepare (works great)
- But what I really want is just a simple DDL backup plus just the data backup (nothing else)
- I need that backup to be something that I can edit and modify (I can do this already with mysqldump)
- How do I get this simpler backup without the huge extras? (i.e. ibdata1)
XtraBackup is a physical backup, you can’t modify it.
If you need something you want to edit, you should use mysqldump or mydumper.