Hi,
Please send output of the "show slave status \G;"
OR
run it on slave and check following things,
---------------------------------------------------------
1) Master_Log_File: pradip.0000xx
Read_Master_Log_Pos: 5114
--> match this bin log file and pos number name with #show master status; (
should be same /nearer )
if this matches well means your IO thread working fine.
----------------------------------------------------------
2) Slave_IO_Running: Yes
Slave_SQL_Running: Yes
--> Check all those Yes or no.
----------------------------------------------------------
3) Exec_Master_Log_Pos: 5114
--> This should be matched/ nearer with "Read_Master_Log_Pos" means your SQL
thread is properly working.
----------------------------------------------------------
4) If 1st and 2nd point are not satisfied then do telnet from your master to
your slave 3306 port number. ( to check your windows firewall blocking it or
not )
----------------------------------------------------------
Note:- For security and privacy take care to not mention real user-name and
passwords in configuration file.
Regards,
Digambar Warke
