backupmysql.sh

# Backup MySQL datbases.
# Change -uroot to -u{username} and -ppassword to -p{password}.
# Or remove -ppassword if you don't have one.
# If you're running this as a cron, remove the .sh extension before putting it in /etc/cron.daily.
# DIRBASE is the folder where the database backups will be stored, they will be stored by day of the month.

#!/bin/bash
DATED=`date +%d`
DIRBASE="/var/www/work/mysqlbackups"
mysqldump -uroot -ppassword  --all-databases > ${DIRBASE}/${DATED}.sql