BestHub
Sign in
Tagged articles

Data Recovery

113 articles · Page 1 of 2
Golang Shines
Golang Shines
Jun 14, 2026 · Operations

Recovering Data After an Accidental rm -rf on Linux: Step‑by‑Step Guide

When a routine rm -rf command mistakenly wipes critical backup directories on a Linux server, this article walks through the immediate containment actions, detailed forensic data collection, the underlying file‑system mechanics of ext4 and XFS, and a comprehensive suite of recovery techniques—from lsof‑based live file grabs to extundelete, debugfs, LVM snapshots, and cloud‑disk imaging—ensuring you can restore lost files safely.

Data RecoveryFile SystemLVM
0 likes · 57 min read
Recovering Data After an Accidental rm -rf on Linux: Step‑by‑Step Guide
ITPUB
ITPUB
Mar 5, 2026 · Databases

How to Recover a Truncated Oracle Table: Tools and Step‑by‑Step Guide

This article explains what the Oracle TRUNCATE command does, why recovery is challenging, and provides detailed step‑by‑step instructions for four practical tools—FY_Recover_Data, ODU, BBED, and GDUL—to restore data from a mistakenly truncated table.

Data RecoveryDatabase AdministrationOracle
0 likes · 5 min read
How to Recover a Truncated Oracle Table: Tools and Step‑by‑Step Guide
Xiao Liu Lab
Xiao Liu Lab
Jan 17, 2026 · Operations

Recover Accidentally Deleted XFS Files in Minutes with xfs_undelete

This guide walks Linux administrators through why xfs_undelete is the preferred XFS recovery tool, how to install it in under five minutes, and step‑by‑step commands—including basic, time‑filtered, and type‑filtered recovery—plus three real‑world scenarios, advanced tips, and common pitfalls.

Data RecoveryFilesystemLinux
0 likes · 13 min read
Recover Accidentally Deleted XFS Files in Minutes with xfs_undelete
Tencent Architect
Tencent Architect
Jan 7, 2026 · Databases

How Tencent Cloud MongoDB’s Key‑Based Flashback Enables Millisecond‑Level Data Recovery for Games

This article explains Tencent Cloud MongoDB’s backup and restore capabilities, the challenges posed by modern game workloads, and how the industry‑first key‑based flashback feature provides second‑level, fine‑grained, non‑disruptive data recovery, dramatically improving reliability and speed for game operators.

Data RecoveryDatabase ArchitectureFlashback
0 likes · 23 min read
How Tencent Cloud MongoDB’s Key‑Based Flashback Enables Millisecond‑Level Data Recovery for Games
Ops Community
Ops Community
Nov 23, 2025 · Databases

How to Recover Accidentally Dropped MySQL Data in 48 Hours – A Complete Step‑by‑Step Guide

This guide walks you through a full disaster‑recovery workflow for MySQL, covering emergency read‑only switching, pinpointing the deletion time via binlog, preparing a recovery instance, restoring the latest full backup with Xtrabackup or mysqldump, applying incremental binlog changes, verifying data integrity, and safely switching traffic back to the restored database.

BinlogData RecoveryDisaster Recovery
0 likes · 42 min read
How to Recover Accidentally Dropped MySQL Data in 48 Hours – A Complete Step‑by‑Step Guide
Selected Java Interview Questions
Selected Java Interview Questions
Aug 22, 2025 · Databases

How to Recover Accidentally Deleted MySQL Data Using Binlog

This guide explains how to restore mistakenly deleted MySQL rows by leveraging binary logs, covering binlog activation, mode configuration, locating relevant log files, extracting the original INSERT statements or generating reverse DELETE statements, and using open‑source tools to automate the recovery process.

BinlogData RecoverySQL
0 likes · 17 min read
How to Recover Accidentally Deleted MySQL Data Using Binlog
ITPUB
ITPUB
Aug 5, 2025 · Databases

