MySQL Forums
Forum List  »  Backup

Re: Point-In-Time Recovery using mysqlbinlog
Posted by: Varun Datta
Date: January 02, 2013 12:29AM


We are taking backup from Slave in Master-Slave Setup and binlog backup from Master.

Before Starting Backup we stop slave processes so that no changes are recieved from master.

After taking backup slave process is started.

From Show SLave status\G command we note down the values Master_Log_File, Exec_Master_Log_Pos and store this information along with backu so that during restore and recovery we know till which master binlog file and position backup we have restore the data.

Now to Start recoevery , My question is that we will will read master binlog file from position + 1. Please confirm

Is the above strategy for backup is good.

Varun Datta

Options: ReplyQuote

Written By
December 31, 2012 05:24AM
Re: Point-In-Time Recovery using mysqlbinlog
January 02, 2013 12:29AM

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.