Mysql备份数据库到另一台服务器

#!/bin/bash
echo ===============================执行时间 `date +%F-%H-%M-%S` starting
#!/bin/sh
# mysql_backup.sh: backup mysql databases and keep newest 5 days backup.
#
# Last updated: 2017Ū8Ղ8ɕ
# ----------------------------------------------------------------------
# This is a free shell script under GNU GPL version 2.0 or above
# Copyright (C) 翰翰
# mysql 数据备份
# ----------------------------------------------------------------------
# mysql安装目录/usr/local/mysql/
# mysql启动命令service mysqld start
# -----------------------------


#declare
MKDIR="/bin/mkdir"
RM="/bin/rm"
MV="/bin/mv"
GZIP="/bin/gzip"


#file path
db_user="root"
db_passwd="root@2019"
db_host="10.164.153.72"
# 备份目录
backup_dir="/data/pgm"
# 获取当前时间
time="$(date +"%Y-%m-%d-%H-%M")"
# mysql, mysqldump and some other bin's path
MYSQLDUMP="/usr/local/mysql/bin/mysqldump"
# check the directory for store backup is writeable
test ! -w $backup_dir && echo "Error: $backup_dir is un-writeable." && exit 0


# 备份的数据库名称
db="test"
$MYSQLDUMP -u $db_user -h $db_host -p$db_passwd $db | $GZIP -9 > "$backup_dir/$time.$db.gz"


#发送备份文件到另一台服务器
scp -r $backup_dir/$time.$db.gz chy@10.164.153.73:/data/mysql-back-up/
exit 0;

#发送完成之后删除数据库服务器中的文件
find /data/pgm/ -mtime +1 -name "*.gz" -exec rm -rf {} \;

echo ===============================执行时间 `date +%F-%H-%M-%S` ending

解压缩命令为：gunzip -c mysql.sql.gz

如何实现两台服务器的免登录，参考上一篇文章地址为：https://blog.csdn.net/pobasoft2012/article/details/116236981

如果是window下创建的sh文件，在linux系统下执行时会提示错误信息，需要修改文件类型doc为unix类型。