MySQL Forums
Forum List  »  Backup

Point in time restore - many bin logs files
Posted by: mmmm mmmm
Date: April 09, 2020 12:34AM

Scenario:
database: db1
table: T1
logical backup: daily 1:00
binary-log: Enable - Let's say there are 400 files (bin.000001....bin.000400)

How can restore T1 to a point-in-time?
Let's say T1 started to be unaccessible at 15:00. Does that mean I have to restore 1:00 backup, and binary logs up until 14:59:59?

Options: ReplyQuote


Subject
Views
Written By
Posted
Point in time restore - many bin logs files
1190
April 09, 2020 12:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.