Overview

db-backup.sh

contact: chadhs@digitalnomad.im

Copy db-backup.sh to /usr/local/bin/

Create a MySQL backup user

grant select,show databases,lock tables,show view,trigger on *.* to 'backup'@'localhost' identified by 'passwordyouwant';

Create a backup directory for storing the db dumps. To use the default, do:

mkdir -p /data/backups/mysql

Edit and update the /usr/local/bin/db-backup.sh