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

xbstream on partial backups and restore

KaminiVijayKaminiVijay EntrantCurrent User Role Beginner
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,

Comments

  • KaminiVijayKaminiVijay Entrant Current User Role Beginner
    Hi,

    Any solution for "xb_stream_read_chunk(): wrong chunk magic at offset 0x...." error on restoring partial backups?
  • KaminiVijayKaminiVijay Entrant Current User Role Beginner
    Found 2.0.6 has fixed this issue. [bug/1155189]

    Upgraded and it works fine!!
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.