Hi All,
I have a mysqldump take from machine A on 14th July,2007.
When i took the mysqldump the bin-log file name postion was
Master_Log_File: mysql-bin.000034
Read_Master_Log_Pos: 155537266.
Now i have restored this dump into another machine B which already had
log_bin enabled. Its current
bin-log file name and position is as below
File: mysql-bin.000087
Position: 417737430.
Now if i want to get this machine B in sync with the machine A, how do
i apply the bin-log at regular frequency, because, the bin-log file name in
machine B is different from machine A.
Please help.
regards
anandkl