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

Answer

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

Marked as Answer by 3159623 · Sep 27 2020
1 - 1

Post Details

Added on Jan 25 2016
1 comment
174 views