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

Restore Streaming and Compressing Backups Error "log sequence number"

BoadriusBoadrius EntrantInactive User Role Beginner
Hi everybody,

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

when I restore all it seems ok:
...
innobackupex: back to original InnoDB log directory '/var/lib/mysql'
innobackupex: Finished copying back files.

160801 14:38:49  innobackupex: completed OK!

but when I start the mysqld it always I find this kind of error:
2016-08-02 12:10:33 7faee918f7c0 InnoDB: Error: page 48 log sequence number 29548805
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

I have been reading in the Manual (p.23)
'Note that the streamed backup will need to be prepared before restoration. Streaming mode does not prepare the backup.'

I don't know how prepare before restoration instead of perform the backup.

Anybody knows how can I prepare it?
What are the steps I should follow?
How can I used the --apply-log option?

Best regards,
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.