#!/bin/bash
backtime=`date +%Y%m%d`
echo "时间为 ${backtime}"
cd /home/test/
mkdir -p backup/${backtime}
cd /home/test/mysql
./bin/mysqldump -uroot -p123456 -P3306 --socket=./tmp/mysql.sock --set-gtid-purged=OFF --databases test1 >/home/test/backup/${backtime}/test1 .sql #备份数据库
./bin/mysqldump -uroot -p123456 -P3306 --socket=./tmp/mysql.sock --set-gtid-purged=OFF --databases test2>/home/test/backup/${backtime}/test2.sql
./bin/mysqldump -uroot -p123456 -P3306 --socket=./tmp/mysql.sock --set-gtid-purged=OFF --databases test3>/home/test/backup/${backtime}/test3.sql
./bin/mysqldump -uroot -p123456 -P3306 --socket=./tmp/mysql.sock --set-gtid-purged=OFF --databases test4 >/home/test/backup/${backtime}/test4 .sql
find /home/test/backup/logs/* -name "*" -mtime +14 | xargs rm -rf #删除日志