Backup MySQL/MariaDB

A database if a huge part of many projects, services, and servers. If something goes wrong, data is wrongly updated/deleted there could be many problems. Thankfully we can make backups to make sure our data is safe.

Manual Backup of a DB

Backup all DBs

This follows on from the manual backup, so assumes you have the backup directory created

Automate hourly backups

My backup script

I follow the 3-2-1 backup approach, so I want to keep the files in multiple locations