database backup – ITFROMZERO – Share tobe shared!

High-Speed MySQL Backup & Restore: Reducing Time from 15 Hours to 2 Hours with Mydumper

By admin August 1, 2026

Large MySQL database running slow with mysqldump? Discover how to use mydumper and myloader for multi-threaded backups, cutting recovery time by up to 80%.

Database

Barman: Professional PostgreSQL Production Backup Solution – From WAL Archive to PITR

By admin May 27, 2026

Don't let pg_dump keep you up at night. Detailed guide on using Barman for professional PostgreSQL backup management with second-precision data recovery (PITR).

MySQL

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

By admin 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.