Tagged articles
Restore
51 articles · Page 1 of 1
This article walks through a real‑world ETCD failure, explains why ETCD is the control‑plane brain, details the three‑layer ETCD architecture, exposes common backup pitfalls, and provides a production‑grade backup‑restore workflow—including snapshot API usage, Go implementation, verification steps, and post‑restore validation—for reliable Kubernetes disaster recovery.
GoKubernetesRestore
0 likes · 33 min read

Milvus 3.0 introduces a lightweight Snapshot feature that creates a point‑in‑time, read‑only view of a collection by freezing metadata and segment manifests instead of copying data, and explains how restore, GC protection, and pin mechanisms work together to enable fast, safe rollbacks.
Copy SegmentGCMilvus
0 likes · 18 min read

This guide explains why mastering etcd is essential for Kubernetes stability and walks through its core concepts, Raft consensus, MVCC storage, deployment, backup and restore procedures, scaling from three to five nodes, performance optimization, monitoring, alerting, troubleshooting, upgrade strategies, security hardening, and real‑world best‑practice recommendations.
KubernetesRestorebackup
0 likes · 49 min read

This comprehensive guide walks Kubernetes operators through the role of etcd, version compatibility, manual and automated backup strategies, disaster‑recovery procedures, performance tuning parameters, monitoring with Prometheus and Grafana, common failure troubleshooting, upgrade paths, and data‑at‑rest encryption, providing concrete commands and best‑practice recommendations for production clusters.
KubernetesPerformance TuningRestore
0 likes · 47 min read


ITPUBApr 27, 2026 · Cloud Native
The article explains that running production Kubernetes clusters without regular backup and recovery plans exposes businesses to severe risks such as cluster failures, data loss, and prolonged downtime, and it details practical etcd physical and Velero logical backup strategies to mitigate these threats.
KubernetesRestoreVelero
0 likes · 9 min read

This guide explains why MySQL backup verification is essential, outlines three pre‑restore checks, provides a step‑by‑step manual recovery procedure for single databases, and introduces a production‑grade Bash script that automates one‑click restoration with safety prompts and logging.
MySQLRestoreautomation
0 likes · 8 min read

This article examines Geth's export and import commands for Ethereum node backup and recovery, detailing their syntax, use‑cases, limitations, and compares them with snapshot sync and filesystem‑level backups to help operators choose the most suitable strategy.
BlockchainEthereumNode Operations
0 likes · 8 min read

This guide explains how to use mysqldump to back up individual databases, multiple databases, all databases, specific tables, and how to compress backups, include drop statements, export only schema, and restore data using both interactive and non‑interactive MySQL commands, plus an automated backup script.
Bash ScriptCompressionMySQL
0 likes · 9 min read

This article explains what mysqldump is, describes its backup mechanism, lists command‑line options with detailed meanings, provides example commands for exporting databases or tables, and shows how to restore data using both system and source commands.
MySQLRestorebackup
0 likes · 8 min read


ITPUBApr 26, 2025 · Databases
This guide compiles a comprehensive set of SQL Server commands for administrators, covering version checks, server and database properties, connection statistics, backup and restore procedures, user and role management, performance diagnostics, cache cleanup, and various maintenance tasks to streamline daily operations.
Performance TuningRestoreSQL Server
0 likes · 19 min read

This guide walks you through configuring Elasticsearch snapshot backups using NFS, installing and using elasticdump for data export, securing the cluster with SSL certificates, setting up user authentication, and managing Kibana access, providing complete commands, configuration snippets, and visual diagrams for each step.
ElasticsearchRestorebackup
0 likes · 17 min read

This guide explains how to back up single or multiple MySQL databases, entire server instances, specific tables, or only schema, using mysqldump with options like -B, gzip compression, add‑drop flags, and provides restore procedures and an automated backup script.
GZIPMySQLRestore
0 likes · 10 min read

This article explains how to extend an existing MySQL master‑slave replication filter to include additional databases by using a low‑cost backup‑restore workflow, detailing two solution options, the chosen approach, and step‑by‑step commands for stopping replication, backing up, setting GTID points, restoring, and updating filter rules.
GTIDMySQLReplication
0 likes · 9 min read

This guide explains how LVM snapshots work, how to create them with copy‑on‑write, restore individual files or entire volumes, and merge snapshots back into the original logical volume, providing a practical backup solution without service interruption.
LVMLinuxRestore
0 likes · 8 min read

Learn how to connect to Redis using redis-cli, select databases, list and manipulate keys, retrieve values, check database size, view server info, and perform full backups and restores, with clear command examples for each operation.
Key OperationsRedisRestore
0 likes · 4 min read

This guide walks you through configuring shared NFS storage for Elasticsearch snapshot backups, creating and restoring snapshots, using elasticdump for data export, and securing the cluster with X‑Pack security, password management, and Kibana role‑based access.
ElasticdumpNFSRestore
0 likes · 21 min read

This article explains why regular Etcd snapshots are essential for Kubernetes disaster recovery and provides detailed, command‑line procedures for restoring Etcd data on both single‑node and high‑availability clusters, including necessary configuration adjustments and verification steps.
OperationsRestorebackup
0 likes · 13 min read