Recovering Accidentally Deleted MySQL Metadata on CDH Without Downtime

This guide details how to restore a CDH cluster after MySQL metadata loss caused by an accidental deletion of the MySQL data directory, covering database locking, locating deleted file handles, reconstructing shared and independent tablespaces, and verifying consistency to bring the platform back online quickly.

CDHData RecoveryDatabase Administration
0 likes · 6 min read
Recovering Accidentally Deleted MySQL Metadata on CDH Without Downtime
dbaplus Community
dbaplus Community
Jul 20, 2025 · Databases

Recovering Deleted MySQL Data Files in CDH: A Step‑by‑Step Guide

This guide walks through diagnosing a MySQL metadata loss in a CDH cluster, locking the database, locating deleted file handles, restoring shared and independent tablespace files, fixing table structures, verifying consistency, and explains the underlying Linux and MySQL mechanisms.

CDHData RecoveryDatabase Administration
0 likes · 6 min read
Recovering Deleted MySQL Data Files in CDH: A Step‑by‑Step Guide
Java Tech Enthusiast
Java Tech Enthusiast
Jul 12, 2025 · Databases

Master MySQL’s Three Logs: Redo, Undo, and Binlog for Data Safety

Learn how MySQL’s three essential logs—Redo Log for durability, Undo Log for transaction rollback, and Binlog for replication—work together, understand their configurations, performance trade‑offs, and practical monitoring and recovery techniques to ensure data integrity in production environments.

BinlogData RecoveryRedo Log
0 likes · 9 min read
Master MySQL’s Three Logs: Redo, Undo, and Binlog for Data Safety
Java Captain
Java Captain
Jul 4, 2025 · Information Security

How to Use WeChat’s Hidden “Recover” Feature to Restore Lost Chats

This guide explains WeChat’s hidden “recover” function, its official purpose and limitations, step‑by‑step recovery methods via search or settings, practical tips, backup strategies, user‑tested success rates, and the risks of third‑party tools, helping users safeguard and restore chat data.

Chat BackupData RecoveryWeChat
0 likes · 8 min read
How to Use WeChat’s Hidden “Recover” Feature to Restore Lost Chats
Java Captain
Java Captain
Jun 8, 2025 · Mobile Development

Unlock WeChat’s Hidden ‘recover’ Feature to Restore Deleted Chats

This article explains WeChat’s hidden “recover” feature, detailing its official purpose, technical limits, step‑by‑step recovery methods, effectiveness, backup strategies, and the risks of third‑party tools, helping users safely restore lost chat records.

Data RecoveryMobile DevelopmentWeChat
0 likes · 8 min read
Unlock WeChat’s Hidden ‘recover’ Feature to Restore Deleted Chats
dbaplus Community
dbaplus Community
May 24, 2025 · Databases

How to Recover Data After an Oracle TRUNCATE Accident

When an Oracle table is accidentally truncated, this guide explains what TRUNCATE does, why recovery is difficult, and walks through four practical tools—Fy_Recover_Data, ODU, BBED, and GDUL—detailing step‑by‑step commands to restore the lost data safely.

Data RecoveryDatabase ToolsOracle
0 likes · 5 min read
How to Recover Data After an Oracle TRUNCATE Accident
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 8, 2025 · Databases

Using MySQL Flashback Tools to Roll Back DML Mistakes

This article explains how to use MySQL flashback utilities such as binlog2sql, my2sql, and MyFlash to recover from accidental DML operations, covering supported SQL types, required binlog settings, tool features, command‑line usage examples, and best‑practice recommendations for preventing future data loss.

BinlogDMLData Recovery
0 likes · 14 min read
Using MySQL Flashback Tools to Roll Back DML Mistakes
Java Tech Enthusiast
Java Tech Enthusiast
Jan 8, 2025 · Databases

Recovering Accidentally Deleted MySQL Data Using Binlog

