#!/bin/bash

# How to use
# my_script_name bd_user db_pass project_name(should be same name on database and project_directory)
# by Alfredo Ribeiro: alfredo@aatecnologia.com.br
# Create the daily backup, delete old backups, and each month, make a copy last backup on a separated directory
# Is need create a directory month inside your backup directory

mysql_user=$1
mysql_pass=$2
project_name=$3

suffix=$(date +%Y%m%d)
last_day_on_month=$(cal `date '+%m'` `date '+%Y'` | grep . | fmt -1 | tail -1)
today=$(date +%d)
month_bkp=$(date +%Y-%B)
host=127.0.0.1

if [ ! -d /tmp/mysql ]; then
  mkdir /tmp/mysql
fi

if [ -d /home/user/bkps/month ]; then
  mkdir -p /home/user/bkps/month
fi

mysqldump --opt -u$mysql_user -p$mysql_pass -h $host  $project_name > /tmp/mysql/$project_name.$suffix.sql
tar -cvzf /tmp/$project_name-db-$suffix.tar.gz /tmp/mysql
if [ $today -eq $last_day_on_month ]; then
  mv /tmp/$project_name-db-$suffix.tar.gz month/$project_name-db-$month_bkp.tar.gz
fi

rm -rf /tmp/mysql

#remove files with more than 10 days
find /home/user/bkps/ -ctime +10 -exec rm -rf {} \;