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

Output formats of xtra backup

mavera2mavera2 EntrantInactive User Role Beginner
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

Comments

  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    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
  • mavera2mavera2 Entrant Inactive User Role Beginner
    Thank you very much scott.
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.