This guide introduces a Python‑based MySQL backup utility featuring multi‑database support, a Tkinter GUI, scheduled backups via APScheduler, detailed logging, and secure config handling, and provides step‑by‑step installation, code walkthrough, and usage instructions for reliable data protection.
This guide details a step‑by‑step solution for hourly client backups of /etc and /var/log, naming conventions, rsync transfer, integrity checks, email notifications, and cleanup on both client and server sides using Bash scripts and cron jobs.
This article provides a step‑by‑step guide to essential MySQL operations, covering connection methods, database creation and deletion, user management, password changes, data manipulation, query techniques, indexing strategies, performance tips, and backup procedures, all illustrated with complete command examples.
This guide explains how LVM snapshots work using copy‑on‑write, shows step‑by‑step commands to create, mount, restore individual files or whole volumes, merge snapshots back into the original LV, and leverage snapshots for disposable test environments, all on Ubuntu 16.04.
This article presents two real‑world MySQL recovery scenarios—full backup restoration after an accidental table deletion and incremental recovery using XtraBackup—detailing backup strategies, binlog extraction, step‑by‑step commands, and validation procedures to safely restore production databases.
This article analyzes why OceanBase backup clean tasks become stuck, examines log and query evidence of scheduler failures and NFS I/O errors, and recommends correcting NFS configuration to resolve the backup cleanup problem.
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.
Learn how to use Linux's built‑in Cron scheduler to create, configure, and run automated backup jobs, covering crontab syntax, time fields, script creation, permission setup, and redirection of output to /dev/null, with step‑by‑step commands and code examples.
Learn how to automate MySQL database backups on both Linux and Windows by using a Python script that leverages mysqldump on Linux and a batch file for Windows, including directory management, retention policies, and execution commands to keep your data safely archived.
This guide explains how to prevent data loss in MySQL by enabling backups and binlog, performing full restores with mysqldump or xtrabackup, executing point‑in‑time recovery, restoring individual tables, skipping erroneous SQL statements, and using flashback tools like binlog2sql and MyFlash.
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.
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.
The article introduces PolarDB‑X version 2.4.1, detailing its enterprise‑grade operational enhancements such as cloud backup set restore, native online DDL with OMC, physical file‑based scaling, flexible data TTL, the overall architecture, and various deployment options for multi‑cloud environments.
This guide explains how Alibaba Cloud ACK Backup Center enables reliable backup, resource adjustment, and seamless migration of stateful applications across Kubernetes clusters, detailing the backup workflow, configurable adjustment strategies, and a step‑by‑step example of moving a StatefulSet from an on‑premise cluster to ACK.
Learn how to leverage Navicat’s powerful database design, structure synchronization, and backup features using the Mall e‑commerce project as a case study, with step‑by‑step instructions, screenshots, and tips for managing MySQL models, tables, foreign keys, and environment migrations.
This guide provides step‑by‑step shell scripts, directory setups, cron jobs, and cleanup commands for reliable backup and restore of Oracle (RMAN and logical), MySQL (full, incremental, Percona XtraBackup), PostgreSQL (logical and physical with pg_rman), and openGauss databases, including retention policies and automation tips.
This guide walks through five practical MySQL backup and restoration workflows—including scheduled full backups, hourly incremental binlog backups for high‑frequency trading, development‑environment data masking, selective table dumps, and cold‑storage disaster recovery—providing exact commands, configuration tweaks, and step‑by‑step procedures.
This guide outlines ten practical strategies—including rollback testing, safe handling of destructive commands, prompt customization, robust backup and verification, production environment discipline, thorough handover, proactive monitoring, cautious auto‑failover, meticulous execution, and simplicity—to help operations engineers dramatically reduce system outages and improve reliability.
This guide walks through recovering a deleted MySQL database stored in Docker volumes by locating the mysql.ibd file, recreating a container with the same image, and mounting the original volume, allowing the lost data to be restored without a backup.
A collection of Zhihu users compares SQL Server and MySQL, highlighting SQL Server's superior locking, performance on massive tables, richer backup and restore tools, tighter C# integration, and enterprise adoption, while acknowledging MySQL's free, lightweight nature and its historical limitations.
The article describes a MySQL 8.0.18 backup failure caused by an undo log remaining in cleanup state for over ten hours, details the error logs, shows how the ChatDBA AI tool analyses and resolves the issue, compares it with ChatGPT‑4o, and provides related activity previews.
This guide outlines comprehensive best practices for database server operations, covering hardware selection, OS and kernel tuning, storage choices, MySQL configuration, performance monitoring, backup strategies, security measures, high availability, automation, and systematic maintenance procedures to ensure optimal reliability and efficiency.
This article shares ten practical operations strategies—including change rollbacks, safe handling of destructive commands, prompt customization, rigorous backup and verification, production environment discipline, careful handovers, robust alerting, cautious automatic failover, meticulous checks, and simplicity—to dramatically improve system reliability and availability.
This guide shows how to create a Bash script that backs up a specific MySQL database using mysqldump, compresses the dump, automatically deletes old backups, explains the find -mtime option, and schedules the process with cron, plus detailed steps for restoring the data.
This article evaluates MySQL backup strategies using Percona XtraBackup, comparing local, remote, and streaming modes in terms of backup duration, primary server load impact, and backup file size, and provides practical recommendations based on detailed test results.
This guide explains how to set up automated MySQL database backups using a shell script that runs mysqldump (optionally compressed), stores the files on a local disk, makes the script executable, and schedules it with a cron job after verifying disk space and cron availability.
This guide explains why accidental database deletion is a critical risk, outlines permission and audit measures, and provides detailed MySQL and file backup solutions—including encryption, multi‑site storage, cron scheduling, and ready‑to‑run Bash scripts—to ensure data safety and system stability.
This guide explains how LVM snapshots work, how to create them using copy‑on‑write, restore individual files or entire volumes, merge snapshots back into the original LV, and leverage snapshots for testing environments, all without stopping services.
This article examines real-world backup failures, explains why backups are essential, outlines what data and system components should be backed up, describes backup principles, classifications, technologies, and disaster recovery planning, and offers practical guidance for building robust, multi-layered backup strategies.
Google Cloud mistakenly deleted data and backups for Australian pension fund UniSuper, causing over 600,000 members to lose access for more than a week, and the incident highlights the risks of single‑provider reliance, the importance of robust backup strategies, and the growing relevance of hybrid and multi‑cloud architectures.
This guide walks through deploying Xenon, an open‑source Raft‑based MySQL high‑availability solution, covering environment setup, installation of Go and Percona XtraBackup, configuring Xenon’s JSON, starting the cluster, monitoring status, and troubleshooting backup failures caused by misconfigured host settings.
The article details Linear's most severe five‑year outage caused by an accidental TRUNCATE CASCADE on a PostgreSQL table, walks through the minute‑by‑minute timeline, explains why CI checks missed the error, and outlines the recovery steps and post‑mortem lessons for future database safety.
This article presents a Bash script that backs up Linux system log directories, removes backups older than a configurable number of days, compresses the daily logs, and sets up a daily cron job to automate the entire process.
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.
This article compares PostgreSQL and MySQL across history, ACID compliance, performance, scalability, advanced features, tooling, security, backup strategies, and Linux installation steps, helping full‑stack developers choose the most suitable open‑source relational database for their projects.
This guide explains how to rescue both physically and logically deleted Oracle databases, covering RMAN file recovery, full database restoration, flashback table techniques, recycle‑bin usage, flashback database configuration, and essential backup strategies to prevent data loss.
This guide explains the tar command’s advanced capabilities—including adding files to existing archives, using gzip or bzip2 compression, extracting specific files with wildcards, creating incremental backups, excluding paths, encrypting archives, limiting archive size, and directing output to custom directories—providing clear examples for each scenario.
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.
This article provides an extensive overview of Kubernetes, covering its core architecture, pod IP design, environment setup, networking models, plugins, security measures, backup strategies, monitoring solutions, Helm usage, gray releases, service mesh concepts, and CI/CD pipeline implementation, offering practical insights for developers and operators.
This guide explains why rsync outperforms scp for file copying, shows how to install it on various Linux and macOS systems, and demonstrates command options—including compression, partial transfers, and SSH tunneling—to reliably resume interrupted transfers.
This comprehensive tutorial walks you through configuring Oracle Data Guard for master‑slave replication, covering prerequisites, detailed command‑by‑command steps, common pitfalls, testing procedures, switchover operations, and post‑switch recovery, all illustrated with diagrams and code snippets.
This article summarizes essential MySQL concepts—including basic terminology, data types, SQL commands, indexes, views, storage engines, backup methods, and performance tuning techniques—to help developers understand and effectively apply this powerful open‑source relational database in real‑world projects.
This article explains how DBA engineers can speed up MySQL data recovery using Xtrabackup by covering three scenarios—full backup with binlog, single-database restore, and single-table restore—detailing steps such as SQL thread replay, parallel replication, and transportable tablespace techniques with practical command examples.
This guide walks through setting up a Dameng data‑guard service using a primary, standby, and monitor server, covering data preparation, configuration of dm.ini, dmmal.ini, dmarch.ini, dmwatcher.ini, starting services, OGUID setup, mode switching, and monitoring to achieve high‑availability replication.
This guide explains why local storage remains essential in the cloud‑native era, outlines a step‑by‑step plan to set up a Kubernetes cluster, deploy Carina for automated local disk management, configure a test Nginx workload, install MinIO and Velero for backup, and finally perform backup and restore operations to verify data integrity.
This article details how Zyb’s multi‑cloud database platform integrates diverse database types, a unified proxy layer, intelligent lifecycle management, automated task orchestration, monitoring, resource allocation, backup, and fault‑handling to achieve efficient, reliable, and secure database operations across cloud environments.
This article presents a collection of seemingly humorous or "wrong" MySQL interview answers, explains why they can be insightful, and provides practical guidance on slow‑query optimization, disaster‑recovery planning, replica lag, insecure configuration, and handling massive schema changes.
This article explains how to migrate a 240 GB MongoDB replica set by performing a full backup with oplog, extracting the incremental oplog timestamp, and then applying incremental backup and restore scripts to minimize downtime, while providing detailed shell commands and precautionary tips.
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.
This article explains why MySQL backups are essential, defines RTO and RPO, compares physical and logical backup methods, describes snapshot, binary‑log, incremental and differential strategies, and provides best‑practice recommendations and example commands for reliable backup and recovery.
This article outlines the typical reasons MySQL databases crash—such as hardware failures, software issues, external attacks, and poor design—and provides practical remedies including regular backups, using myisamchk for repair, leveraging binary logs, optimizing schemas, and upgrading to newer MySQL versions.
This guide outlines a comprehensive MySQL backup solution, covering backup strategy planning, choosing physical versus logical backups, using tools like mysqldump and Percona XtraBackup, automating backups with scripts and cron, storage and retention considerations, and regular recovery testing to ensure data integrity.
This article explains how to use the mysqldump command to back up MySQL databases, demonstrates various backup and restore options, provides a Bash script that maintains a limited number of daily backups, and shows how to schedule the script with crontab for automated execution.
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.
This article provides a collection of ready-to-use Bash scripts for common MySQL administration tasks on Linux, including database backup, table optimization, cleanup of old backups, process monitoring, status checks, size reporting, schema export/import, and lock/unlock operations.
This guide walks through setting up a test environment, extracting binlog positions, generating rollback SQL with the my2sql tool, and safely re‑importing the data to restore rows mistakenly removed by a DELETE statement.
This article explains how Python can automate key operations tasks—remote command execution, log parsing, system monitoring with alerts, batch software deployment, and backup/restore—providing code examples and highlighting additional uses such as testing, data analysis, and machine learning.
This guide explains what rsync is, the platforms it supports, how to install it on Linux and macOS, and provides step‑by‑step commands with key options like -partial and -z to reliably copy files and resume interrupted transfers, offering a more robust alternative to scp.
This article explains how Percona XtraBackup 8.0.33-28 introduces a new design that reduces the time required for the backup‑prepare phase, lowers memory and I/O usage, and speeds up SST when adding new nodes to a Percona XtraDB Cluster, with detailed performance benchmarks and code examples.
This guide explains three practical methods—using crontab, rsync, and mysqldump—to set up scheduled backups of PHP website files and databases on a CentOS server, ensuring data protection through automated daily or periodic tasks.
This guide outlines how to achieve robust security for a PHP website on CentOS by updating the system, configuring Firewalld, installing and hardening PHP, enabling HTTPS, and implementing regular data and database backups.
This article compiles practical operations guidelines covering safe testing, rigorous confirmation before commands, limiting multi‑person access, mandatory backups, careful use of destructive commands, SSH hardening, firewall rules, fine‑grained permissions, continuous monitoring, performance tuning steps, and a disciplined mindset to avoid costly incidents.
This article provides a comprehensive reference of common Linux system administration commands, covering system information, date handling, shutdown/reboot, file and directory manipulation, searching, mounting, disk usage, user/group management, permissions, compression, package management, backup, CD/DVD handling, and networking utilities.
This article introduces ten useful Python automation scripts—including file backup, batch renaming, email sending, text conversion, image processing, timed monitoring, web scraping, folder organization, note compilation, and screen capture—to help readers automate repetitive tasks and boost productivity.
This guide introduces fifteen essential Linux utilities—from cleaning and disk recovery to encryption, configuration editing, and backup—explaining how each tool works and why it can make your system administration tasks more efficient and secure.
This guide introduces fifteen powerful Linux utilities—including FSlint, TestDisk, TrueCrypt, BleachBit, and Wine—explaining their main functions, typical use cases, and how they can help programmers keep systems clean, recover data, secure files, and improve productivity.
Drawing from three and a half years of operations work, this article shares hard‑earned best practices on testing, backups, security, monitoring, performance tuning, and the right mindset to avoid costly mistakes such as data loss, service outages, and security breaches.
This guide explains how to use the Linux tar command to create uncompressed, gzip‑compressed, and bzip2‑compressed archives, extract whole or individual files, list archive contents, append files, verify archives, and check archive sizes, with clear examples for each operation.
This comprehensive guide explains MongoDB cluster architecture, component roles, common use cases, monitoring commands, essential maintenance operations, data migration steps, troubleshooting of typical production issues, and practical optimization recommendations for high‑performance deployments.
This article explains how to activate MySQL 8.0.17+ REDO log archiving, configure the required directory and permissions, resolve common errors when using backup tools like mysqlbackup, and demonstrates manual archiving via the MySQL client with proper user privileges.
Drawing from three and a half years of sysadmin experience, this guide shares practical rules for safe online operations, data protection, security hardening, monitoring, performance tuning, and the right mindset to avoid costly outages and maintain stable, secure services.
This guide explains what Rsync is, its underlying algorithm, key features, and provides step‑by‑step commands for local, LAN, and user‑specific synchronization, daemon configuration, testing scenarios, and how to combine Rsync with inotify‑tools for real‑time bidirectional file replication.
This article provides an in‑depth overview of Percona Backup for MongoDB (PBM), covering its architecture, installation steps, configuration, logical full backups, point‑in‑time incremental backups, restoration procedures, performance testing, selective backup options, known limitations, and useful command‑line examples.
The article explains how a MySQL backup using xtrabackup failed due to two concurrently running cron daemons launching the same backup script, resulting in corrupted compressed files, and provides practical solutions such as using flock, regular restore drills, and monitoring crond processes.
This article details a comprehensive approach to optimizing a large MySQL table, including slow‑query analysis with pt‑query‑digest, index redesign, backup and restore using mydumper, online DDL versus pt‑osc, and batch deletion techniques to reduce latency and storage fragmentation.
The proposed generic backup and disaster‑recovery framework introduces three business layers—backup data, DR retrieval, and dirty‑data cleanup—supporting both manual and scheduled backups, automatic or manual cleanup, pagination, bucketed delivery, sharding, and customizable filter chains to prevent large‑scale inconsistencies during failures.
This article outlines the ten most frequent PostgreSQL pitfalls—from default configurations and poor schema design to inadequate backups and mismanaged extensions—providing concrete SQL queries, tuning tools, and best‑practice recommendations to help DBAs detect, diagnose, and prevent each issue before it harms production workloads.
This guide outlines eight frequent pitfalls new Linux users should steer clear of—such as blindly copying commands, overusing root privileges, deleting system files, adding untrusted repositories, switching OSes too quickly, fearing the terminal, pushing Linux on others, and neglecting backups—to ensure a stable and secure system.
This article provides a comprehensive overview of Redis persistence mechanisms, detailing the concepts, features, advantages, disadvantages, trigger strategies, operational processes, configuration options, and troubleshooting steps for both RDB (snapshot) and AOF (append‑only file) approaches.
This article explains how Python can automate common operations tasks—remote command execution, log parsing, system monitoring with alerts, bulk software deployment, and backup/restore—providing code examples for each and highlighting additional tools that help sysadmins improve efficiency and reduce errors.
This article explains the core concepts of data replication, backup strategies, and disaster recovery, covering RTO/RPO metrics, backup types, copy data management, and the differences between data‑level, application‑level, and business‑level disaster recovery solutions.
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.
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.
This tutorial walks through essential Linux command-line techniques, showing how to create a reusable logmsg command, a timestamped backup utility, and a comprehensive Spring Boot administration script, complete with code examples, symbolic linking, permission handling, and execution guidance.
This guide shares practical operations best practices, covering safe online procedures, data protection, security hardening, daily monitoring, performance tuning, and the right mindset to avoid costly mistakes and keep production environments stable and secure.
This guide explains how to use the powerful Linux tar command for full and incremental backups, including common options, exclusion patterns, splitting large archives, automated scheduling with cron, and reliable restoration of files and entire filesystems.
This article shares practical operations guidelines covering safe command usage, backup strategies, security hardening, daily monitoring, performance tuning, and the right mindset to prevent data loss and ensure stable, secure Linux server management.
This announcement introduces the MySQL DBA Elite Practical Course book, detailing its comprehensive coverage of core and advanced MySQL technologies, and outlines a limited-time giveaway event where readers can win copies by following the community’s participation rules.
This article provides a comprehensive guide to Redis persistence, covering the theory and configuration of both RDB snapshotting and AOF append‑only logging, their advantages, drawbacks, practical setup commands, recovery procedures, and performance‑tuning tips for reliable data durability.
This guide walks you through the essential steps, commands, and precautions for safely draining nodes, backing up applications, CRDs, and etcd, then shutting down and later restarting a Kubernetes cluster while avoiding common pitfalls.
Drawing from three and a half years of Linux operations, this guide outlines practical standards for testing, confirming commands, avoiding concurrent edits, mandatory backups, data safety, security hardening, continuous monitoring, performance tuning, and the right mindset to keep production environments stable and secure.
This article details a comprehensive performance investigation of a massive MySQL table, using pt‑query‑digest to analyze slow queries, exposing index inefficiencies, proposing index redesign, demonstrating backup/restore with mydumper, comparing online DDL and pt‑osc for index rebuilding, and recommending small‑batch deletions to reduce latency and maintenance overhead.
This guide explains Rsync's fundamentals, SSH and daemon modes, detailed configuration options, practical command examples, and how to combine it with inotify‑tools for real‑time, automated file synchronization across Linux machines.
This article explains why backing up a Linux system is essential and walks you through four reliable disk‑cloning tools—dd, Partimage, Partclone, and Clonezilla—detailing installation, command usage, and best‑practice tips for creating recoverable disk images.
This guide walks through the ELK stack components—Elasticsearch, Logstash, Kibana, and Filebeat—explains how to collect logs with Beats, integrate Kafka for buffering, and provides detailed Helm3 installation procedures for each service on Kubernetes, plus backup and restore strategies.
This guide compiles fundamental SQL Server commands for creating, modifying, and deleting databases and tables, advanced query operators, join strategies, pagination, data synchronization, performance tuning, backup and restore procedures, and useful built‑in functions, providing a comprehensive reference for database professionals.
This article explains the three main backup methods—full, incremental, and differential—detailing their processes, advantages, disadvantages, and suitable use cases for organizations of different sizes, helping readers choose the most appropriate backup strategy for their business needs.
An extensive collection of SQL Server commands, queries, and administrative procedures covering database creation, table manipulation, indexing, backup, security, replication, and performance tuning, presented with code examples and practical tips for developers and DBAs seeking a handy reference guide.
This article explains why Percona Xtrabackup backups of MySQL 5.7 can fail with "Too many open files" errors, demonstrates how to reproduce the issue under both non‑root and root users, analyzes the open‑files‑limit settings, and provides practical solutions to adjust system and user limits for successful backups.
This article provides an extensive collection of SQL Server commands and techniques covering basic database creation, table manipulation, advanced queries, backup and maintenance, as well as detailed steps for setting up linked servers, snapshot replication, and synchronization procedures between servers.
