scp实现 增量备份 mysql数据库
聂文龙发表于 2016-11-19 04:54:00
1.先实现scp,拷贝不需要密码。然后在考虑增量备份
假设A，B两服务器，现在需要在A机上用root登陆B机，而不需要输入密码，那我们可按照下面的步骤来做：
1）在A机上生成钥匙对,执行以下命令：
ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/root/.ssh/id_rsa): /root/.ssh/id_rsa
Enter passphrase (empty for no passphrase):直接回车
Enter same passphrase again:直接回车
Your identification has been saved in /root/.ssh/id_rsa.
Your public key has been saved in /root/.ssh/id_rsa.pub.
The key fingerprint is:
f6:61:a8:27:35:cf:4c:6d:13:22:70:cf:4c:c8:a0:23 root@host1
这样，在/root/.ssh/路径下会生成id_rsa，和id_rsa.pub，其中id_rsa是密钥，id_rsa.pub是公钥。
2）把在A机生成的id_rsa.pub拷贝到B机上，假设拷贝到B机的临时目录下，如：
scp /root/.ssh/id_rsa.pub root@192.168.1.22:/tmp
3）用root帐号登陆B机，进入其主目录，创建authorized_keys文件，并设置好权限。
cd ~/.ssh
cat /tmp/id_rsa.pub >>authorized_keys
chmod400 authorized_keys
rm -f /tmp/id_rsa.pub
4）重新打开A的链接窗口，命令行下输入
ssh 192.168.1.22
就可以看到直接进入了。
2.mysql备份数据库的脚本
only_mysql.sh脚本内容如下
MY_USER="root"
MY_PASS="123456"
MY_HOST="localhost"
MY_CONN="-u $MY_USER -p$MY_PASS -h$MY_HOST"
MY_DB1="discuz"
BF_DIR="/root/sqlback/"
BF_CMD="/usr/bin/mysqldump"
#BF_TIME=`date +%Y%m%d-%H%M`
BF_TIME=`date +%Y%m%d`
NAME_1="$MY_DB1-$BF_TIME"
cd $BF_DIR/
$BF_CMD $MY_CONN --databases $MY_DB1 > $NAME_1.sql
/bin/tar zcf $NAME_1.tar.gz $NAME_1.sql --remove &> /dev/null
scp.sh脚本如下内容“
@import url(http://www.cppblog.com/CuteSoft_Client/CuteEditor/Load.ashx?type=style&file=SyntaxHighlighter.css);@import url(/css/cuteeditor.css);MY_DB1="discuz"
BF_TIME=`date +%Y%m%d`
NAME_1="$MY_DB1-$BF_TIME"
/usr/bin/scp /root/sqlback/$NAME_1.tar.gz 192.168.1.22:/root/sqlback/
4.添加到任务计划，搞定！