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

XtraBackup --compact and stream=tar compatibles with each other?

BoadriusBoadrius EntrantInactive User Role Beginner
Hi everybody,

I'm using innobackupex and I want to perform a backup with --compact and --stream=tar options but when I restore this bak doesn't work... and I don't know why.
It seems as if the secondary indexes didn't create correctly before the retoration though I use the option '--rebuild-indexes'.

Backup command:
innobackupex --user=$db_user --password=$db_pass --compact --stream=tar ./ --no-timestamp | gzip - > $WORKING_DIR/$BCK_FILE

Restore command:
tar -zxif $src -C $TMP_DIR/database
    innobackupex --apply-log --rebuild-indexes $TMP_DIR/database
    innobackupex --copy-back $TMP_DIR/database

The return of the instruction --apply-log is always different from zero...

Anybody knows if this two methods are compatible with each other?
Somebody could give an example with all the steps to be performed this kind of backup?

Thank you so much.

Best regards,

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.