- #! /bin/sh
- fulldir=$1
- #全备份路径
- batch=${fulldir##*use_}
- backupdir=/mnt/cosfs/backups_xtrabackup
- batchincdir=$backupdir/inc_$batch
- if [ ! -d "$batchincdir" ]; then
- mkdir $batchincdir
- echo $batchincdir
- fi
- incdir=$batchincdir/incremental_`date +%Y%m%d%H%M%S`
- db_user=root
- db_pass=zhonghui0123
- days=7
- xtrabackup --user=$db_user --password=$db_pass --backup --incremental-basedir=$fulldir --target-dir=$incdir
- find $batchincdir -name incremental_'*' -type d -mtime +7 -exec rm -rf {} \;
|
