#!/bin/bash
Mysql_Host=‘192.168.1.100’
Mysql_User=‘root’
Mysql_Pwd=‘123qqq…A’
Mysql_Port=‘3306’
Mysql_Base=‘aaa’ #要备份的数据库名
backup_dir=’/home/backup’ #备份文件存放位置
date_time=date +%Y-%m-%d
#备份时间,用来做文件名
[ ! -d
b
a
c
k
u
p
d
i
r
/
{backup_dir}/
backupdir/{date_time} ] && mkdir -p
b
a
c
k
u
p
d
i
r
/
{backup_dir}/
backupdir/{date_time} #判断文件夹是否存在,否则创建
mysqldump -h
M
y
s
q
l
H
o
s
t
−
u
{Mysql_Host} -u
MysqlHost−u{Mysql_User} -p
M
y
s
q
l
P
w
d
−
P
{Mysql_Pwd} -P
MysqlPwd−P{Mysql_Port} ${Mysql_Base} >
b
a
c
k
u
p
d
i
r
/
{backup_dir}/
backupdir/{date_time}.sql
cd ${backup_dir}
tar -czf ${date_time}.tar.gz
b
a
c
k
u
p
d
i
r
/
{backup_dir}/
backupdir/{date_time}.sql
rm -rf ${date_time}.sql
find ${backup_dir} -mtime +10 -name “*.sql” exec rm -rf {} ; #找出10天前的备份文件并删除