restored backup with icremental backup


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.

Restore the entire backup to Tuesday on a non-production location, then extract this database and copy it to your production server.


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 ?