1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
#!/bin/bash
DBUSER=root
DBPASSWD=123456
DBBAK1=mysql_test
BACKUPDIR1=
/data/backup_v2/mysql_test
BACKTIME=`
date
+%Y%m%d%H%M%S`
if
[ ! -d $BACKUPDIR1 ];
then
mkdir
$BACKUPDIR1
fi
echo
"==========$BACKTIME 数据库$DBBAK1备份开始=========="
>> $BACKUPDIR1
/mysql_test
.log
cd
$BACKUPDIR1
mysqldump --opt -R --triggers -E --lock-all-tables --flush-logs --master-data=2 -u$DBUSER -p$DBPASSWD --databases $DBBAK1 > $DBBAK1.$BACKTIME.sql 2>> $BACKUPDIR1
/mysql_test
.log
if
[ $?==0 ];
then
tar
zcf $DBBAK1.$BACKTIME.
tar
.gz $DBBAK1.$BACKTIME.sql >
/dev/null
rm
-f $BACKUPDIR1/$DBBAK1.$BACKTIME.sql
echo
-e
"=========数据库$DBBAK1 备份成功!!=========\n"
>> $BACKUPDIR1
/mysql_test
.log
else
echo
-e
"=========数据库$DBBAK1 备份失败!!=========\n"
>> $BACKUPDIR1
/mysql_test
.log
fi
find
/data/backup_v2/mysql_test/
-mtime +10 -delete
本文转自激情燃烧的岁月博客51CTO博客,原文链接http://blog.51cto.com/liuzhengwei521/1909887如需转载请自行联系原作者 weilovepan520
|
mysql或者mariadb备份脚本
最新推荐文章于 2023-12-06 21:07:21 发布