To recover accidentally deleted MySQL rows, ensure binary logging is enabled and set to ROW mode, locate the appropriate binlog files, use mysqlbinlog (or tools like binlog2sql) to extract the original INSERT events within a time window, and replay or reconstruct them to restore the data.

BinlogData RecoverySQL
0 likes · 16 min read
Recovering Accidentally Deleted MySQL Data Using Binlog
Efficient Ops
Efficient Ops
Dec 1, 2024 · Operations

How I Rescued a Production MySQL Database After a Fatal rm -rf Accident

After a junior engineer mistakenly ran an unguarded rm -rf command that wiped an entire production server—including MySQL and Tomcat—I documented the step‑by‑step recovery using ext3grep, extundelete, and MySQL binlog, highlighting the lessons learned for future operations.

Data RecoveryLinuxOperations
0 likes · 9 min read
How I Rescued a Production MySQL Database After a Fatal rm -rf Accident
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 11, 2024 · Databases

ClickHouse Data Recovery Procedure for a Failed Disk in a 4‑Shard 3‑Replica Cluster

This article details a step‑by‑step recovery of a ClickHouse 4‑shard, 3‑replica cluster after a node’s disks failed, covering verification of residual data, Zookeeper metadata cleanup, table reconstruction, distributed table restoration, and validation of synchronization across replicas.

Data RecoveryDatabase operationsZookeeper
0 likes · 8 min read
ClickHouse Data Recovery Procedure for a Failed Disk in a 4‑Shard 3‑Replica Cluster
Java Tech Enthusiast
Java Tech Enthusiast
May 3, 2024 · Databases

MySQL Data Recovery: Strategies for Handling Accidental Deletion

The article explains how to respond to accidental MySQL data deletion by analyzing loss causes, choosing recovery methods such as mysqldump backups, binary‑log point‑in‑time restores, or Percona’s InnoDB tool, provides step‑by‑step commands, and recommends preventive practices like regular backups, transactions, and strict permissions.

BinlogData RecoveryDatabase Security
0 likes · 3 min read
MySQL Data Recovery: Strategies for Handling Accidental Deletion
macrozheng
macrozheng
Apr 29, 2024 · Databases

How to Recover Accidentally Deleted MySQL Data: A Step-by-Step Guide

This guide explains how to answer MySQL accidental deletion interview questions and outlines practical recovery methods—including backup restoration, binlog usage, third‑party tools—and essential preventive practices such as regular backups, transaction handling, and permission management.

BinlogData Recoverybackup
0 likes · 5 min read
How to Recover Accidentally Deleted MySQL Data: A Step-by-Step Guide
Selected Java Interview Questions
Selected Java Interview Questions
Apr 13, 2024 · Backend Development

Recovering MySQL Data from a Deleted Docker Container

This guide walks through locating the Docker volume of a removed MySQL container, creating a new container with the same image, and swapping the volumes to restore the original database, providing step‑by‑step commands and screenshots for successful data recovery.

Data RecoveryLinuxVolumes
0 likes · 4 min read
Recovering MySQL Data from a Deleted Docker Container
Architecture & Thinking
Architecture & Thinking
Mar 12, 2024 · Databases

Mastering Redis AOF: How Append‑Only Files Ensure Data Persistence

This article explains Redis AOF persistence, covering how the Append‑Only File logs write commands, the configuration options for enabling and syncing AOF, the rewrite process that compresses the log, and how AOF compares with RDB snapshots and hybrid persistence for reliable data recovery.

AOFConfigurationData Recovery
0 likes · 11 min read
Mastering Redis AOF: How Append‑Only Files Ensure Data Persistence
vivo Internet Technology
vivo Internet Technology
Dec 27, 2023 · Databases

Evolution of Vivo's Database Backup and Recovery System

Vivo replaced its fragile Python‑Celery backup system on GlusterFS—characterized by two‑day MySQL backups, single‑point failures, and weak security—with a Java‑based architecture using a Redis cluster and object storage, adding automated copying, verification, point‑in‑time recovery and migration, cutting backup windows to about ten hours and achieving near‑100 % success.

