# restored backup with icremental backup **URL:** \ **Category:** Percona XtraBackup\ **Created:** [January 25, 2012, 7:46am UTC](https://forums.percona.com/t/restored-backup-with-icremental-backup/2200 "2012-01-25T07:46:32Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![niraj\_vara](https://avatars.discourse-cdn.com/v4/letter/n/8dc957/32.png) [@niraj\_vara](https://forums.percona.com/u/niraj_vara)\ **Post date:** [January 25, 2012, 7:46am UTC](https://forums.percona.com/t/restored-backup-with-icremental-backup/2200/1 "2012-01-25T07:46:32Z")
Hi I have first taken a full backup of mysql suppose on monday, In backup I have nearly more than 30 databases,then I have taken the increment backup of tuesday. now I want to restored the one database of tuesday, what should be the command to restored the one database of tuesday? Please guide for the same. ---
**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\ **Post date:** [February 2, 2012, 5:10pm UTC](https://forums.percona.com/t/restored-backup-with-icremental-backup/2200/2 "2012-02-02T17:10:26Z")
Restore the entire backup to Tuesday on a non-production location, then extract this database and copy it to your production server. ---
**Author:** ![niraj\_vara](https://avatars.discourse-cdn.com/v4/letter/n/8dc957/32.png) [@niraj\_vara](https://forums.percona.com/u/niraj_vara)\ **Post date:** [February 2, 2012, 11:29pm UTC](https://forums.percona.com/t/restored-backup-with-icremental-backup/2200/3 "2012-02-02T23:29:27Z")
Hi Thnks for reply. In my environment I need to frequent restored the database from the live server to the local (development server), As you suggested for this I need to keep a another system in spare for restored the live server databases !!! which is some cost on us !!! Xtrabckup will not suit in our environment ?