MySQL Enterprise Backup 3.9 selective restore

3159623

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)

Dave Stokes-MySQL Community Team-Oracle

3.9 is an older version.  3.12 and 4.0 are the latest releases.

Transportable Tablespace support was added in 3.10 and would not be mentioned in the 3.9 docs.

https://dev.mysql.com/doc/mysql-enterprise-backup/3.12/en/backup-partial-options.html

https://dev.mysql.com/doc/mysql-enterprise-backup/3.12/en/restore-use-tts.html

Dave Stokes-MySQL Community Team-Oracle

3.9 is an older version.  3.12 and 4.0 are the latest releases.

Transportable Tablespace support was added in 3.10 and would not be mentioned in the 3.9 docs.

https://dev.mysql.com/doc/mysql-enterprise-backup/3.12/en/backup-partial-options.html

https://dev.mysql.com/doc/mysql-enterprise-backup/3.12/en/restore-use-tts.html