Billy Fire LLC

PR INSIDE for free Public Rela…

PR INSIDE for free Public Relation http://bit.ly/dC2nk4 via http://www.diigo.com/~whittam

I just updated my Squidoo page…

I just updated my Squidoo page: An introduction to Internet marketing and planning / http://tinyurl.com/2u58vez

Posted new article at: http://…

Posted new article at: http://bit.ly/9ehjFM

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.

Tags: mysql replication slave master

Issued press release for Pools…

Issued press release for Poolside Portable Pumps http://bit.ly/c2lHij

Just launched new Web site for…

Just launched new Web site for Corporate Finance Council http://bit.ly/aU5YkX I am pleased with the way it turned out

Working on marketing project f…

Working on marketing project for http://bit.ly/aVAhpm Pool Side Portable pumps.

RT @TechCrunch: Google Co-Foun…

RT @TechCrunch: Google Co-Founders Plan To Sell Up To 10 Million Shares Over Next Five Years http://bit.ly/7OqCCM

Severing all your social netwo…

Severing all your social networking connections: http://bit.ly/7ryjau

Modifying Twitter image. A sym…

Modifying Twitter image. A symbol may be better?