How to Recover MySQL Data: Full, Point-in-Time, and Table Restoration Techniques

This guide explains how to protect MySQL data with proper backups and row‑format binlogs, then walk through full restores using mysqldump or xtrabackup, point‑in‑time recovery from binlogs, single‑table restoration, skipping erroneous SQL statements, and flashback tools like binlog2sql and MyFlash.

Backup and RestoreData Recoverymysql

0 likes · 15 min read

How to Recover MySQL Data: Full, Point-in-Time, and Table Restoration Techniques

21CTO

Oct 9, 2015 · Databases

Mastering MySQL Migration: Practical Scenarios and Step-by-Step Guides

This article explains why MySQL migrations are essential, outlines backup and restore strategies, and provides detailed, step‑by‑step procedures for multiple real‑world scenarios—including single‑master/slave moves, cross‑datacenter transfers, and multi‑instance setups—while highlighting key precautions and practical tips for successful execution.

Backup and RestoreReplicationdatabase migration

0 likes · 25 min read

Mastering MySQL Migration: Practical Scenarios and Step-by-Step Guides