MySQL Forums
Forum List  »  Data Recovery

Replaying binary log?
Posted by: Jan Andersen
Date: March 19, 2021 04:50AM

I worked for a while in a company, where they had found a way to replay the binlogs, in order to restore a database up to a given time after the time of the newest backup; however, I can't find any references to how this is done.

In Percona's documentation for innobackupex, they mention the log sequence number - is this the same as the 'end_log_pos' that can be found in the binlog files (using the mysqlbinlog command)?

I don't know how the DBAs in this company did, only that they did it as a matter of routine. Any ideas?

Options: ReplyQuote


Subject
Views
Written By
Posted
Replaying binary log?
554
March 19, 2021 04:50AM
257
March 19, 2021 10:40AM


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.