My Oracle Support Banner

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

Last updated on APRIL 19, 2023

Applies to:

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

Goal

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

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- Create backup from replica
 2- Copy backup to source
 On the Source:
 3- Shut down MySQL on source
 4- Remove the old data
 5- Restore the data
 6- Change mysql directory ownership to mysql user
 7- If you're using SELinux
 8- Prevent writes
 9- Start mysql service
 10- Then you need to change source on the replica based on the source's new coordinates:
 11- Re-enable writing on the source then restart MySQL
References

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