WordPress Backup and Restore on Linux: Database, wp-content and Automation
Back up WordPress on Linux: mysqldump wp tables, rsync wp-content, gzip archives, cron/systemd automation, off-site copy, restore order,…
Read tutorial →mysql
Browse step-by-step tutorials in this topic.
MySQL vs MariaDB vs PostgreSQL: Which Database for Linux Servers?
Compare MySQL, MariaDB and PostgreSQL on Linux: compatibility, licensing, WordPress vs analytics workloads, backups, and when to pick…
Read tutorial →
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 →
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 →