#!/bin/sh # Backup db by evan at 20160927 # # Script config User="user" Password="passwd" Basedir=/application/mysql/bin Dump="$Basedir/mysqldump -u$User -p$Password" Backup_dir="/data/mysql/3306/backup" #database="test_db_v0_1" # Slave stop sql_thread $Basedir/mysql -u$User -p$Password -e "stop slave sql_thread;" # Backup [ ! -d $Backup_dir ] && /bin/mkdir -p $Backup_dir #$Dump -B -R -x --master-data=2 $database|gzip >$Backup_dir/$(date +%F -d -1day)_${database}.sql.gz 2>>${Backup_dir}_error.log /usr/bin/innobackupex --defaults-file=/etc/my.cnf --user=$User --password=$Password $Backup_dir 2>>$Backup_dir/`date +%F`_backup_error.log # Slave start sql_thread $Basedir/mysql -u$User -p$Password -e "start slave sql_thread;" # Clear Backup /usr/bin/find $Backup_dir -type d -mtime +7 -name "20*"|xargs /usr/bin/rm -fr