Setup Mysql backups in one fell swoop

gistfile1.sh

# install by getting the raw url from the github interface and run something like..
# curl -L https//gist.github.com/blahblah | bash

mkdir -p ~/backups
mkdir -p ~/bin

# a backup for each day of the month overwritting old days
echo "mysqldump -u root --all-databases > ~/backups/all-`date +20XX-XX-%d`.sql" > ~/bin/backup_all_mysql_databases
chmod 777 ~/bin/backup_all_mysql_databases

# do the backup at 1am
(crontab -l ; echo "0 1 * * * ~/bin/backup_all_mysql_databases")| crontab -