mysqldump/pg_dump 資料庫備份。# Debian/Ubuntu
apt-get install backup-manager
# 互動式詢問備份儲存目錄與來源目錄,可跳過後續手動編輯
# CentOS/RHEL (需 EPEL)
yum install backup-manager
/etc/backup-manager.conf (關鍵變數)export BM_ARCHIVE_METHOD="tarball mysql"
export BM_REPOSITORY_ROOT="/var/archives"
export BM_TARBALL_NAMEFORMAT="long"
export BM_TARBALL_FILETYPE="tar.gz"
export BM_TARBALL_DIRECTORIES="/etc /home /var/log"
export BM_TARBALL_BLACKLIST="/var/log/myotherapp.log *.mp3 *.mp4"
export BM_MYSQL_DATABASES="mysql mybase wordpress dotclear phpbb2"
export BM_MYSQL_ADMINLOGIN="root"
export BM_MYSQL_ADMINPASS="mypassword"
export BM_MYSQL_SAFEDUMPS="true"
export BM_MYSQL_HOST="localhost"
export BM_MYSQL_PORT="3306"
export BM_MYSQL_FILETYPE="gzip"
export BM_TARBALL_OVER_SSH="false"
export BM_UPLOAD_SSH_USER="root"
export BM_UPLOAD_SSH_KEY="/root/.ssh/id_rsa"
export BM_UPLOAD_SSH_HOSTS="dev1 dev3"
export BM_UPLOAD_SSH_DESTINATION="/var/archives/backups/$HOSTNAME"
backup-manager -v # 逐步顯示
# 產生 tarball 至 BM_REPOSITORY_ROOT,再經 SSH 上傳至 dev1、dev3
# MySQL 密碼寫入 ~/.backup-manager_my.cnf 供 mysqldump 讀取,避免命令列洩露



crontab -e
# 每週日 05:15 執行
15 5 * * 0 /usr/sbin/backup-manager > /dev/null 2>&1
延伸: 手冊含更多部署範例 (如 S3、GPG 加密流程),建議閱讀 man backup-manager。