innobackupex-mysql备份-全备和增量

原创 ONE 2020-09-18

940

#!/bin/bash
###mysql备份
host=127.0.0.1
user=bkpuser
pwd=bkpuser
dir=/home/mysql/XtraBackup
log=backuplog.date +%Y%m%d
day=date +%w
dt=date +%Y%m%d
lastday=date -d '1 days ago' +%Y%m%d
case $day in
```
0)  
```
```
    # Sunday Full backup
```

    # find $dir/ -name "xtra_*" -mtime +6 -exec rm -rf {} \;

    innobackupex --defaults-file=/etc/my.cnf  --host=$host --user=$user --password=$pwd --no-timestamp $dir/xtra_base_$dt > $dir/log/$log 2>&1

```
    ;;  
```
```
1)  
```

    # Monday Relatively Sunday's incremental backup

    innobackupex --defaults-file=/etc/my.cnf  --host=$host --user=$user --password=$pwd  --no-timestamp  --incremental $dir/xtra_inc_$dt --incremental-basedir=$dir/xtra_base_$lastday > $dir/log/$log 2>&1

```
    ;;  
```
```
2)  
```

    # Tuesday Compared with Monday's incremental backup

    innobackupex --defaults-file=/etc/my.cnf  --host=$host --user=$user --password=$pwd  --no-timestamp  --incremental $dir/xtra_inc_$dt --incremental-basedir=$dir/xtra_inc_$lastday > $dir/log/$log 2>&1

```
    ;;  
```
```
3)  
```
```
    # Wednesday Full backup
```

    find $dir/ -name "xtra_*" -mtime +6 -exec rm -rf {} \;

    innobackupex --defaults-file=/etc/my.cnf  --host=$host --user=$user --password=$pwd --no-timestamp $dir/xtra_base_$dt > $dir/log/$log 2>&1

```
    ;;  
```
```
4)  
```

    # Thursday  Relatively Wednesday's incremental backup

    innobackupex --defaults-file=/etc/my.cnf  --host=$host --user=$user --password=$pwd  --no-timestamp  --incremental  $dir/xtra_inc_$dt --incremental-basedir=$dir/xtra_base_$lastday > $dir/log/$log 2>&1

```
    ;;  
```
```
5)  
```

    # Friday Compared with Thursday's incremental backup

    innobackupex --defaults-file=/etc/my.cnf  --host=$host --user=$user --password=$pwd  --no-timestamp  --incremental  $dir/xtra_inc_$dt --incremental-basedir=$dir/xtra_inc_$lastday > $dir/log/$log 2>&1

```
    ;;  
```
```
6)  
```

    # Saturday Compared with Friday's incremental backup

    innobackupex --defaults-file=/etc/my.cnf  --host=$host --user=$user --password=$pwd  --no-timestamp  --incremental  $dir/xtra_inc_$dt --incremental-basedir=$dir/xtra_inc_$lastday > $dir/log/$log 2>&1

```
    ;;  
```
esac
find $dir/log/ -mtime +6 -type f -name ‘backuplog.*’ -exec rm -rf {} ;

mysql linux

最后修改时间：2023-08-24 11:07:28

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

innobackupex-mysql备份-全备和增量

评论