After you stop the slave and start mysqldump,
execute the below on slave db.
show slave status\G.
Note down the Master_Log_File and Exec_Master_Log_Pos. This will be the
point from which you need to do the recovery.
regards
anandkl
On 9/25/07, Eric Frazier <[EMAIL PROTECTED]> wrote:
>
> Boyd
Boyd Hemphill wrote:
I have executed a strategy for backup where I stop a slave and do a mysqldump
with --master-data. Both master and slave are 4.1.20
My assumption was that the log coordinates in the dump file would provide me with the place to replay the log for a point in time recovery.
I have executed a strategy for backup where I stop a slave and do a mysqldump
with --master-data. Both master and slave are 4.1.20
My assumption was that the log coordinates in the dump file would provide me
with the place to replay the log for a point in time recovery.
What I learned today
