{"id":28,"date":"2012-09-24T00:55:00","date_gmt":"2012-09-24T00:55:00","guid":{"rendered":"https:\/\/robertrath.com\/gadgetzone\/archives\/28-backing-up-the-raspberry-pi-blog.html"},"modified":"2012-09-24T00:55:00","modified_gmt":"2012-09-24T00:55:00","slug":"backing-up-the-raspberry-pi-blog","status":"publish","type":"post","link":"https:\/\/robertrath.com\/gadgetzone\/archives\/28-backing-up-the-raspberry-pi-blog.html","title":{"rendered":"Backing Up the Raspberry Pi Blog"},"content":{"rendered":"It would be a shame to lose everything I have put into the Raspberry Pi blog so it’s time to put in a backup regime.
\n
\n\"\"
\n
\nStrategy<\/strong>
\n
\nThe Raspberry Pi blog is located both both ‘\/var\/www\/raspberrypi\/’ and in the serendipity-db catalog of the local MySQL database. We will need to backup up both to completely cover ourselves.
\n
\nThe strategy for backup will be to make archives of both the filesystem and the mysql database, archive them together and then copy to the network drive under a unique filename. The backup will be run from a script which which will live in the ‘\/var\/www’ directory and be regularly run from an entry in the ‘\/etc\/crontab’ file.
\n
\nDuring the backup process I will create temporary files on the network drive to avoid wear on the local SD card.
\n
\nWe first setup NFS or SAMBA networking and ensure we have mounted our network storage device at a suitable mount point. I have chosen NFS in this example. To use Windows networking adapt the instructions below accordingly.
\n
\n1. Install NFS client (checked already installed as part of the Weezy distribution).
\n2. Make a mount point for backups at ‘\/var\/www\/backup’ and add edit ‘\/etc\/rc.local’ to mount our external resource on boot by adding the following line ‘mount -t nfs -o nolock [IP address or hostname of your NAS server]:\/var\/local\/www \/var\/www\/backup’
\n
\n
\nBackup Script<\/strong>
\n
\nHere is my script. Note the use of the file ‘\/var\/www\/backup\/sync_www’ to ensure we have mounted the network drive and are not just working with our local mount point.
\n
\n
#!\/bin\/sh
\n
\nif [ -e \/var\/www\/backup\/sync_www ]; then
\n
\n mkdir -p \/var\/www\/backup\/raspberrypi\/
\n cd \/var\/www\/
\n tar –exclude-vcs -czf .\/backup\/raspberrypi\/raspberrypi-www_`date +%y_%m_%d`.gz raspberrypi && \\
\n mysqldump -u YOUR_MYSQL_USERNAME_HERE -pYOUR_MYSQL_PASSWORD_HERE serendipity-db | gzip > .\/backup\/raspberrypi\/raspberrypi-mysqldump_`date +%y_%m_%d`.gz && \\
\n tar –remove -cf .\/backup\/raspberrypi\/raspberrypi-blog_`date +%y_%m_%d`.tar .\/backup\/raspberrypi\/raspberrypi-www_`date +%y_%m_%d`.gz .\/backup\/raspberrypi\/raspberrypi-mysqldump_`date +%y_%m_%d`.gz
\n
\n exit 0
\n
\nelse
\n
\n exit 1
\n
\nfi
\n<\/blockquote>
\n
\nA brief description pf the steps of the script are as follows
\n
\n1. Check to see we have mounted the network drive by looking for a file called ‘sync-www’ which we have alread place on the network drive.
\n2. Create our target backup directory if it does not already exist.
\n3. Change to the ‘\/var\/www\/’ as our working directory.
\n4. Create a dated temporary archive of the files in ‘\/var\/www\/raspberypi’
\n5. Create a dated temporary archive of the mysql data dumped from the catalog ‘serendipity-db’
\n6. Create the final backup archive removing the temporary working files.
\n
\n
\nHandling Erorrs<\/strong>
\n
\nNote the use of ‘&& \\’ after each line ensures that the next line only executes if the previous command was successful otherwise the script exits with error code 1.
\n
\nNote this script could be further enhanced with email notifications of success or failure as needed.
\n
\n
\nScheduling<\/strong>
\n
\nFinally the following entry in ‘\/etc\/crontab’ will ensure this script runs daily at 2:30 am.
\n
\n
’30 2 <\/strong> * root \/var\/www\/backup-www.sh &’<\/blockquote>
\n
\n
\n … Robert
\n
\n
\n","protected":false},"excerpt":{"rendered":"

It would be a shame to lose everything I have put into the Raspberry Pi blog so it’s time to put in a backup regime. Strategy The Raspberry Pi blog is located both both ‘\/var\/www\/raspberrypi\/’ and in the serendipity-db catalog of the local MySQL database. We will need to backup up both to completely cover … Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-28","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/robertrath.com\/gadgetzone\/wp-json\/wp\/v2\/posts\/28","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/robertrath.com\/gadgetzone\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/robertrath.com\/gadgetzone\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/robertrath.com\/gadgetzone\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/robertrath.com\/gadgetzone\/wp-json\/wp\/v2\/comments?post=28"}],"version-history":[{"count":0,"href":"https:\/\/robertrath.com\/gadgetzone\/wp-json\/wp\/v2\/posts\/28\/revisions"}],"wp:attachment":[{"href":"https:\/\/robertrath.com\/gadgetzone\/wp-json\/wp\/v2\/media?parent=28"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/robertrath.com\/gadgetzone\/wp-json\/wp\/v2\/categories?post=28"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/robertrath.com\/gadgetzone\/wp-json\/wp\/v2\/tags?post=28"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}