Data RecoveryMongoDBTiDB
0 likes · 28 min read
Evolution of Vivo's Database Backup and Recovery System
ITPUB
ITPUB
Nov 21, 2023 · Operations

How I Survived an Accidental rm -fr /* Disaster and Restored My Server

A developer recounts accidentally running rm -fr /* on a production server, explains how quick interruption, clever use of remaining commands, and step‑by‑step recovery restored critical directories, and shares practical safeguards to prevent such catastrophic deletions in the future.

Data RecoveryLinuxSafety
0 likes · 11 min read
How I Survived an Accidental rm -fr /* Disaster and Restored My Server
php Courses
php Courses
Aug 26, 2023 · Backend Development

Implementing Data Backup and Recovery with PHP

This tutorial demonstrates how to use PHP to create a backup directory, export MySQL tables to text files, and restore them by reading the files and executing INSERT statements, providing complete code examples for both backup and recovery processes.

Data RecoveryPHPbackend
0 likes · 5 min read
Implementing Data Backup and Recovery with PHP
dbaplus Community
dbaplus Community
Jul 18, 2023 · Databases

Recover MySQL Data by Parsing Binlogs with reverse_sql

reverse_sql is an open‑source utility that parses MySQL binary logs in ROW format, generates both original and reverse SQL statements, and helps recover data from accidental DML operations using multithreaded processing and flexible filtering options.

BinlogData RecoverySQL
0 likes · 9 min read
Recover MySQL Data by Parsing Binlogs with reverse_sql
ITPUB
ITPUB
Mar 31, 2023 · Databases

How to Recover From an Accidental Full‑Table Update in Oracle

When a mistaken UPDATE statement overwrites an entire Oracle table, this guide explains four practical recovery techniques—including transaction rollback, flashback queries, LogMiner undo extraction, and RMAN backup restoration—detailing their prerequisites, commands, and trade‑offs.

Data RecoveryFlashback QueryOracle
0 likes · 7 min read
How to Recover From an Accidental Full‑Table Update in Oracle
Laravel Tech Community
Laravel Tech Community
Mar 9, 2023 · Databases

Understanding Redis Persistence: AOF and RDB Mechanisms

This article explains how Redis ensures data durability by using two persistence strategies—Append Only File (AOF) and Redis Database (RDB) snapshots—detailing their operation, configuration options, trade‑offs, rewrite processes, and how they handle expired keys and recovery.

AOFData RecoveryPersistence
0 likes · 13 min read
Understanding Redis Persistence: AOF and RDB Mechanisms
政采云技术
政采云技术
Dec 27, 2022 · Databases

Comprehensive Guide to MySQL Backup Types, Tools, and Procedures

This article provides an in‑depth overview of MySQL backup classifications—including hot, warm, and cold backups—explains physical versus logical backup methods, compares built‑in and third‑party tools such as mysqldump, mysqlhotcopy, LVM snapshots, XtraBackup, and presents step‑by‑step command examples for each approach.

Data RecoveryDatabasesLVM
0 likes · 14 min read
Comprehensive Guide to MySQL Backup Types, Tools, and Procedures
Liangxu Linux
Liangxu Linux
Nov 10, 2022 · Operations

Recover Deleted Files on Linux: TestDisk Guide and Command-Line Techniques

This article explains how deleted files remain on storage until overwritten, describes the role of the file allocation table and magic numbers, and provides step‑by‑step instructions for using TestDisk, command‑line tools, and secure‑delete utilities to recover or permanently erase files on Linux systems.

Data RecoveryLinuxTestDisk
0 likes · 15 min read
Recover Deleted Files on Linux: TestDisk Guide and Command-Line Techniques
ITPUB
ITPUB
Oct 3, 2022 · Databases

Understanding Redis Persistence: RDB vs AOF Explained

This article explains how Redis ensures data durability by describing the two persistence mechanisms—RDB snapshots and AOF append‑only logs—including their creation, loading, configuration options, performance trade‑offs, and guidance on choosing the appropriate method for different workloads.

AOFData RecoveryPersistence
0 likes · 11 min read
Understanding Redis Persistence: RDB vs AOF Explained
ITPUB
ITPUB
Sep 26, 2022 · Databases

Redis Persistence Explained: RDB Snapshots vs AOF Logging

The article narrates how Redis, personified as a character, discovers data loss risks, implements RDB snapshotting and configurable save intervals, learns from MySQL's binary log, adopts Append‑Only File logging with flush policies, and finally adds AOF rewrite to keep storage efficient.

AOFData RecoveryPersistence
0 likes · 9 min read
Redis Persistence Explained: RDB Snapshots vs AOF Logging
IT Xianyu
IT Xianyu
Feb 14, 2022 · Databases

MySQL Data Recovery: Backup Strategies, Point‑in‑Time Restoration, Table Recovery, and Flashback Techniques

This article explains how to prevent data loss in MySQL by enabling binlog in ROW format, performing full and incremental restores using mysqldump or XtraBackup, executing point‑in‑time recovery, restoring individual tables, skipping erroneous SQL statements, and using flashback tools such as binlog2sql and MyFlash.

BinlogData RecoveryFlashback
0 likes · 15 min read
MySQL Data Recovery: Backup Strategies, Point‑in‑Time Restoration, Table Recovery, and Flashback Techniques
Qingyun Technology Community
Qingyun Technology Community
Jan 24, 2022 · Databases

Recover Lost PostgreSQL Data: Tools, Techniques, and Best Practices

This article explains why PostgreSQL data loss occurs, compares DDL and DML causes, and reviews several recovery tools—including pg_resetwal, pg_dirtyread, pg_recovery, pg_filedump, WalMiner, and pageinspect—providing usage examples, summaries, and practical recommendations for effective data restoration.

Data RecoveryDatabase ToolsMVCC
0 likes · 14 min read
Recover Lost PostgreSQL Data: Tools, Techniques, and Best Practices
Su San Talks Tech
Su San Talks Tech
Oct 13, 2021 · Databases

How to Recover Accidentally Deleted MySQL Data Using Binlog

After a client mistakenly imported 60,000 useless rows and a developer’s faulty delete command erased over 100,000 critical records, this guide explains how to use MySQL binlog to locate, extract, and replay the missing SQL statements, restore the data, and prevent future disasters.

BinlogData RecoverySQL
0 likes · 17 min read
How to Recover Accidentally Deleted MySQL Data Using Binlog
ITPUB
ITPUB
Aug 5, 2021 · Databases

How PolarDB‑X’s SQL Flashback Restores Accidentally Deleted Rows in Seconds

This article explains how PolarDB‑X classifies different data‑deletion scenarios, compares traditional recovery methods like PITR, Flashback Query, and binlog‑based tools, and introduces its precise SQL‑level flashback feature that uses TraceID to quickly and accurately restore mistakenly deleted rows.

BinlogData RecoveryFlashback
0 likes · 13 min read
How PolarDB‑X’s SQL Flashback Restores Accidentally Deleted Rows in Seconds
Java Architect Essentials
Java Architect Essentials
Jun 30, 2021 · Operations

Recovering Accidentally Deleted Production Server Data Using ext3grep, extundelete, and MySQL Binlog

After a junior staff member mistakenly ran an unchecked rm‑rf command that erased an entire production server, the author details a step‑by‑step recovery using ext3grep, custom shell scripts, extundelete, and MySQL binlog replay, and concludes with lessons on backup, monitoring, and change management.

Data Recoverybackupext3grep
0 likes · 8 min read
Recovering Accidentally Deleted Production Server Data Using ext3grep, extundelete, and MySQL Binlog
Java High-Performance Architecture
Java High-Performance Architecture
Jun 17, 2021 · Databases

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
Efficient Ops
Efficient Ops
Jun 14, 2021 · Databases

Why Misplaced Quotes in MySQL UPDATE Can Turn All Values to Zero

This article examines how misplaced quotation marks in MySQL UPDATE statements can unintentionally set fields to zero, explains MySQL’s implicit type conversion that causes the condition to always evaluate true, and offers practical steps for detecting and preventing such bugs.

Data RecoverySQLUpdate Statement
0 likes · 6 min read
Why Misplaced Quotes in MySQL UPDATE Can Turn All Values to Zero
MaGe Linux Operations
MaGe Linux Operations
May 31, 2021 · Databases

Why Misplaced Quotes in MySQL UPDATE Can Zero Out Your Data

A developer’s production fix using dozens of UPDATE statements unintentionally set a column to zero because of misplaced quotation marks, illustrating how MySQL’s implicit conversion and syntax quirks can turn seemingly correct SQL into disastrous data loss.

Data RecoverySQLdatabase
0 likes · 6 min read
Why Misplaced Quotes in MySQL UPDATE Can Zero Out Your Data
Top Architect
Top Architect
May 25, 2021 · Databases

Why Misplaced Quotes in MySQL UPDATE Cause Columns to Be Set to Zero

The article explains how incorrectly placed double‑quotation marks in MySQL UPDATE statements change the intended string assignment into a boolean comparison that evaluates to 0, leading to all affected rows being updated with zero values, and shows how to detect and avoid this pitfall.

Data RecoveryDatabase DebuggingQuote Error
0 likes · 6 min read
Why Misplaced Quotes in MySQL UPDATE Cause Columns to Be Set to Zero
ITPUB
ITPUB
Apr 20, 2021 · Databases

How to Rescue MySQL Data from a Crashed Linux VM Using LVM

This guide walks through a step‑by‑step experiment that shows how to recover MySQL files from a Linux virtual machine that cannot boot, by mounting its disk on a new VM, activating LVM volumes, copying configuration and data files, and restarting the database.

Data RecoveryDatabase AdministrationLVM
0 likes · 7 min read
How to Rescue MySQL Data from a Crashed Linux VM Using LVM
Laravel Tech Community
Laravel Tech Community
Mar 27, 2021 · Databases

Using MySQL Binlog for Data Recovery and Rollback

This guide explains how to verify that MySQL binlog is enabled, locate binlog files, use the mysqlbinlog utility to extract change logs for specific time ranges or tables, and apply the extracted SQL to recover or roll back erroneous data modifications.

BinlogData RecoverySQL
0 likes · 5 min read
Using MySQL Binlog for Data Recovery and Rollback
Laravel Tech Community
Laravel Tech Community
Nov 11, 2020 · Information Security

Bitcoin Ransomware Cases and Police Crackdown in China

The article describes how Bitcoin‑based ransomware such as WannaRen encrypts victims' files, the large‑scale attacks on Chinese enterprises and institutions, the police investigations that led to the arrest of the mastermind Ju Mou and his accomplices, and practical advice for preventing such threats.

BitcoinData Recoverycybersecurity
0 likes · 7 min read
Bitcoin Ransomware Cases and Police Crackdown in China
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 27, 2020 · Databases

Understanding MySQL Binlog Structure and Using Python to Perform Flashback, Detect Large Transactions, and Split Binlog Files

This article explains the structure of MySQL ROW‑mode binlogs, demonstrates how to modify binlog events with Python to recover deleted rows, locate oversized transactions, and split large transactions into smaller ones, providing practical scripts and examples for advanced database manipulation.

Data RecoveryFlashbackPython
0 likes · 14 min read
Understanding MySQL Binlog Structure and Using Python to Perform Flashback, Detect Large Transactions, and Split Binlog Files
Liangxu Linux
Liangxu Linux
Aug 18, 2020 · Operations

Recover Accidentally Deleted Files on Windows with the New WinFR Tool

This article introduces Microsoft’s Windows File Recovery command‑line utility, explains its supported file types and recovery modes, details key parameters, shows how to run the winfr command, and provides the download link for quick data restoration.

Data RecoveryWindowscommand-line
0 likes · 4 min read
Recover Accidentally Deleted Files on Windows with the New WinFR Tool
MaGe Linux Operations
MaGe Linux Operations
Jan 12, 2020 · Operations

How to Recover Accidentally Deleted Files on Linux with extundelete

When a sudden incident deletes uploaded data from the /data/webapps/.../upload directory without backups, this guide walks you through installing extundelete (via EPEL or source), locating the deleted inodes, and using extundelete commands to recover the files, while explaining why read‑only mounting is essential.

Data Recoveryextundelete
0 likes · 6 min read
How to Recover Accidentally Deleted Files on Linux with extundelete
37 Interactive Technology Team
37 Interactive Technology Team
Jun 20, 2019 · Databases

From Data Deletion to No Runaway – Building a Reliable Database Backup Platform

After costly data‑deletion mishaps, 37 Interactive Entertainment engineered a robust, multi‑region backup platform that evolved from simple cron scripts to streaming xtrabackup with Celery‑driven task queues, encrypted HDFS/S3 storage, automated rotation and restore verification, ensuring reliable protection against high‑impact data loss.

Backup ArchitectureData RecoveryXtraBackup
0 likes · 7 min read
From Data Deletion to No Runaway – Building a Reliable Database Backup Platform
Tencent TDS Service
Tencent TDS Service
Apr 4, 2019 · Databases

Understanding Redis Persistence: RDB vs AOF Explained

This article provides a detailed analysis of Redis's two persistence mechanisms—RDB snapshots and AOF logging—covering their core concepts, implementation details, trigger conditions, data safety, performance impact, and recovery speed to help engineers choose the appropriate method for their workloads.

AOFData RecoveryPersistence
0 likes · 11 min read
Understanding Redis Persistence: RDB vs AOF Explained
Java Captain
Java Captain
Dec 22, 2018 · Databases

MySQL Database Design, Slow Query Issues, and Handling Mistakes

This article discusses MySQL table design choices, partitioning methods, index best practices, common causes of slow queries with optimization tips, useful diagnostic tools, and recommended actions when accidental operations or bugs affect data.

Data RecoveryIndex OptimizationSlow Queries
0 likes · 10 min read
MySQL Database Design, Slow Query Issues, and Handling Mistakes
dbaplus Community
dbaplus Community
May 20, 2018 · Databases

How to Use MariaDB System-Versioned Tables for Easy Data Recovery

This guide explains MariaDB 10.3 system-versioned tables, showing how to create them with PERIOD FOR SYSTEM_TIME, query historical rows using FOR SYSTEM_TIME clauses, restore previous data via export/import, partition history to reduce storage, and safely manage versioning in production environments.

Data RecoveryMariaDBSQL
0 likes · 10 min read
How to Use MariaDB System-Versioned Tables for Easy Data Recovery
Architect's Tech Stack
Architect's Tech Stack
Mar 24, 2018 · Databases

Understanding Redis Persistence: RDB and AOF Mechanisms

This article explains Redis's two persistence methods—RDB snapshots and AOF append‑only logs—including their operation, configuration options, advantages, disadvantages, and guidance on choosing the appropriate strategy for data durability and recovery.

AOFData RecoveryPersistence
0 likes · 7 min read
Understanding Redis Persistence: RDB and AOF Mechanisms
Architects' Tech Alliance
Architects' Tech Alliance
Mar 17, 2018 · Industry Insights

Why Continuous Data Protection Is Redefining Enterprise Backup Strategies

The article examines how Continuous Data Protection (CDP) transforms traditional backup and disaster‑recovery approaches by offering near‑real‑time recovery points, finer granularity, and flexible implementation models across applications, files, and storage blocks, while comparing its benefits and trade‑offs with conventional methods.

CDMContinuous Data ProtectionData Recovery
0 likes · 10 min read
Why Continuous Data Protection Is Redefining Enterprise Backup Strategies
MaGe Linux Operations
MaGe Linux Operations
Nov 30, 2017 · Fundamentals

Top 13 Essential Hard Drive Data Recovery Tools You Must Know

This guide explains why hard drives fail, distinguishes physical and logical damage, and reviews thirteen powerful data recovery utilities—complete with features, supported file systems, and usage tips—to help you restore lost files efficiently.

Data RecoverySoftwaredisk tools
0 likes · 12 min read
Top 13 Essential Hard Drive Data Recovery Tools You Must Know
ITPUB
ITPUB
Oct 5, 2017 · Databases

Recover Accidentally Deleted Oracle Data with Backup, LogMiner, and Flashback

Oracle provides several powerful recovery mechanisms—logical backups with the import tool, physical file restoration with incomplete recovery, LogMiner analysis of redo logs, and Flashback Query—each illustrated through a scenario where a mistaken update to the TFUNDASSET table is corrected using step‑by‑step procedures and commands.

Data RecoveryFlashbackLogMiner
0 likes · 13 min read
Recover Accidentally Deleted Oracle Data with Backup, LogMiner, and Flashback
ITPUB
ITPUB
Sep 30, 2017 · Databases

Recovering Deleted MySQL User Data from Binary Logs

When a sales employee's workflow records vanished after a WeChat ID change, the team traced the deletion to MySQL binary logs, extracted the relevant log entries, and used bulk UPDATE statements to replace the old user_id with the new one, fully restoring the missing data.

Data RecoveryDatabase AdministrationSQL
0 likes · 5 min read
Recovering Deleted MySQL User Data from Binary Logs
21CTO
21CTO
Jul 10, 2017 · Operations

How I Rescued a Production MySQL Database After a Fatal rm -rf Disaster

After a mistaken rm -rf command wiped an entire production server—including MySQL data—the author chronicles a step‑by‑step recovery using ext3grep, custom scripts, and binlog restoration, highlighting lessons learned and best practices for future incident handling.

BinlogData RecoveryLinux
0 likes · 9 min read
How I Rescued a Production MySQL Database After a Fatal rm -rf Disaster
dbaplus Community
dbaplus Community
Apr 25, 2017 · Databases

9 Proven MySQL Data Recovery Techniques Every DBA Should Know

This guide outlines nine practical MySQL recovery methods—including full backup with binlog, business‑logic rollback, flashback tools, innodb_force_recovery, tablespace discard/import, manual ibd editing, extundelete, and Percona's recovery utility—to help DBAs restore data after accidental deletions, corruption, or hardware failures.

BinlogData RecoveryInnoDB
0 likes · 12 min read
9 Proven MySQL Data Recovery Techniques Every DBA Should Know
MaGe Linux Operations
MaGe Linux Operations
Mar 28, 2017 · Operations

Master Linux Data Backup: Tar, Gzip, and Cron Automation Guide

This guide explains how to use the Linux tar command for manual and compressed backups, create shell scripts for automated backups with cron, and apply these techniques to back up and restore Foxmail Server data, covering command syntax, scheduling, and recovery steps.

Data RecoveryShell scriptcron
0 likes · 11 min read
Master Linux Data Backup: Tar, Gzip, and Cron Automation Guide
MaGe Linux Operations
MaGe Linux Operations
Mar 27, 2017 · Databases

Recover MySQL Data with Binlog: A Step‑by‑Step Guide

This tutorial walks you through locating MySQL binlog files, extracting the faulty statements, converting the logs into SQL scripts, and safely restoring the database while handling duplicates, emphasizing the importance of backups before any operation.

BinlogData Recoverysql script
0 likes · 5 min read
Recover MySQL Data with Binlog: A Step‑by‑Step Guide