sqlbackup.sh

#!/bin/bash
LOGFILE=/var/log/mysql_backup
DIR=/var/mariadb/
DIRNEW="${DIR}backup_new/"
DIROLD="${DIR}backup_old/"
USER=YOUR_DB_USER
PASS=YOUR_DB_PASSWORD
date +"# Start Backup Mysql at %T %D" >> $LOGFILE
if [ ! -f %DIR ]; then
mkdir $DIR 2>> $LOGFILE
fi
rm -r $DIROLD 2>> $LOGFILE
mv $DIRNEW $DIROLD 2>> $LOGFILE
mariabackup --backup --target-dir=$DIRNEW --user=$USER --password=$PASS 2>> $LOGFILE
mariabackup --prepare --target-dir=$DIRNEW --user=$USER --password=$PASS 2>> $LOGFILE
date +"# Finish backup at %T %D" >> $LOGFILE