Not the answer you need?
Register and ask your own question!

restored backup with icremental backup

niraj_varaniraj_vara EntrantCurrent User Role Beginner
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.

Comments

  • xaprbxaprb Mentor Inactive User Role Beginner
    Restore the entire backup to Tuesday on a non-production location, then extract this database and copy it to your production server.
  • niraj_varaniraj_vara Entrant Current User Role Beginner
    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 ?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.