# incremental backup for large database

**URL:** <https://forums.percona.com/t/incremental-backup-for-large-database/1223>\
**Category:** Other MySQL® Questions\
**Created:** [July 29, 2009, 5:23am UTC](https://forums.percona.com/t/incremental-backup-for-large-database/1223 "2009-07-29T05:23:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ankur02018](https://avatars.discourse-cdn.com/v4/letter/a/838e76/32.png) [@ankur02018](https://forums.percona.com/u/ankur02018)\
**Post date:** [July 29, 2009, 5:23am UTC](https://forums.percona.com/t/incremental-backup-for-large-database/1223/1 "2009-07-29T05:23:56Z")

</div>

Hi ,  
I have large database with innodb tables Please guide  
how to take incremental backup.

---

<div class="post-metadata">

**Author:** ![wubx](https://avatars.discourse-cdn.com/v4/letter/w/e8c25b/32.png) [@wubx](https://forums.percona.com/u/wubx)\
**Post date:** [July 29, 2009, 10:02pm UTC](https://forums.percona.com/t/incremental-backup-for-large-database/1223/2 "2009-07-29T22:02:08Z")

</div>

There is Two ways to do it :

Frist:  
Use Slave incremental backup  
(flush mysql binlog and backup binlog)  
Second:  
Use InnoDB Hot Backup Or XtraDB hot backup
