Skip to content

Instantly share code, notes, and snippets.

@anytizer
Created November 10, 2013 06:59
Show Gist options
  • Save anytizer/7394803 to your computer and use it in GitHub Desktop.
Save anytizer/7394803 to your computer and use it in GitHub Desktop.
Database backup script for a week
#!/bin/sh
mkdir -p /home/databases
cd /home/databases
DATE=`date '+%a'|tr '[:lower:]' '[:upper:]'`;
mysqldump --routine -uUSERNAME -pPASSWORD DATABASE1 > ${DATE}-DATABASE1.dmp
mysqldump --routine -uUSERNAME -pPASSWORD DATABASE2 > ${DATE}-DATABASE2.dmp
ls -lah ${DATE}* | mail -s "Databases" "email@domain.com"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment