Blog

Are you letting your customers know what work you do best and how you can make their business more successful? Effective marketing establishes and promotes your brand. Your web site and marketing materials should, powerfully, demonstrate why they should do business with you.

MySQL replication errors

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=’72.14.183.122′,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.