Backup MySQL databases

bck_mysql

#!/bin/bash

cd [backup_folder]

today=`date +%Y-%m-%d`
filename="mysql/mysql-$today.sql"

# Backup all databases
# mysqldump -u [username] -p[password] --all-databases > $filename

# Backup listed databases
mysqldump -u [username] -p[password] --databases [db1] [db2] > $filename

# Sync backup file to another folder
rsync -a --inplace $filename [sync_folder]