MySQL Forums
Forum List  »  Backup

Re: Point-In-Time Recovery using mysqlbinlog
Posted by: Rick James
Date: January 03, 2013 07:46PM

"+1" is very likely to be wrong. Binlog "Pos" is a byte offset into a binlog.

STOP SLAVE;
Capture SHOW SLAVE STATUS;
Use the values in it to "pick up where the slave left off".

Better yet, use Percona's Xtrabackup. It takes care of more of this for you.

Options: ReplyQuote


Subject
Views
Written By
Posted
2162
December 31, 2012 05:24AM
Re: Point-In-Time Recovery using mysqlbinlog
1356
January 03, 2013 07:46PM


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.