I set up MySQL replication between a couple of my servers, only I kept seeing ‘Slave_IO_Running No’ which is not a good thing.
I looked at the log files at /var/log/mysqld.log and saw the following lines:
100428 15:01:26 [ERROR] Error reading packet from server: Could not find first log file name in binary log index file ( server_errno=1236)
100428 15:01:26 [ERROR] Got fatal error 1236: ‘Could not find first log file name in binary log index file’ from master when reading data from binary log
I searched all over the Web and finally discovered, thanks to http://forums.mysql.com/read.php?26,20262,20628#msg-20628
that I was incorrectly referring to the master log file as mysql.bin.000005 rather than mysql-bin.000005 as it was supposed to be in the following statement:
CHANGE MASTER TO MASTER_HOST=’220.127.116.11′,MASTER_USER=’xxxx’,MASTER_PASSWORD=’xxxxxxx’,MASTER_LOG_FILE=’mysql-bin.000005′,MASTER_LOG_POS=628;
I corrected this and restarted the slave and everything appears to be working.