#!/bin/bash cd /home/USERNAME/backups/ mkdir mysql suffix=$(date +%y%m%d) mysqldump --opt -u SQLUSERNAME -pSQLPASSWORD -h SQLHOSTNAME SQLBDNME > mysql/backup.$suffix.sql tar -zcf archives/mysql_backup.$suffix.tar mysql/* rm -r mysql/