Not the answer you need?
Register and ask your own question!

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

usasshpusasshp EntrantLegacy User Role Novice
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)


  • vadimtkvadimtk Contributor Percona Staff Role
    XtraBackup is a physical backup, you can't modify it.
    If you need something you want to edit, you should use mysqldump or mydumper.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.