backup-shellscript

l0pht · 11-02-2012, 04:22 PM

hi friends,
i have a shell script that can backup every mysql database and saved it on a destination folder:

Code:

NOW=$(date +"%d-%m-%Y")
DEST="/home/mysql".${NOW}-$(date +"%T")
# set mysql login info
MUSER="root"         # Username
MPASS=''   # Password
MHOST="localhost"  # Server Name
 
# guess binary names
MYSQL="$(which mysql)"
MYSQLDUMP="$(which mysqldump)"
GZIP="$(which gzip)"
 
[ ! -d "${DEST}" ] && mkdir -p "${DEST}"
# get all db names
DBS="$($MYSQL -u $MUSER -h $MHOST -p$MPASS -Bse 'show databases')"
for db in $DBS
do
 FILE=${DEST}/mysql-${db}.${NOW}-$(date +"%T").gz
 # get around error 
 $MYSQLDUMP --single-transaction -u $MUSER -h $MHOST -p$MPASS $db | $GZIP -9 > $FILE
done

how can i automated it remove 3 or 4 latest one?
thanks

JSkywalker · 11-03-2012, 11:09 AM

Quote:

Originally Posted by l0pht

how can i automated it remove 3 or 4 latest one?

I'm a bit cofused by the question, but i assume:
How can you remove backups which are older than 3 or 4 days?

Quote:

find ${DEST}/mysql-* -mtime +3 -exec echo {} \;

If above statements returns a list of the files you want to delete, than change 'echo' to 'rm'.....