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


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


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
 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

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