ryu's blog just a few lines of code

MySQL Dump Backup-Rotation

#!/bin/bash

TIME1=$(date +%d_%m_%Y__%H_%M_%S)
user="root"
passwd="xxxxxx"

# blabla db
db="blabla"
mysqldump -c -f -Q --user=${user} --password=${passwd} --host=localhost ${db} | gzip -f > /root/backup/db_${db}.$TIME1.sql.gz
find /root/backup/db_${db}.*.sql.gz -mtime +3 -exec rm {} ;