Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MySQL Enterprise Backup 3.9 selective restore

3159623Jan 25 2016 — edited Jan 27 2016

Hello Dear Community,

I'm looking to implement MySQL Enterprise Backup for a master-slave MySQL replication setup. Some of the hosted databases are undergoing weekly updates in the form of controller releases and thus the requirement to have a backup tool in place which can do selective database recovery with point in time capability a plus. I've read through pretty much all the the documentation for MySQL Enterprise Backup 3.9 and couldn't find anything on restoring individual databases to an InnoDB engine. From what I understand it comes down to a full file level restore with log replay as far as how this tool works?

Is it not possible with mysqlbackup to restore an individual database from, for example a full image backup, or did I miss something?

Host: RHEL 6.4

MySQL Server: 5.5.28-enterprise-commercial-advanced-log

MySQL Enterprise Backup: 3.9 (last EL6 supported release)

This post has been answered by Dave Stokes-MySQL Community Team-Oracle on Jan 27 2016
Jump to Answer

Comments

Post Details

Added on Jan 25 2016
1 comment
172 views