How to start MySQL slave/replica skip missing binlogs?
Got fatal error 1236 from master when reading data from binary log: ‘Could not find first log file name in binary log index file’
Sometimes our MySQL master-slave environment has not been used for a long time,slave server is stopped for some reason for a few hours/days, and the master binlog has been automatically deleted. when you resume replication on the slave it fails with above error, and I don’t care about the loss of transactions between them in my test DB. Of course, the production environment may need to rebuild the slave database.
