Question : Because of the file storage full, we are removing mysql bin log files. Accidentally, we removed mysql-bin.index file. […]
Tag: mysqlbinlog
How do I get the MySQL binary log coordinates from the binary files?
Question : I’m attempting to set up replication for a large (120 GB) MySQL database and I messed up. I […]
Show sql statements from mysql binlog (GTID)
Question : I have mysql binlogs for replication through GTID. I’m trying to show executed update/insert statements like this: mysqlbinlog […]
Shell script for backup binlog files for every 8 hours in MySQL
Question : I’m writing a shell script for point in time recovery for MySQL Instance. Our requirement is backing up […]
Why is restoration from binary logs so slow?
Question : We have a MySQL 5.5 server with binary logging enabled and a backup script that collects the binary […]
How to maintain production database with less data and report database with all data [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Incremental MySQL restore using binlogs
Question : I’ve tried to restore a MySQL database using incremental binlogs and mysqlbinlog tool but I received the following […]
How does MySQL rotate binary log files when number extension reaches its maximum?
Question : Assume the bin-log file format is: something-bin-log.000122. With each file has a maximum of 1GB size before rotating, […]
MySQL binlog format change from MIXED to ROW
Question : One of my customer has MySQL master-slave setup at on-premises, where the binlog format is kept to be […]
MySQL binlog limitations
Question : I have a MySQL instance running on AWS, with around 5000 inserts per second. Any idea what the […]