djo · February 25, 2013 09:32
diff --git a/backup.sh b/backup.sh
 current_date=`date +%Y-%m-%d-%H:%M`
 file_name="db.$current_date.sql.gz"
 file_path="/mnt/backup/$file_name"
 mysqldump --single-transaction --quick -u*** -p*** DB | gzip -c > $file_name
 echo `ls -la $file_path` | mail -s "[backup] DB" [email protected]
diff --git a/s3_job.sh b/s3_job.sh
 cd /mnt/backup
 file=$(ls |tail -n 1)
 log=$(s3cmd put -sv backup_bucket:mysql/$file $file 2>&1)
 echo $log | mail -s "[s3] DB" [email protected]
	current_date=`date +%Y-%m-%d-%H:%M`
	file_name="db.$current_date.sql.gz"
	file_path="/mnt/backup/$file_name"
	mysqldump --single-transaction --quick -u* -p* DB \| gzip -c > $file_name
	echo `ls -la $file_path` \| mail -s "[backup] DB" [email protected]
	cd /mnt/backup
	file=$(ls \|tail -n 1)
	log=$(s3cmd put -sv backup_bucket:mysql/$file $file 2>&1)
	echo $log \| mail -s "[s3] DB" [email protected]