# Proper way to backup and restore?

**URL:** <https://forums.percona.com/t/proper-way-to-backup-and-restore/3629>\
**Category:** Percona XtraBackup\
**Created:** [July 21, 2014, 3:12am UTC](https://forums.percona.com/t/proper-way-to-backup-and-restore/3629 "2014-07-21T03:12:19Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![seqizz](https://avatars.discourse-cdn.com/v4/letter/s/e9a140/32.png) [@seqizz](https://forums.percona.com/u/seqizz)\
**Post date:** [July 21, 2014, 3:12am UTC](https://forums.percona.com/t/proper-way-to-backup-and-restore/3629/1 "2014-07-21T03:12:19Z")

</div>

Hi,

I’m struggling with xtrabackup for a while. There are some Innodb corrupt warnings while or after restore on different server. It’s going pretty unstable. There is no corruption on production database of course. Example after-restore error:

> [@](#):
>
> 140721 10:29:39 InnoDB: Error: page 2504 log sequence number 97651749064  
> InnoDB: is in the future! Current system log sequence number 54429130252.  
> 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.5/en/forcing-innodb-recovery.html](http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html)  
> InnoDB: for more information.

Here are the versions and options I use to backup and restore, I’d be grateful if someone check and recommend something:

Prod server (backup via):  
percona-xtradb-cluster-server-5.5 version 5.5.34-25.9-607.precise  
percona-xtrabackup version 2.1.6-702-1.precise

Restored on:  
percona-server-server-5.5 version 5.5.37-rel35.0-657.wheezy  
percona-xtrabackup-21 version 2.1.9-746-1.wheezy

Backup command (innobackupex):  
–galera-info --rsync  
–galera-info --rsync --incremental

Restore command (innobackupex):  
–apply-log --use-memory=2G --ibbackup=xtrabackup\_51

Thanks.

---

<div class="post-metadata">

**Author:** ![alaincraven](https://avatars.discourse-cdn.com/v4/letter/a/edb3f5/32.png) [@alaincraven](https://forums.percona.com/u/alaincraven)\
**Post date:** [July 28, 2014, 11:57pm UTC](https://forums.percona.com/t/proper-way-to-backup-and-restore/3629/2 "2014-07-28T23:57:12Z")

</div>

I have had this before with very busy servers using mysqlhotcopy. Never had it with inno/xtra backup.  
Is your server under heavy load when backing up?  
Also - what is the size of the log file?

---

<div class="post-metadata">

**Author:** ![dcg9381](https://avatars.discourse-cdn.com/v4/letter/d/5daacb/32.png) [@dcg9381](https://forums.percona.com/u/dcg9381)\
**Post date:** [April 4, 2017, 9:51am UTC](https://forums.percona.com/t/proper-way-to-backup-and-restore/3629/3 "2017-04-04T09:51:17Z")

</div>

Same issue… anyone get this sorted?

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [April 10, 2017, 6:53am UTC](https://forums.percona.com/t/proper-way-to-backup-and-restore/3629/4 "2017-04-10T06:53:14Z")

</div>

Can you please share full error log along with my.cnf configuration file to check further. From quick look, It seems those LSN errors will eventually fix once current log sequence number catches up with future log sequence number High amount of fake DML queries can speed up this operation to fix. On safe side, you can check database consistency via mysqlcheck --all-databases or mysqldump to verify that all database tables are in good shape.