How To Fix MySQL Error ‘Could not parse relay log event entry’
1. STOP SLAVE
2. SHOW SLAVE STATUS
3. Note down ‘Relay_Master_Log_File’ and ‘Exec_Master_Log_Pos’ entries.
{
4. RESET SLAVE //Connection information stored in the master.info file is immediately reset using any values specified in the corresponding startup options. This information includes values such as master host, master port, master user, and master password
5. CHANGE MASTER TO ….. (use MASTER_LOG_FILE=relay_master_log_file and MASTER_LOG_POS=exec_master_log_pos from Step 3)
}
OR // without reset ??
{
CHANGE MASTER TO master_log_file=”mysql-bin.000020″, master_log_pos=5382560;
}
6. START SLAVE
