sites/default/files/backup_migrate/scheduled/。#!/bin/bash
cd /www/web/html
drush cron
# 清理 SVN 狀態中缺失的檔案
svn st sites/default/files/backup_migrate/scheduled/ | grep '^!' | awk '{print $2}' | xargs svn delete --force
# 新增備份檔
svn add sites/default/files/backup_migrate/scheduled/*
svn ci sites/default/files/backup_migrate/scheduled/ -m "add backup files $(date +%F)"
0 0 * * * cd /www/web/html && bash cron.sh > cron.log 2>&1
優點:零成本、版本可回溯、備份份數可控。缺點:SVN 不適合大檔案,單庫超過 500MB 建議改用 MySQL 專用備份。
mysqldump --single-transaction + gzip 壓縮。/backup/mysql/Y/m/d/H-i-s/dbname.sql.gz。<?php
#!/usr/bin/php -q
$to = "admin@example.com";
$hostname = exec('hostname');
$mycnf = "/home/backup/.my.cnf"; // [client] user=... password=...
$ignore = ['information_schema','test','mysql','performance_schema'];
if (!file_exists($mycnf)) { mail($to, "No .my.cnf on $hostname", "Missing creds"); exit; }
$cnf = file_get_contents($mycnf);
preg_match('/user\s*=\s*(\S+)/', $cnf, $m); $user = trim($m[1]);
preg_match('/password\s*=\s*(\S+)/', $cnf, $m); $pass = trim($m[1]);
$mysqli = new mysqli("localhost", $user, $pass, "mysql");
if ($mysqli->connect_errno) { mail($to, "Connect failed on $hostname", $mysqli->connect_error); exit; }
$bpath = "/home/backup/mysql";
$dt = new DateTime();
$dir = sprintf("%s/%04d/%02d/%02d/%s", $bpath, $dt->format('Y'), $dt->format('m'), $dt->format('d'), $dt->format('H-i-s'));
$res = $mysqli->query("SHOW DATABASES");
while ($row = $res->fetch_array()) {
$db = $row[0];
if (in_array($db, $ignore)) continue;
@mkdir("$dir/$db", 0700, true);
$cmd = sprintf(
"cd %s && mysqldump -u%s -p%s --single-transaction --add-drop-table -R -c -Q %s > %s.sql && gzip -9 %s.sql",
"$dir/$db", $user, $pass, $db, $db, $db
);
echo "Backing up $db...\n";
system($cmd, $ret);
if ($ret !== 0) mail($to, "Backup failed: $db on $hostname", "Command: $cmd");
}
chmod("$bpath/{$dt->format('Y')}", 0700);
echo "Backups in $bpath\n";
0 1 * * * /home/backup/bin/mysql_backup.php
rsync -avz /home/backup/mysql/ user@offsite:/backup/mysql/aws s3 sync、阿里雲 ossutil sync。| 維度 | 小站 | 大站 |
|---|---|---|
| 工具 | Backup Migrate + SVN | PHP/Shell + mysqldump + rsync |
| 備份粒度 | 全站(含檔案) | 單庫單檔 |
| 存儲 | SVN 倉庫 | 本地磁碟 + 異地雲端 |
| 恢復速度 | 分鐘級 | 視庫大小而定(可並行導入) |
| 監控 | Cron 日誌人工查看 | 郵件告警 + 監控系統 |
「沒有演練過的備份,不算備份。」每季必須進行一次全量恢復演練,驗證 RTO/RPO。