Backup all MySQL (MariaDB) databases

mysql_backup.sh

#!/bin/bash

_now=$(date +"%F_%H_%M%P")
pushd /mnt2/backups/mysql/
for db_name in `mysql -h 127.0.0.1 -u root -e "show databases;" | grep "\|" | grep -v "_schema" | grep -v "mysql" | tail -n +2`; do
  echo  "Backing up ${db_name}"
  filename="${db_name}_${_now}.sql"
  mysqldump -h 127.0.0.1 -u root $db_name > ${filename}
done
tar cvfz mysql_pi_${_now}.tar.gz $(ls *${_now}*.sql) && rm *${_now}*.sql
popd