# Restore Streaming and Compressing Backups Error "log sequence number"

**URL:** https://forums.percona.com/t/restore-streaming-and-compressing-backups-error-log-sequence-number/5010
**Category:** Percona XtraBackup
**Created:** [August 2, 2016, 9:48am UTC](https://forums.percona.com/t/restore-streaming-and-compressing-backups-error-log-sequence-number/5010 "2016-08-02T09:48:38Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Boadrius](https://avatars.discourse-cdn.com/v4/letter/b/a183cd/32.png) [@Boadrius](https://forums.percona.com/u/Boadrius)
#### Post date: [August 2, 2016, 9:48am UTC](https://forums.percona.com/t/restore-streaming-and-compressing-backups-error-log-sequence-number/5010/1 "2016-08-02T09:48:38Z")

</div>

Hi everybody,

I’m using Streaming and Compressing Backups to generate my backup:

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

```

when I restore all it seems ok:

```auto
...
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:

```auto
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