#!/bin/bash
DUMP=/usr/bin/mysqldump
OUT_DIR=/public/mysqldump
DB_USER=root
DB_PASSWD='*************'
DATE=`date +%F`
DAYS=31
DB1=dispatch_db
DB2=imee_portal
DB3=workflow_wf
if [ ! -d "$OUT_DIR" ];then
mkdir -p "$OUT_DIR"
fi
cd $OUT_DIR
echo "`date +%F` `date +%H:%M:%S` dump start" >> $OUT_DIR/dump.log
for i in $DB1 $DB2 $DB3
do
$DUMP -u$DB_USER -p$DB_PASSWD --skip-opt --single-transaction --databases $i >$i$DATE.sql
done
if [ $? -eq 0 ];then
for i in $DB1$DATE.sql $DB2$DATE.sql $DB3$DATE.sql
do
tar -zvcf $i.tar.gz $i
done
echo "`date +%H:%M:%S` dump success" >> $OUT_DIR/dump.log
else
echo "`date +%H:%M:%S` dump error" >> $OUT_DIR/dump.log
fi
find $OUT_DIR -name "*.gz" -type f -mtime +$DAYS -exec rm {} \;
rm -f $OUT_DIR/*.sql