msyql 自动 备份
!/bin/bash
./etc/profile
.~/.bash_profile
source /etc/profile
备份路径
BACKUP=/www/backup/mysql
当前时间
DATETIME=\((date +%Y-%m-%d) echo "===备份开始===" echo "备份文件存放于\){BACKUP}/\(DATABASE-\)DATETIME.sql"
数据库地址
HOST=127.0.0.1
数据库用户名
DB_USER=root
数据库密码
DB_PW=JmNetwork@2022
创建备份目录
[ ! -d "\({BACKUP}/\)DATETIME" ] && mkdir -p "\({BACKUP}/\)DATETIME"
后台系统数据库
DATABASE=jm_grid
echo \(DATABASE-\)DATETIME
mysqldump -u\({DB_USER} -p\){DB_PW} --single-transaction --host=$HOST -q -R --databases $DATABASE | gzip > \({BACKUP}/\)DATETIME/$DATABASE.sql
mysqldump -h 127.0.0.1 -u\({DB_USER} -p\){DB_PW} \({DATABASE} >\){BACKUP}/\(DATABASE-\)DATETIME.sql
echo "=导出成功，开始传输="
压缩成tar.gz包
cd $BACKUP
tar -zcvf $DATETIME.tar.gz $DATETIME
备份到服务器B
scp \(DATABASE-\)DATETIME.sql root@10.160.59.40:/opt/data/backup
删除备份目录
rm -rf \({BACKUP}/\)DATETIME
删除10天前备份的数据，这边可以自行更改
find $BACKUP -mtime +10 -name "*.sql" -exec rm -rf {} ;
echo "=数据库备份到服务器成功="
===================
[root@node1 ~]# ssh-keygen -t rsa
ssh-copy-id -i IP
===================#!/bin/bash
./etc/profile
.~/.bash_profile
source /etc/profile
备份路径
BACKUP=/opt/databackup
当前时间
DATETIME=$(date +%Y-%m-%d)
DATETIME=\((date +%Y-%m-%d-%H-%M) echo "===备份开始===" echo "备份文件存放于\){BACKUP}/\(DATABASE-\)DATETIME.sql"
数据库地址
HOST=127.0.0.1
数据库用户名
DB_USER=root
数据库密码
DB_PW=JmNetwork@2022
创建备份目录
[ ! -d "\({BACKUP}/\)DATETIME" ] && mkdir -p "\({BACKUP}/\)DATETIME"
后台系统数据库
DATABASE=jm_grid
echo \(DATABASE-\)DATETIME
mysqldump -u\({DB_USER} -p\){DB_PW} --single-transaction --host=$HOST -q -R --databases $DATABASE | gzip > \({BACKUP}/\)DATETIME/$DATABASE.sql
mysqldump -h 127.0.0.1 -u\({DB_USER} -p\){DB_PW} \({DATABASE} >\){BACKUP}/\(DATABASE-\)DATETIME.sql
echo "=导出成功，开始传输="
压缩成tar.gz包
cd $BACKUP
tar -zcvf $DATETIME.tar.gz \(DATABASE-\)DATETIME.sql
备份到服务器B
scp \(DATABASE-\)DATETIME.sql root@172.29.113.38:/data/backup
删除备份目录
rm -rf \({BACKUP}/\)DATETIME
删除3天前备份的数据，这边可以自行更改
find $BACKUP -mtime +3 -name "*.sql" -exec rm -rf {} ;
echo "=数据库备份到服务器成功="=================
