#!/bin/sh

cd /var/www/vhosts/classicharley.jp/httpdocs/

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

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

mysqldump --user=myp-yokohama --password=Turbo930 MYP > /var/www/vhosts/classicharley.jp/httpdocs/db_$ts_now.sql
tar cvzf /var/www/vhosts/classicharley.jp/httpdocs/db_$ts_now.tgz /var/www/vhosts/classicharley.jp/httpdocs/db_$ts_now.sql

sh dropbox_uploader.sh upload /var/www/vhosts/classicharley.jp/httpdocs/manager/count.dat /backup/count$ts_now.txt

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

sh dropbox_uploader.sh upload /var/www/vhosts/classicharley.jp/httpdocs/db_$ts_now.tgz /backup/db_$ts_now.tgz

sh dropbox_uploader.sh delete /backup/db_$ts_old.tgz
sh dropbox_uploader.sh delete /backup/count$ts_old.txt

#php auto_j.php
#php auto_us.php
#php auto.php
#php auto_s.php

python ./sitemap_gen.py --config=config.xml

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

echo "Data backup & Sitemap end"

  /usr/sbin/sendmail zin.mizuno@gmail.com<<EOF
BackUp and Sitemap end the scripts.
EOF