mysql remote backup

# more /data/backup/mysql_bak_eachdb.sh 
#!/bin/sh
MYUSER=root
MYPASS='Password'
#SOCKET=/var/lib/mysql/mysql.sock
MYLOGIN="/usr/local/mysql/bin/mysql -u$MYUSER -p$MYPASS -h192.168.0.154"
MYDUMP="/usr/local/mysql/bin/mysqldump -h192.168.0.154 -u$MYUSER -p$MYPASS  -B -R --single-transaction --triggers "
DATABASE="$($MYLOGIN -e "show databases;"|egrep -v "Data|_schema|mysql|sys|test")"
 
for dbname in $DATABASE
  do
   MYDIR=/data/backup/remotebk1921680153/$dbname
   [ ! -d $MYDIR ] && mkdir -p $MYDIR
 $MYDUMP --log-error=$MYDIR/${dbname}_$(date +%F).err $dbname|gzip >$MYDIR/${dbname}_$(date +%F).sql.gz
done

find /data/backup/remotebk1921680153/ -mtime +7 -type f  -name "*.sql.gz"  -exec rm -f {} \;
find /data/backup/remotebk1921680153/ -mtime +7 -type f  -name "*.err"  -exec rm -f {} \;
#find /data/backup/remotebk1921680153/ -mtime +7 -type f  -name "*.sql.gz"   -exec rm -f {} \;

复制