restored backup with icremental backup

MySQL & MariaDB Percona XtraBackup
1

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.

2

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

3

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 ?