Re: Point-In-Time Recovery using mysqlbinlog

[Varun Datta]

Hi,

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.

Thanks,
Varun Datta