binary log Archives - ITFROMZERO

MySQL Point-in-Time Recovery (PITR) Guide: Second-Accurate Database Restoration

By IT From Zero November 4, 2026

Accidentally executed a DROP TABLE on production? Follow this step-by-step guide to restore MySQL data down to the second using Full Backups and Binary Logs (PITR).

MySQL

mysqlbinlog: How to Read and Analyze MySQL Binary Logs for Incident Investigation and Database Auditing

By IT From Zero June 17, 2026

mysqlbinlog is the tool for reading and analyzing MySQL binary logs, helping you investigate incidents, track down the cause of data loss, and perform Point-in-Time Recovery. This article shares hands-on experience from 6 months running a production MySQL 8.0 instance with 50GB of data — from enabling binlog correctly to working through real-world investigation scenarios.

MySQL

MySQL Point-in-Time Recovery (PITR): Restore Your Database to Any Second with Binary Log

By IT From Zero April 2, 2026

A hands-on guide to MySQL Point-in-Time Recovery (PITR) using Binary Log — restore your database to the exact second before an accidental DELETE or corruption event. Covers locating the binlog position, restoring from backup, replaying transactions, and skipping bad statements.