xbstream on partial backups and restore

MySQL & MariaDB Percona XtraBackup
1

Hi,

I am using percona-xtrabackup_2.0.5 on percona mysql 5.5.

My requirement is to backup (daily) only tables from one schema “xxxx” which is around 225 GB.

I am using options
–include=“^xxxx[.].*”
–parallel=8
–compress --compress-threads=8
–stream=xbstream

It is faster as I can use parallel with xbstream. The problems I have are

  1. When I run xbstream -x on the output it always throws me “xb_stream_read_chunk(): wrong chunk magic at offset 0x…” error.
    It works fine on full backups (without --include/–table_file options) but NOT WITH PARTIAL BACKUP.

  2. space issue as i need to backup daily and the above yields to 114 gb file every day.

Does anyone has any suggestions?

Thanks,

2

Hi,

Any solution for “xb_stream_read_chunk(): wrong chunk magic at offset 0x…” error on restoring partial backups?

3

Found 2.0.6 has fixed this issue. [bug/1155189]

Upgraded and it works fine!!