This article explains why physical fine‑grained backup and restore are essential for GaussDB(DWS), outlines the toolchain, advantages, detailed workflow, and practical command‑line usage to protect data warehouse integrity while saving space and time.
GaussDBPhysical Fine-GrainedRestore
0 likes · 7 min read

This guide walks through creating a backup directory, performing a full XtraBackup of MySQL, adding data, executing an incremental backup, simulating accidental database deletion, and then restoring the instance step‑by‑step using preparation, copy‑back, permission fixing, and binlog recovery.
LinuxMySQLRestore
0 likes · 7 min read

This guide demonstrates how to perform a full MySQL backup, create incremental backups, handle accidental database deletions, and restore the data using Percona XtraBackup on a Linux server, including detailed command-line steps and permission adjustments.
LinuxMySQLRestore
0 likes · 4 min read

This article explains why using MySQL's --force option with default extended‑insert backups can cause missing rows during import, demonstrates the issue with a reproducible example, and shows how disabling extended‑insert with --skip-extended-insert restores all data while providing practical usage recommendations.
MySQLRestorebackup
0 likes · 9 min read

Undermoon migrates Redis Cluster slots quickly and simply by orchestrating SCAN, DUMP, PTTL, RESTORE and DEL commands through migrating and importing proxies, balancing CPU load, handling delete‑prone keys, and achieving sub‑minute migration of 1 GB with throughput recovery.
Cluster MigrationDUMPRedis
0 likes · 7 min read

This guide walks through using vmbackup to create snapshots, perform incremental and full backups to various storage backends, and restore data with vmrestore, including command examples, troubleshooting tips, and best practices for VictoriaMetrics data protection.
RestoreTimeSeriesDBVictoriaMetrics
0 likes · 14 min read

This guide explains why etcd is critical for Kubernetes, walks through creating snapshots with etcdctl, automating backups via scripts and cron, and details step‑by‑step procedures for restoring a failed etcd cluster, including stopping services, cleaning data directories, and restarting components to recover the whole cluster.
Restorebackupcloud-native
0 likes · 16 min read

This guide explains how to use Velero to back up and restore Kubernetes clusters, covering its principles, backup types, storage configuration, installation of Velero and MinIO, and step‑by‑step commands for creating, testing, and recovering a MySQL workload.
KubernetesMinIORestore
0 likes · 18 min read

This article demonstrates a step‑by‑step point‑in‑time recovery of a MongoDB sharded cluster by restoring shard instances, replaying oplog entries to a specific timestamp, updating metadata, and finally rebuilding the config server and mongos to achieve a consistent snapshot with max(id)=15.
MongoDBOplogPITR
0 likes · 13 min read

This article walks through diagnosing MySQL disk‑usage spikes caused by data fragmentation, explains why common cleanup commands may fail, and provides a detailed, repeatable procedure—including stopping the service, removing InnoDB files, and restoring the database—to finally free up the occupied space.
Database MaintenanceMySQLRestore
0 likes · 8 min read

This guide explains why etcd backup is critical for Kubernetes disaster recovery, walks through snapshot creation, distribution, scheduled cron jobs, and provides a step‑by‑step procedure to restore the cluster on all nodes, ensuring services resume correctly.
ClusterKubernetesRestore
0 likes · 14 min read

This article explains MongoDB's document-oriented data model, shows how to create an admin user, configure the mongod service on Linux, and provides detailed command‑line examples for backing up and restoring databases and collections using mongodump, mongorestore, mongoexport, and mongoimport.
LinuxMongoDBRestore
0 likes · 5 min read

This article explains how to list MySQL databases, perform full, multiple‑database, single‑database, and table‑specific backups using mysqldump, and restore them correctly, highlighting the differences when using the --databases option and common pitfalls.
MySQLRestoreSQL
0 likes · 4 min read

This guide provides step‑by‑step Oracle commands for creating and dropping databases, configuring users and tablespaces, performing full and table‑level backups with expdp/impdp, handling version compatibility, and cleaning up residual files and sessions.
DBCAData PumpOracle
0 likes · 15 min read

This guide provides comprehensive Oracle database commands for creating and deleting databases in 11g/12c, configuring users and tablespaces, and performing full or selective backup and restore operations with Data Pump, along with practical tips for managing sessions, processes, and cleanup.
DBCAData PumpOracle
0 likes · 15 min read

When MySQL reports 100% disk usage with only a few megabytes left, typical fixes like dropping tables or restarting may not release space, so this article explains how to diagnose data_free bloat, apply proper fragmentation cleanup, and restore the database safely.
MySQLRestorebackup
0 likes · 7 min read

This guide explains why MySQL reports 100% disk usage despite minimal data, shows how to identify excessive data_free, details step‑by‑step commands to defragment tables, free space, and safely backup and restore the database.
MySQLRestorebackup
0 likes · 6 min read

