[sql.git] / libexec / cron-daily-local.sh

#!/bin/bash

if [[ -s /srv/mysql/master.info ]]; then
    NEWBF=/srv/backup/daily/sql.mit.edu_`date +%Y-%m-%d`.sql.gz
    /usr/bin/mysqldump -umit-backup -efqQK --all-databases | gzip > $NEWBF
    if [[ -s $NEWBF && `ls /srv/backup/daily/ | wc -l` -ge 4 ]]; then
        rm -f /srv/backup/daily/`ls -t /srv/backup/daily/ | tail -n1`
    fi
fi
Commit	Line	Data
8145dbcc JP	1	#!/bin/bash
8145dbcc JP	2
a677e393	3	if [[ -s /srv/mysql/master.info ]]; then
27a83527	4	NEWBF=/srv/backup/daily/sql.mit.edu_`date +%Y-%m-%d`.sql.gz
a677e393 JP	5	/usr/bin/mysqldump -umit-backup -efqQK --all-databases \| gzip > $NEWBF
	6	if [[ -s $NEWBF && `ls /srv/backup/daily/ \| wc -l` -ge 4 ]]; then
	7	rm -f /srv/backup/daily/`ls -t /srv/backup/daily/ \| tail -n1`
	8	fi
8145dbcc	9	fi