restored backup with icremental backup

[niraj_vara]

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.

[xaprb]

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

[niraj_vara]

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 ?