mysqldump 备份脚本

#!/bin/bash

DUMP=/usr/bin/mysqldump
OUT_DIR=/home/mysql

LINUX_USER=root

DB_NAME=snale

DB_USER=root 

DB_PASS=password
DB_HOST=127.0.0.1

DAYS=7

cd $OUT_DIR 

DATE=`date +%Y_%m_%d` 

OUT_SQL="$DATE.sql" 

TAR_SQL="mysqldata_bak_$DATE.tar.gz" 

$DUMP -u$DB_USER -h $DB_HOST -p$DB_PASS $DB_NAME --default-character-set=utf8 --opt -Q -R --skip-lock-tables> $OUT_SQL 

tar -czf $TAR_SQL ./$OUT_SQL 

rm $OUT_SQL 

chown $LINUX_USER:$LINUX_USER $OUT_DIR/$TAR_SQL

find $OUT_DIR -name "mysqldata_bak*" -type f -mtime +$DAYS -exec rm {} \;