From a322cf88f3c52eaea275b105a1bd5a4a3c57ea34 Mon Sep 17 00:00:00 2001
From: Tom Hughes <tom@compton.nu>
Date: Sun, 23 Jun 2013 19:07:05 +0100
Subject: [PATCH] Bring blog backup script under chef control

---
 cookbooks/foundation/recipes/default.rb        |  8 ++++++++
 .../templates/default/backup.cron.erb          | 18 ++++++++++++++++++
 2 files changed, 26 insertions(+)
 create mode 100644 cookbooks/foundation/templates/default/backup.cron.erb

diff --git a/cookbooks/foundation/recipes/default.rb b/cookbooks/foundation/recipes/default.rb
index 7b1fa1d05..2f9b98849 100644
--- a/cookbooks/foundation/recipes/default.rb
+++ b/cookbooks/foundation/recipes/default.rb
@@ -48,3 +48,11 @@ wordpress_plugin "sitepress-multilingual-cms" do
   site "blog.osmfoundation.org"
   source "plugins/sitepress-multilingual-cms"
 end
+
+template "/etc/cron.daily/blog-backup" do
+  source "backup.cron.erb"
+  owner "root"
+  group "root"
+  mode 0750
+  variable :passwords => passwords
+end
diff --git a/cookbooks/foundation/templates/default/backup.cron.erb b/cookbooks/foundation/templates/default/backup.cron.erb
new file mode 100644
index 000000000..6ab8a63e2
--- /dev/null
+++ b/cookbooks/foundation/templates/default/backup.cron.erb
@@ -0,0 +1,18 @@
+#!/bin/sh
+
+# DO NOT EDIT - This file is being maintained by Chef
+
+T=$(mktemp -d -t -p /var/tmp osm-blog.XXXXXXXXXX)
+D=$(date +%Y-%m-%d)
+B=osm-blog-$D.tar.gz
+
+mkdir $T/osm-blog-$D
+mysqldump --user=osm-blog-user --password=<%= @passwords["osmf-blog-user"] %> --opt osm-blog > $T/osm-blog-$D/osm-blog.sql
+ln -s /srv/blog.openstreetmap.org $T/osm-blog-$D/www
+
+export GZIP="--rsyncable -9"
+
+nice tar --create --gzip --dereference --directory=$T --file=$T/$B osm-blog-$D
+nice rsync $T/$B backup::backup
+
+rm -rf $T
-- 
2.43.2