linux mysql备份内网scp无密码传输
实现目标机器A无密码自动拷贝机器B(目标机器)上的mysql备份文件：
首先在A机器上生产密钥，运行：
ssh-keygen -t rsa
输入ssh-keygen -t rsa之后全部默认回车，这样就会在/root/.ssh下生成密钥文件
建信任关系：
拷贝A的 id_rsa.pub到机器B的authorized_keys文件中
自动备份及传输脚本
#!/bin/bash # This is a ShellScript For Auto DB Backup and Delete old Backup #database name name=t_base dir=/alidata/backup/t_v3/$name/ mkdir -p $dir #backup file time time=_`date +%Y_%m%d_%H%M` #mysql user user=root #mysql password pass=123456 #mysqldump -u$user -h 127.0.0.1 -P 3306 -p$pass --single-transaction $name > $dir$name$time.sql mysqldump -u$user -p$pass --master-data=2 $name > $dir$name$time.sql #Delete data 14 days ago find $dir -name "$name_*.sql" -type f -mtime +14 -exec rm {} \; > /dev/null 2>&1 #copy database cd $dir scp -P 22 $dir$name$time.sql root@192.168.1.130:$dir
示例：
scp -r -P 2307 root@192.168.1.130:/alidata/backup/data/hlyun4.0/hlyun_v4_oms/hlyun_v4_oms_2022_0415_0218.sql /alidata/server/mysqldata/hlyun_v3/
加入定时任务
vi /etc/crontab
SHELL=/bin/bash PATH=/sbin:/bin:/usr/sbin:/usr/bin MAILTO=root # For details see man 4 crontabs # Example of job definition: # .---------------- minute (0 - 59) # | .------------- hour (0 - 23) # | | .---------- day of month (1 - 31) # | | | .------- month (1 - 12) OR jan,feb,mar,apr ... # | | | | .---- day of week (0 - 6) (Sunday=0 or 7) OR sun,mon,tue,wed,thu,fri,sat # | | | | | # * * * * * user-name command to be executed 1 1 * * * root sh /alidata/backup/shell/hlyun3.0/hlyun_v3_center.sh 3 1 * * * root sh /alidata/backup/shell/hlyun3.0/hlyun_v3_crm.sh 6 1 * * * root sh /alidata/backup/shell/hlyun3.0/hlyun_v3_fms.sh 10 1 * * * root sh /alidata/backup/shell/hlyun3.0/hlyun_v3_srm.sh
