From: Ananda Kumar (anandklgmail.com)
Date: Sun Jul 08 2007 - 23:34:57 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi Alex,
Thank you for the response,
But i took the dump from slave and slave was in sync with master, so should
i still be doing the restore from bin-log 00003 from position 311.

regards
anandkl

On 7/8/07, Alex Arul Lurthu <alexjyahoo-inc.com> wrote:
>
>
>
> On 7/6/07, Ananda Kumar <anandklgmail.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
>

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]