This article introduces MySQL 8.0.21's built‑in multi‑threaded logical backup utility, compares it with legacy tools like mysqldump and mysqlpump, demonstrates usage of dump_instance, dump_schemas and load_dump with Python‑style code snippets, and summarizes performance results and recovery steps.
LogicalBackupMySQLMySQLShell
0 likes · 7 min read

The article evaluates MySQL Shell 8.0.21's new logical backup and restore method—featuring ZSTD compression, chunked parallel export, and parallel LOAD DATA import—against mysqldump, mysqlpump, and mydumper, presenting benchmark results, analysis, and practical command examples.
MySQLRestorebackup
0 likes · 11 min read

This guide demonstrates how to recover MySQL 5.7 data after an accidental UPDATE by extracting row‑based binlog entries, converting them into executable SQL statements, and applying those statements to restore the original table contents.
MySQLRestoreSQL
0 likes · 14 min read

This article explains InfluxDB's built‑in monitoring system, internal measurements, useful commands, HTTP endpoints, and provides detailed instructions for performing full backups and restores, including configuration tweaks, command syntax, and important considerations about formats and data ranges.
InfluxDBRestoreTimeSeriesDB
0 likes · 5 min read

This article provides a comprehensive guide to MySQL InnoDB tablespace encryption, covering its architecture, supported plugins, configuration steps, key rotation, limitations, encrypted table operations, import/export procedures, and backup/restore methods using mysqlbackup and innobackupex.
InnoDBMySQLRestore
0 likes · 17 min read

This article explains how the apply‑log‑only option in Percona XtraBackup affects MySQL restoration, illustrates the risk of data inconsistency when the option is omitted, and provides guidance on correctly using the parameter during full and incremental backup recovery to ensure complete transaction replay.
MySQLRestoreXtraBackup
0 likes · 4 min read

This article explains CB‑SQL's two backup approaches—logical (using DUMP and IMPORT) and physical (using BACKUP and RESTORE)—detailing their mechanisms, supported formats, storage options, performance characteristics, and how they ensure reliable data recovery for large‑scale distributed databases.
CB-SQLLogical BackupPhysical Backup
0 likes · 7 min read


ITPUBJul 25, 2019 · Databases
This guide provides step‑by‑step Oracle commands for creating and dropping databases, performing full and selective backups, restoring data locally or remotely, managing tables—including creation, deletion, renaming, column alterations, primary keys, indexes, and views—as well as querying, inserting, updating, deleting, and copying data efficiently.
Data ManipulationOracleRestore
0 likes · 8 min read


ITPUBApr 16, 2019 · Databases
When a MySQL server contains many databases but you only need to recover one database or a single table, you can extract the relevant CREATE and INSERT statements from a full mysqldump using sed or grep, then import them, avoiding a costly full‑instance restore.
MySQLRestoreTable
0 likes · 4 min read


ITPUBMay 30, 2018 · Databases
This guide explains three practical ways to track SQL Server backup and restore operations—using SSMS UI, T‑SQL with the STATS option, and dynamic management views—plus how to retrieve backup history and avoid common pitfalls.
DMVRestoreSQL Server
0 likes · 7 min read

This article presents two comprehensive Shell scripts—one to validate Oracle RMAN backup sets and another to perform a full backup‑restore experiment—detailing SSH trust configuration, source information collection, log transfer, directory preparation, and step‑by‑step RMAN restore commands, all illustrated with practical screenshots and a GitHub repository link.
OracleRMANRestore
0 likes · 15 min read

This tutorial walks through essential MySQL command-line operations on Linux, covering database connection, creation, deletion, backup strategies, restoration, renaming, and detailed table manipulation such as creating, modifying, and querying data.
MySQLRestorebackup
0 likes · 5 min read


ITPUBJan 29, 2017 · Databases
This guide walks through simulating a catastrophic Oracle database failure, performing incremental RMAN backups, verifying backup completeness, and executing a full restore and recovery—including spfile, controlfile, datafiles, and archived logs—so you can confidently recover a database after total data loss.
OracleRMANRestore
0 likes · 15 min read

This article provides a comprehensive, hands‑on guide to MySQL master‑slave replication, covering configuration changes, creating replication users, backing up the master, restoring to slaves, setting up read/write splitting, handling master failures, implementing dual‑master setups, and performing full and incremental backups and restores.
DualMasterMasterFailureMySQL
0 likes · 17 min read


ITPUBOct 5, 2016 · Databases
This guide walks through exporting Oracle PL/SQL user objects and table data with PL/SQL Developer, then restoring them by dropping the existing user, recreating it with necessary privileges, executing the exported SQL script, and importing table data while handling constraints and triggers.
ExportOraclePL/SQL
0 likes · 5 min read

This guide provides step‑by‑step instructions for connecting to MySQL, creating and managing users and permissions, displaying, creating and deleting databases and tables, performing backups and restores, and executing various query operations such as selecting, updating, and aggregating data.
MySQLQueriesRestore
0 likes · 14 min read

This article explains how to convert and restore SQL Server 2000 backup files to SQL Server 2005, detailing direct restore steps, required file extensions, path adjustments, and key differences such as database creation requirements and naming conventions between the two versions.
Database MigrationRestoreSQL Server
0 likes · 4 min read
