This guide shows how to create automated MySQL backups on Linux using a Python script and on Windows using a batch file, covering configuration, backup retention, and cleanup to ensure reliable data protection across platforms.
This article recounts a disastrous production server data loss caused by an accidental rm -rf command, details the step‑by‑step recovery using ext3grep, extundelete and MySQL binlog, and shares hard‑earned lessons to prevent similar incidents.
This comprehensive guide explains Kubernetes persistence fundamentals, core components, enterprise‑grade storage options such as NFS, Ceph, block and object storage, and covers high‑availability design, backup automation, performance tuning, monitoring, alerting, and security best practices for building reliable, scalable storage systems.
This tutorial uses a fantasy metaphor to teach Linux command‑line fundamentals, covering command categories, syntax, file and directory operations, searching, backup techniques, and essential vi editor commands, providing practical examples and cautionary notes for safe system management.
This comprehensive guide walks you through installing Redis on a single server using source compilation and Docker, configuring persistence, memory management, backups, disaster recovery, and systemd service setup, ensuring a production‑ready Redis instance that can handle over 10,000 QPS.
Learn how to design and implement a robust Rsync backup service, covering backup fundamentals, Rsync basics, transfer modes, server deployment, configuration steps, and practical scenarios such as data push/pull, incremental sync, bandwidth limiting, and common troubleshooting tips.
This article explains what a bare Git repository is, why the git clone --mirror command creates one, details its internal directory structure, and shows how to use it for centralized sharing, reliable backups, and seamless repository migration.
This guide explains why backing up GitLab as a pure Git repository is useful, compares the git clone --mirror method with GitLab's built‑in Rake backup, details how to back up critical configuration files, and offers practical automation tips for a robust, multi‑layered backup strategy.
Learn essential MySQL commands—from connecting and managing databases, tables, and users to performing CRUD operations, advanced queries, indexing, and backup/restore—along with practical code examples and optimization tips, enabling you to efficiently handle relational data in real‑world applications.
This comprehensive guide walks you through 100 key concepts of enterprise storage—including architectures, media, redundancy, performance optimization, security, cloud integration, emerging technologies, standards, and operational best practices—helping IT professionals build a solid knowledge foundation for modern data‑centric environments.
Microsoft’s new Windows 11 login makes a Microsoft account mandatory, tying it to services and BitLocker encryption; losing access—especially through account lockout—can render encrypted data unrecoverable, so the article warns users to back up important files locally rather than relying solely on cloud storage.
This article provides ready‑to‑use Shell scripts for Linux system alerts, automated MySQL database backups, and real‑time network interface traffic monitoring, offering sysadmins practical code snippets and configuration steps to streamline routine operations.
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.
This guide walks readers through essential Linux command line skills, covering command syntax, directory navigation, file operations, searching, content viewing, text editing with vi, and backup/restoration techniques, all illustrated with clear examples and practical tips for beginners.
This article provides a step‑by‑step tutorial for DBAs to design a reliable MySQL backup strategy, write a Bash automation script, schedule it with cron, and perform restoration drills using Docker containers, while covering directory planning, command checks, cleanup, and common troubleshooting.
This article presents seven practical Bash shell scripts for Linux system administration, covering automatic file backup, disk usage alerts, old log cleanup, server reachability checks, DNS resolution monitoring, HTTP service health checks, and random password generation, each with explanations and code examples.
This guide explains how to set up an automated MySQL backup solution on AlmaLinux using Docker containers, a Bash script, and crontab, covering environment preparation, script creation, command checks, logging, error handling, and optional enhancements such as email notifications and security best practices.
This guide walks through the required environment, Windows Server rsync installation, configuration of rsyncd.conf and password files, service startup, port verification, and client-side commands to achieve reliable, scheduled file synchronization between Windows machines.
This guide walks through designing, deploying, securing, monitoring, backing up, and maintaining a production‑grade Kubernetes cluster, sharing real‑world pitfalls, configuration snippets, and best‑practice recommendations for high availability, security, observability, and upgrade strategies.
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.
This comprehensive MySQL tutorial covers everything from core concepts and architecture to practical CRUD operations, advanced queries, indexing, transaction control, stored procedures, triggers, replication, performance tuning, backup strategies, and real-world use cases, providing a complete roadmap for developers and DBAs.
This article outlines ten common server operation pitfalls—such as forced power‑offs, reckless experiments in production, neglecting firewall rules, running unknown scripts as root, unbacked‑up database changes, weak SSH settings, poor log management, exposed ports, unmonitored changes, and delayed patching—each illustrated with real‑world cases and practical remediation advice.
The article outlines why deleting tens of millions of rows in one statement harms performance and reliability, then presents safe, efficient tactics—such as indexed batch deletes, partition drops, creating a new table, or using TRUNCATE—plus pre‑deletion planning, post‑delete validation, monitoring, and space reclamation.
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.
Drawing from over 500 enterprise server failure incidents, this guide outlines twenty absolutely prohibited server actions across security configuration, system operation, data management, and architecture design, each paired with a real-world case, risk rating, and concrete remediation steps.
This guide explains how Alibaba Cloud ACK’s Backup Center protects Kubernetes storage volumes, walks through creating backup plans with the Data Protection feature, demonstrates a NAS‑to‑Cloud‑Disk migration example, and details the step‑by‑step backup and restore procedures including YAML definitions and snapshot handling.
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 introduces StackGres 1.6’s core capabilities—including declarative Kubernetes CRDs, default tuning, custom configurations, high‑availability with Patroni, automated backups, server‑side connection pooling, distributed logging, observability, and a web UI—and provides a step‑by‑step quick‑start guide to install the operator, create a PostgreSQL cluster, and access it via psql, services, or the UI.
StackGres 1.6 is a full‑stack, production‑grade PostgreSQL distribution for Kubernetes that bundles a curated set of components—including Patroni, WAL‑G, PgBouncer, Envoy, and monitoring tools—into a single declarative deployment unit with multiple access methods, sidecar architecture, and built‑in high‑availability, backup, and observability features.
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.
