mysql数据库备份脚本==>环境lampp

#!/bin/bash
#数据库定时备份，并将备份的库进行打包压缩
#create_user:liyongning
#create_time:2019/6/5
#
user=root
passwd='hfwstPwd!@#'
back_path=/data/mysql/backup
data_name=vst_rent
date=`date +%Y%m%d`

mkdir -p $back_path/$date
/opt/lampp/bin/mysqldump -u$user -p$passwd $data_name |gzip > $back_path/$date/$data_name.sql.gz

说明:

基础备份功能,其他功能尚需完善! 共勉~