mariadb_live_daily_backup_script

#!/bin/bash
set -x

MARIADB="mysqldump --single-transaction=TRUE"
USER="username"
PASS="password"
NOW="$(date +"%d-%m-%Y")"

$MARIADB -u$USER -p$PASS database_name > database_backup_$NOW.sql