GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

xbstream on partial backups and restore

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • xbstream on partial backups and restore

    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?

    Comment


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

      Upgraded and it works fine!!

      Comment

      Working...
      X