#!/bin/bash
# Courtesy of Gord Falk

rm /usr/schools/cornerstone/admin/download/*
rm /usr/schools/cornerstone/tadmin/download/*

checkdate=`date | awk '{print $1}'`

case "$checkdate"
in
Sun)
rm /backup/sunday/*
date=`date -I`; mysqldump --opt --all-databases -u root --password="<PASSWORD>"
 > /backup/sunday/db_backup-$date.sql
;;
Mon)
rm /backup/monday/*
date=`date -I`; mysqldump --opt --all-databases -u root --password="<PASSWORD>"
 > /backup/monday/db_backup-$date.sql
;;
Tue)
rm /backup/tuesday/*
date=`date -I`; mysqldump --opt --all-databases -u root --password="<PASSWORD>"
 > /backup/tuesday/db_backup-$date.sql
;;
Wed)
rm /backup/wednesday/*
date=`date -I`; mysqldump --opt --all-databases -u root --password="<PASSWORD>"
 > /backup/wednesday/db_backup-$date.sql
;;
Thu)
rm /backup/thursday/*
date=`date -I`; mysqldump --opt --all-databases -u root --password="<PASSWORD>"
 > /backup/thursday/db_backup-$date.sql
;;
Fri)
rm /backup/friday/*
date=`date -I`; mysqldump --opt --all-databases -u root --password="<PASSWORD>"
 > /backup/friday/db_backup-$date.sql
;;
Sat)
rm /backup/saturday/*
date=`date -I`; mysqldump --opt --all-databases -u root --password="<PASSWORD>"
 > /backup/saturday/db_backup-$date.sql
;;

esac