© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
C. BellMySQL Database Service Revealedhttps://doi.org/10.1007/978-1-4842-8945-7_6

6. Point-in-Time Recovery

Charles Bell1  
(1)
WARSAW, VA, USA
 

One of the challenges of backup and recovery is manifested when faced with the task of recovering a database or set of databases to a specific point before a critical event occurs. More specifically, the data is considered valid prior to a specific event that caused inconsistencies or data loss. For example, the event could be the result of operator error, a software defect, or hardware/connectivity issues.

When this happens, systems administrators (or database administrators) must restore the data with the last known ...

Get MySQL Database Service Revealed: Running MySQL as a Service in the Oracle Cloud Infrastructure now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.