MySQL の時系列バックアップを自動で作成するシェルスクリプト

#!/bin/bash # config backup_parent_dir=~/backup rootpass=xxxxxxxxxxxxxxxx retention_period=10 # dir setting backup_dir=`date +%Y-%m-%d` remove_dir=`date "-d$retention_period days ago" +%Y-%m-%d` mkdir -p $backup_parent_dir/$backup_dir rm -rf $backup_parent_dir/$remove_dir # backup dblist=`ls -p /var/lib/mysql | grep / | tr -d /` for dbname in $dblist do if [ $dbname != "mysql" -a $dbname != "perfo