Below error in SHOW SLAVE STATUS \G;
Last_IO_Errno: 1236
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘Could not find first log file name in binary log index file’
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘Could not find first log file name in binary log index file’
Slave Server: stop slave;
In Master Server: flush logs
In Master Server: show master status; — take note of the master log file and master log position
Slave Server : CHANGE MASTER TO MASTER_LOG_FILE=’viznet-db-bin.000002′, MASTER_LOG_POS=2478;
Slave Server: start slave;
No comments:
Post a Comment