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

Error Using xbstream, compression, and encryption together

trendiertrendier EntrantInactive User Role Beginner
I am using this command:

innobackupex --encrypt=AES256 --encrypt-key-file=/usr/lib/backup/BACKUP.key --user=x --password='x' --stream=xbstream /usr/lib/backup/ > /usr/lib/backup/g."$TIMESTAMP".xbstream

Then I wanted to check if I can restore my file using:

xbstream -x < /usr/lib/backup/g.2013-09-22_07-30-35.xbstream -C /usr/lib/backup/res

but gives me the error:

xb_stream_read_chunk(): wrong chunk magic at offset 0x0.

I tried decrypting the file first as well, which gives me an OK message for the decryption, but I get the same error when I run the xbstream command again.

How can I fix this?


  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner

    Can you tell me which xtrabackup version you are using? Because looks like there are some bugs related to this.

    One more thing that the stream must be decrypted first before read by xbstream so I would suggest to use both at the same time. something like

    xbcrypt -d --a AES256 -f /usr/lib/backup/BACKUP.key | xbstream -x -C /usr/lib/backup/res
  • trendiertrendier Entrant Inactive User Role Beginner
    xtrabackup version 2.1.5 for Percona Server 5.1.70 unknown-linux-gnu (x86_64) (revision id: 680)

    I tried the command you gave me with a couple changes like adding -i for the input file, and it seems to have worked. I still have to try restoring the file to a new database to confirm if it is correct, but it looks good, and no error messages.

    Here was the command that worked for me, for anyone looking for this answer:
    xbcrypt -d -a AES256 -f /usr/lib/backup/BACKUP.key -i myfile.xbstream | xbstream -x -C /usr/lib/backup/res

    niljoshi, thanks so much! I will be testing these files tomorrow, if I don't report back, you can assume it worked successfully.
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.