Hi,
I am getting this information from slave
mysql> show slave status \G;
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: 201.107.236.77
Master_User: root
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: ip-201-107-236-77-bin.000042
Read_Master_Log_Pos: 4702
Relay_Log_File: ip-95-84-86-41-relay-bin.000001
Relay_Log_Pos: 98
Relay_Master_Log_File: ip-201-107-236-77-bin.000042
Slave_IO_Running: No
Slave_IO_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 4702
Relay_Log_Space: 98
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
The Slave_IO_Running is always No even after repeating below steps so many times
stop slave
CHANGE MASTER TO ....
and
start slave
Please guide why this is always NO and how do i enable it ?
Regards
Jeetendra Ranjan
