note_sql/backup.sh

#!/bin/bash


PROJECT_DIR=/home/xjf/workspace/docker/laradock/
CUR_FILE_DIR=$(dirname $(readlink -f $0))
LOG_NAME='err.log'
LOG="$CUR_FILE_DIR/$LOG_NAME"
PRE_DIR=`pwd`
day=`date +%"d"`
if [ `expr $day % 2` == 0 ]; then
    echo "even day, do nothing" > $LOG
    exit
fi
cd $PROJECT_DIR
docker-compose exec mysql mysqldump --extended-insert=FALSE --complete-insert=TRUE -uroot -proot -hlocalhost -P3036 audiopay > $CUR_FILE_DIR/note.sql
#git add draw.sql
#git commit draw.sql -m "[`date`]" 2> $LOG
#git push origin master:master 2> $LOG

cd $PRE_DIR