定时自动备份mysql

=`date +%Y-%m-%d_%H:%M:%S` Pass=‘VHlrakBNeVNRTDNlZGMkUkZW‘ #加密解密密码，避免报错insecure function decrypt_passwd { tmp_pass=$1 dec_pass=`echo $tmp_pass|base64 -d` } decrypt_passwd $Pass echo $DATE echo ‘备份数据库‘ /usr/bin/mysqldump -uroot -p$dec_pass --opt kidcloud > /usr/local/kidcloud/mysqlBackup/kidcloud_$DATE.sql

#!/bin/sh
DATE=`date +%Y-%m-%d_%H:%M:%S`
mysql_config_editor set --login-path=local --host=localhost --user=db_user --password
echo $DATE
echo ‘备份数据库‘
/usr/bin/mysqldump --login-path=local --opt kidcloud > /usr/local/kidcloud/mysqlBackup/kidcloud_$DATE.sql

 

定时自动备份mysql

标签：解密   decrypt   sql   tor   ase   脚本   bin   cloud   bsp