#!/bin/sh
find /home/backup -type f -ctime +30 -name "*.sql.gz" -exec rm {} \; -print
mysqldump --defaults-extra-file=/home/backup_scripts/mysql.cfg dozor --default-character-set=utf8 --ignore-table=dozor.addr --ignore-table=dozor.addr_type | gzip -c > `date +%y%m%d`.sql.gz
if ! [ -d /home/backup/Db/`date +20%y` ]; then
mkdir /home/backup/Db/`date +20%y`/
fi
if ! [ -d /home/backup/Db/`date +20%y`/`date +%m` ]; then
mkdir /home/backup/Db/`date +20%y`/`date +%m`/
fi
mv `date +%y%m%d`.sql.gz /home/backup/Db/`date +20%y`/`date +%m`