My Oracle Support Banner

How to Use MySQL Enterprise Backup (MEB) to Backup from Source And Restore to Replica (Doc ID 1951458.1)

Last updated on JANUARY 25, 2024

Applies to:

MySQL Server - Version 5.6 and later
MySQL Enterprise Backup - Version 3.10 and later
Generic Linux

Goal

How to use MySQL Enterprise Backup (MEB) to backup from Source and restore to Replica.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 1- Backup from source
 
 On the Replica
 3- Shut down MySQL on the Replica
 4- Remove the old data
 5- Restore the data
 6- Guarantee the ownership of the data directory is correct
 7- If SELinux is in use, ensure that the SELinux contexts are correct 
 8- Prevent writes
 9- Start MySQL on the Replica
 10- CHANGE REPLICATION SOURCE based on the coordinates in <backupdir>/meta/backup_variables.txt
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.