# xbstream on partial backups and restore

**URL:** <https://forums.percona.com/t/xbstream-on-partial-backups-and-restore/2352>\
**Category:** Percona XtraBackup\
**Created:** [March 25, 2013, 12:00pm UTC](https://forums.percona.com/t/xbstream-on-partial-backups-and-restore/2352 "2013-03-25T12:00:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![KaminiVijay](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kaminivijay/32/916_2.png) [@KaminiVijay](https://forums.percona.com/u/KaminiVijay)\
**Post date:** [March 25, 2013, 12:00pm UTC](https://forums.percona.com/t/xbstream-on-partial-backups-and-restore/2352/1 "2013-03-25T12:00:39Z")

</div>

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,

---

<div class="post-metadata">

**Author:** ![KaminiVijay](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kaminivijay/32/916_2.png) [@KaminiVijay](https://forums.percona.com/u/KaminiVijay)\
**Post date:** [March 26, 2013, 10:15am UTC](https://forums.percona.com/t/xbstream-on-partial-backups-and-restore/2352/2 "2013-03-26T10:15:37Z")

</div>

Hi,

Any solution for “xb\_stream\_read\_chunk(): wrong chunk magic at offset 0x…” error on restoring partial backups?

---

<div class="post-metadata">

**Author:** ![KaminiVijay](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kaminivijay/32/916_2.png) [@KaminiVijay](https://forums.percona.com/u/KaminiVijay)\
**Post date:** [March 26, 2013, 11:02am UTC](https://forums.percona.com/t/xbstream-on-partial-backups-and-restore/2352/3 "2013-03-26T11:02:40Z")

</div>

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

Upgraded and it works fine!!