#!/bin/bash
source /etc/profile
TODAY_DIR=`date +%Y%m%d`;
Olddir=`date +%Y%m%d --date='7 days ago'`;
cd /home/database_backup/
if [ -f $Olddir ]; then
rm -rf $Olddir
fi
if [ ! -d $TODAY_DIR ]; then
mkdir -p $TODAY_DIR/dbname
fi
mysqldump -uroot -ppassword --single-transaction --master-data=2 dbname> $TODAY_DIR/dbname/dbname_${TODAY_DIR}.sql
mysqldump -uroot -ppassword -h192.168.2.168 -P3306 -n -d -t -R dbname> $TODAY_DIR/dbname/dbname_proc${TODAY_DIR}.sql
source /etc/profile
TODAY_DIR=`date +%Y%m%d`;
Olddir=`date +%Y%m%d --date='7 days ago'`;
cd /home/database_backup/
if [ -f $Olddir ]; then
rm -rf $Olddir
fi
if [ ! -d $TODAY_DIR ]; then
mkdir -p $TODAY_DIR/dbname
fi
mysqldump -uroot -ppassword --single-transaction --master-data=2 dbname> $TODAY_DIR/dbname/dbname_${TODAY_DIR}.sql
mysqldump -uroot -ppassword -h192.168.2.168 -P3306 -n -d -t -R dbname> $TODAY_DIR/dbname/dbname_proc${TODAY_DIR}.sql