Im setting up replication with GTID. The total database size is 4GB.

DUMP:

mysqldump -h MASTER_IP  --databases db-u bhuvi -p \
--master-data=1 \
--routines \
--triggers \
--events \
--flush-privileges \
--hex-blob \
--default-character-set=utf8 > db.sql

Binlog Info from DUMP file:

CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000046', MASTER_LOG_POS=89272891;

Once restore done, Im getting this error.

Got fatal error 1236 from master when reading data from binary log: 'The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs containing GTIDs that the slave requires.'

But In master,

show binary logs returns files from mysql-bin.000046. But slave shows the binlog has purged.

Can someone help to understand this error?

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.