#!/bin/sh
LOCAL_DB="maryanne_joomla"
LOCAL_USER="maryanne_joomla"
LOCAL_PASS="D7BB95F4AD"
LOCAL_HOST="127.0.0.1"
ME=maryanne
#####################
HERE=/home/$ME/
BACK=$HERE/back/
CMD="cd $BACK"
echo $CMD
eval $CMD
MYSQL="$(which mysql)"
MYSQLDUMP="$(which mysqldump)"
#####################
OF=$BACK$LOCAL_DB.$(date +%Y%b%d%H%M%S).sql
CMD="$MYSQLDUMP --lock-tables --add-drop-table -h'$LOCAL_HOST' -u'$LOCAL_USER' -p'$LOCAL_PASS' $LOCAL_DB"
echo $CMD
eval $CMD > $OF
OFGZ=$OF.tar.gz
CMD="tar -czf $OFGZ $OF"
echo $CMD
eval $CMD
CMD="rm $OF"
echo $CMD
eval $CMD
CMD="find $BACK -name '*sql.tar.gz' -mtime +14 -exec ls -l {} \;"
echo $CMD
eval $CMD
CMD="find $BACK -name '*sql.tar.gz' -mtime +14 -exec rm {} \;"
echo $CMD
eval $CMD
CMD="find $BACK -name '*sql' -mtime +14 -exec ls -l {} \;"
echo $CMD
eval $CMD
CMD="find $BACK -name '*sql' -mtime +14 -exec rm {} \;"
echo $CMD
eval $CMD