备份脚本参考如下
#!/bin/bash
#可修改如下参数
backup_filename=$(date +%Y%m%d%H%M%S)
backup_tmp_dir=/data/backup/mysql/
user=数据库登录用户名
passwd=数据库密码
databse=需要备份的数据库
#备份
function data() {
/usr/local/mysql/bin/mysqldump -u$user -p$passwd -h127.0.0.1 --single-transaction --databases $databse > ${backup_tmp_dir}/db_${databse}_${backup_filename}.sql
}
function package(){
#打包文件
cd ${backup_tmp_dir}
tar zcf db_${databse}_${backup_filename}.sql.tar.gz db_${databse}_${backup_filename}.sql
find ./ -name "*.sql" -exec rm -rf {} \;
}
data
package
#大于30天备份文件则执行删除
find $backup_tmp_dir -type f -mtime +30 -exec rm -rf {} \;
加入定时任务参考如下
0 */6 * * * /data/script/mysql_backup.sh
最近升级BT宝塔后,发现无法自动备份数据库至七牛云,发现报'NoneType' object has no attribute 'backup_path',分析代码后找到如下解决方法/www/server/panel/class/panelBackup.py找到self._cloud = cloud_object(大概在100行左右)写成为self._cloud = None重启宝塔后报 Fil