4.MySQL排除系统数据库自动化备份-mydumper

vi mydump_bak.sh 

#! /usr/bin/bash
Date=`date +%Y%m%d`
echo $Date-备份
rm -rf /backup/mybak-${Date}.tar.gz 
rm -rf /backup/mybak-${Date}
mkdir -p /backup/mybak-$Date
mydumper -u root -p root -R -G -E --regex '^(?!(mysql|sys|performance_schema|information_schema))'  -o /backup/mybak-$Date/
tar -zcvf /backup/mybak-${Date}.tar.gz /backup/mybak-$Date

#find ./ -name mybak-* -exec rm -rf {}\;