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

How to prepare Streaming and Compressing Backups and Log Sequence Error

BoadriusBoadrius EntrantInactive User Role Beginner
Hi everybody,

I'm using Streaming and Compressing Backups to perform my backup on a MariaDB 10.19:
$ innobackupex --user=$db_user --password=$db_pass --compact --stream=tar ./ --no-timestamp | gzip - > $WORKING_DIR/$BCK_FILE

All seems ok even when I restore the backup, innobackup output shows:
...
innobackupex: Finished copying back files.

160801 13:52:31  innobackupex: completed OK!

but when I start the mysqld I find the next message in its log:
2016-08-01 15:52:33 7f08d8ed87c0 InnoDB: Error: page 371 log sequence number 2340146
InnoDB: is in the future! Current system log sequence number 2337804.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
...
a lot of times!

In some cases I can't initialize the mysql.

On the page 23 of the manual 'PerconaXtraBackup-2.1.9.pdf' you can read:
'Note that the streamed backup will need to be prepared before restoration. Streaming mode does not prepare the backup.'

I have no idea of how prepare the backup before the restoration in this situation.
In the manual explains how prepare it using --apply-log argument but the backups aren't performed using stream and compressing mode.

Anybody knows how prepare it correctly?
How can I retore it?
Should I use the --apply-log to prepare it? How?

Thanks for your time.

Best rgrds,
Boadrius
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.