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?
Hi,
Can you tell me which xtrabackup version you are using? Because looks like there are some bugs related to this.
[URL]https://bugs.launchpad.net/percona-xtrabackup/+bug/1076063[/URL]
[URL]https://bugs.launchpad.net/percona-xtrabackup/+bug/1184830[/URL]
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 [COLOR=#252C2F]/usr/lib/backup/BACKUP.key | xbstream -x -C [COLOR=#252C2F]/usr/lib/backup/res
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.