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?