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 <[EMAIL PROTECTED]> wrote:
On 7/6/07, Ananda Kumar <[EMAIL PROTECTED]> 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