mysqldump on Linux: Backup and Restore MySQL/MariaDB (Single Transaction)
Back up MySQL or MariaDB with mysqldump: --single-transaction for InnoDB, compress dumps, schedule with systemd timers, and test…
Read tutorial →mysql
Browse step-by-step tutorials in this topic.
ViciDial MySQL Performance Tuning: Buffer Pool, Connections and Slow Queries
Tune MySQL for ViciDial: measure first, size the InnoDB buffer pool, manage connections, use the slow query log,…
Read tutorial →
ViciDial MySQL Backup and Restore Automation Guide
Automate ViciDial's MySQL backups with a mysqldump script, a systemd timer, and a guarded restore script that won't…
Read tutorial →
Install and Secure MariaDB on Linux (Ubuntu & AlmaLinux)
Install MariaDB on Ubuntu and AlmaLinux. Secure with mysql_secure_installation, create users, and enable remote access safely.
Read tutorial →
WordPress Backup Shell Script (Files + Database on Linux)
Backup WordPress files and MySQL database on Linux with one Bash script. Tar archive plus mysqldump for complete…
Read tutorial →