#!/bin/sh

cd /home/vps100824855/classicharley.jp/

ts_now=`date +%Y%m%d`

bk_days=2
ts_old=`date "-d$bk_days days ago" +%Y%m%d`

mysqldump --user=vps100824855 --password=Turbo930770 vps10082_MYP >/home/vps100824855/classicharley.jp/db_$ts_now.sql
tar cvzf /home/vps100824855/classicharley.jp/db_$ts_now.tgz /home/vps100824855/classicharley.jp/db_$ts_now.sql

sh dropbox_uploader2.sh upload /home/vps100824855/classicharley.jp/manager/count.dat /backup/count$ts_now.txt

sh dropbox_uploader2.sh delete /backup/count$ts_old.txt

sh dropbox_uploader2.sh upload /home/vps100824855/classicharley.jp/db_$ts_now.tgz /backup/db_$ts_now.tgz

sh dropbox_uploader2.sh delete /backup/db_$ts_old.tgz

rm -f db_$ts_old.tgz
rm -f db_$ts_now.sql

echo "SQL Data backup end"