MySQL Forums
Forum List  »  Replication

Re: problem of replication
Posted by: ittoronto
Date: August 04, 2005 10:25PM

Thank you for your answering. I did make some mistakes in CHANGE MASTER on the slave. The weird thing is gone now. However, I meet a new problem. the log is:

050804 21:10:08 [ERROR] Error reading packet from server: Binary log is not open (server_errno=1236)
050804 21:10:08 [ERROR] Got fatal error 1236: 'Binary log is not open' from master when reading data from binary log
050804 21:10:08 [ERROR] Slave I/O thread exiting, read up to log 'FIRST', position 4

I used win98 as master, win2k as slave. I have tried to find the binary log file on the master, but cannot. I have stopped and started the master. The log file should be in data directory. I can find the log file on the slave.

Another problem. I tried to change the slave to master and master to slave. I have changed the my.ini file on the slave, but it is still a slave. What is wrong with it please?

Thanks a lot.

Options: ReplyQuote


Subject
Views
Written By
Posted
2963
August 04, 2005 05:54PM
2228
August 04, 2005 07:05PM
Re: problem of replication
5290
August 04, 2005 10:25PM
3386
August 05, 2005 12:12AM
2834
August 05, 2005 12:36AM
2880
August 05, 2005 12:38AM
2509
August 05, 2005 10:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.