This article introduces three practical Shell scripts—an alert sender for Linux systems, a MySQL backup loop, and a real‑time network interface traffic monitor—demonstrating how automation can streamline routine operations and improve system reliability.
This article provides two Bash scripts: one that automatically detects and blocks IP addresses generating excessive requests to an Nginx server using iptables, and another that backs up all non‑system MySQL databases with timestamped filenames, both designed for easy server operation and maintenance.
This guide walks through downloading and installing Percona XtraBackup on a CentOS server, then demonstrates how to create full backups, remove timestamps, inspect backup contents, and execute incremental backups with detailed command examples and explanations.
This guide presents four practical Bash scripts for production Linux servers, covering MySQL full backup with remote sync, Nginx process monitoring that triggers Keepalived failover, MySQL slave status alerts, and a comprehensive CentOS 7 system initialization routine.
This guide explains how Percona XtraBackup works for MySQL hot backups, covering required permissions, key terminology, backup and incremental backup mechanisms, essential command‑line options, and practical script examples to ensure reliable, low‑impact data protection.
This guide explains how mysqldump works, its syntax, and practical commands for backing up all databases, specific databases or tables, exporting only DDL, handling large datasets, compressing backups, and restoring data on Linux or Windows environments.
This guide walks you through creating a Linux shell script that uses mysqldump to back up a MySQL database, organizing old backups, setting execution permissions, and scheduling the process with cron for reliable, automated daily backups.
