mysql ubuntu远程备份

1：安装 mysqldump
 

sudo apt-get install mysql-client

2：新建sh文件 mysql_bak.sh

#!/bin/bash
# Name:mysql_bak.sh
# This is a ShellScript For Auto DB Backup and Delete old Backup
#备份地址
backupdir=/home/ubuntu/online/db_back/data
#备份文件后缀时间
time=_`date +%Y_%m_%d_%H_%M_%S`
#需要备份的数据库名称
db_name=jewelry_db
#mysql 用户名
db_user=root_rds
#mysql 密码
db_pass=qwer^rds@2018
mysqldump -u $db_user -h 172.27.0.13 -p$db_pass --single-transaction  $db_name | gzip > $backupdir/$db_name$time.sql.gz
#删除五天之前的备份文件
find $backupdir -name $db_name"*.sql.gz" -type f -mtime +5 -exec rm -rf {} \; > /dev/null 2>&1

3:设置定时任务

sudo vi /etc/crontab

// 末尾添加

0 2 * * * /home/ubuntu/online/db_back/mysql_bak.sh >> /home/ubuntu/online/db_back/deal_log.log 2>&1

 

获取更多帮主请关注小程序