#!/bin/bash ### Writer Tian ### Backup mysql all database ### At 20190626 ## That variable DATE=`date +%Y-%m-%d_%H-%M-%S` user="root" passwd="123456" data_bak="/backup/db" ## Create backup files if [ ! -d ${data_bak} ];then mkdir -p ${data_bak} fi echo "database start time:" `date "+%F %H:%M:%S"`>>$data_bak/`date "+%Y%m%d"`_time.txt ## Back mysql all sql fiels innobackupex --defaults-file=/etc/my.cnf --user=${user} --password=${passwd} -S /tmp/mysql.sock --compress --parallel=4 --throttle=400 ${data_bak} 2>> ${data_bak}/${DATE}_info.log ## Clear sql all cd ${data_bak} tar -czvf ${DATE}.tar.gz ${DATE} >>${data_bak}/tar_`date "+%Y%m%d_%H%M%S"`.txt rm -rf ${DATE} echo "database end time:" `date "+%F %H:%M:%S"`>>$data_bak/`date "+%Y%m%d"`_time.txt ###dell-->90day--log_bak find $data_bak/* -type d -mtime +90 |xargs rm -rf exit 0
Innobackupex 备份脚本
原创tianyu_7903 博主文章分类:linux centos ©著作权
文章标签 Innobackupex 备份脚本 文章分类 运维
-
MySQL 8自动备份脚本密码安全警告
作者:田逸(formyz)目标需求接到一个任务,需要在凌晨四点对一个数据库进行备
mysql v8 MySQL -
vscode+extendscript编写ps文件自动备份脚本
ps文件自动备份
json javascript Photoshop extendscript 文件备份 -
mysql 增量备份的脚本 (innobackupex)
数据库,mysql innobackupex
数据库 mysql innobackupex -
innobackupex备份
innobackupex
innobackupex