#!/bin/bash DB_USER=root DB_PASSWD="" #需要备份的数据库名 DATABASES="bigamer bigamer_ucenter bigamer_anwsion bigamer_passport" BACKUP_DIR="/home/backup/mysql/" DATE=`date '+%Y%m%d'` DUMPFILE=$DATE.sql ARCHIVEFILE=$DUMPFILE.tar.gz DUMP_ARGS="-u $DB_USER -p $DB_PASSWD --add-drop-table --add-drop-database -B $DATABASES" DUMP_BIN=`which mysqldump` if [ ! -d $BACKUP_DIR ]; then mkdir -p "$BACKUP_DIR" fi cd $BACKUP_DIR $DUMP_BIN $DUMP_ARGS > $DUMPFILE if [[ $? == 0 ]]; then tar czf $ARCHIVEFILE $DUMPFILE rm -f $DUMPFILE fi #清理五天前备份的数据 find $BACKUP_DIR -name "*.sql.tar.gz" -type f -mtime +5 -exec rm {} \; > /dev/null 2>&1 echo "Backup Process Done"
Monthly Archives: June 2012
定时备份mysql数据
Posted by wolftankk
on 2012/06/26
No comments