#!/bin/bash
# Name:bakmysql.sh
# This is a ShellScript For Auto DB Backup and Delete old Backup
#
backupdir=/bak/path //备份到的目录
time=` date +%Y%m%d%H `
/phpstudy/mysql/bin/mysqldump -uusername -p123456 -h127.0.0.1 db | gzip > $backupdir/bakname$time.sql.gz //压缩文件
#
find $backupdir -name "bakname*.sql.gz" -type f -mtime +5 -exec rm {} \; > /dev/null 2>&1 //保存留最近5天的备份文件删除之前文件
# Name:bakmysql.sh
# This is a ShellScript For Auto DB Backup and Delete old Backup
#
backupdir=/bak/path //备份到的目录
time=` date +%Y%m%d%H `
/phpstudy/mysql/bin/mysqldump -uusername -p123456 -h127.0.0.1 db | gzip > $backupdir/bakname$time.sql.gz //压缩文件
#
find $backupdir -name "bakname*.sql.gz" -type f -mtime +5 -exec rm {} \; > /dev/null 2>&1 //保存留最近5天的备份文件删除之前文件