MySQL error 1236:MySQL replication problem

Friday, 16 March 2012

MySQL error 1236:MySQL replication problem


Reasons: the master’s binary log is corrupted, a network problem, or a bug in the master’s or slave’s MySQL code. If you want to check the master’s binary log or slave’s relay log, you will be able to know their names by issuing ‘SHOW SLAVE STATUS’ on this slave’, which was quite logical since the end of the bin-log had been corrupted due to external circumstances.

Solution:
STOP SLAVE;
CHANGE MASTER TO
MASTER_LOG_FILE=’bin.000nnn’,
MASTER_LOG_POS=1;
START SLAVE;

Here check your MASTER_LOG_FILE is your log file name.

No comments:

Post a comment