How to Automate Regular MySQL and MariaDB Backups with a Bash Script

DrupalTV provides a practical Bash script to automate MySQL or MariaDB database backups. The guide covers credential setup, directory configuration, timestamping, and using mysqldump and gzip to export and compress backups. The script also includes logic for optional file cleanup and scheduling via Cron.

The article’s strength lies in its clarity and completeness for beginners. However, it assumes familiarity with shell scripting and server access, which may limit utility for less technical site maintainers. The inclusion of a Drush alternative (drush sql-dump --gzip) is a welcome shortcut for Drupal users, though it lacks the same automation features.

Instructions for restoring backups using zcat are included, but there's no guidance on testing restores—a critical omission for disaster recovery readiness. Still, the guide serves as a solid starting point for implementing lightweight, customizable backup routines on Drupal sites.