Issue with MySQL 8.4.4 binlog recovery in Docker container
The official Docker image MySQL 8.4.4 is used. MySQL settings:
server-id=1
log-bin=/var/lib/mysql/binlog
max_binlog_size = 100M
binlog_expire_logs_seconds = 345600
binlog_format=ROW
binlog_row_image=FULL
gtid_mode=ON
enforce-gtid-consistency=ON
The database backup is done using mysqldump with the following parameters: --single-transaction --master-data=2. The image and container settings used for restoring the database are identical to the production one. The database from the backup is restored without errors.
When applying the binlog files using mysqlbinlog, I get the error HY000 mysqlbinlog "can't find record in". I tried running mysqlbinlog with the parameters --start-position and --start-datetime, but always got errors. The binlog files are not corrupted, and there are no DDL statements in the binlog files (no tables are dropped or created). Backup/restore attempts were made multiple times. Restoring from the binlog files always ended with an error.
Subject
Views
Written By
Posted
Issue with MySQL 8.4.4 binlog recovery in Docker container
296
July 01, 2025 05:56AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.