git clone https://github.com/luckman666/mysqlBackUp.git
chmod +x /XXXXXX/mysqlBackup.sh
crontab -e
00 03 * * * /XXXXXX/mysqlBackup.sh
恢复
mysql -u username -p databse < backup.sql

mysql_user="root" #MySQL备份用户
mysql_password="root123." #MySQL备份用户的密码
mysql_host="localhost"
mysql_port="3306"
mysql_charset="utf8" #MySQL编码
backup_db_arr=("peabox&quot #要备份的数据库名称，多个用空格分开隔开 如("db1" "db2" "db3&quot
backup_location=/resource_bak/mysqlBack #备份数据存放位置，末尾请不要带"/",此项可以保持默认，程序会自动创建文件夹
expire_backup_delete="ON" #是否开启过期备份删除 ON为开启 OFF为关闭
expire_days=3 #过期时间天数 默认为三天，此项只有在expire_backup_delete开启时有效