Re: bin-log position.

On 7/6/07, Ananda Kumar <anandkl@gmail.com> wrote:
>
>
> -- CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000003',
> MASTER_LOG_POS=311;
>
> As see in the mysqldump is saying to start recovery from bin-log file "'
> mysql-bin.000003'" and position="MASTER_LOG_POS=311",
>
>

You need to use the positions specified in the mysqldump since when u restore using the data, you will get data only till the snapshot specified in the dump.

Thanks
Alex Received on Sun Jul 8 01:12:33 2007