gnusocial backup

###################
### 0. Setup ssh authorized_keys on your server so you don't need a password

###################
### 1. cronjob this script on the gnusocial server.

#/bin/bash

datestamp=`date +'%Y-%m-%d'`
mysqldump --hex-blob gnusocial | gzip > /home/mysql-backup/gnusocial-$datestamp.sql.gz

rm /home/mysql-backup/latest-gnusocial.sql.gz
ln -s /home/mysql-backup/gnusocial-$datestamp.sql.gz /home/mysql-backup/latest-gnusocial.sql.gz

#maintain only the latest 5 copies on the server
cd /home/mysql-backup
ls -1tr gnusocial*gz | head -n -5 | xargs -d '\n' rm -f

###################
### 2. run this script on your PC

#!/bin/bash

zenity --question --text "Backup gnusocial ?";
if [ $? -eq 0 ]
then
        datestamp=`date +'%Y-%m-%d'`
        scp a_user@my_server.net:/home/mysql-backup/latest-gnusocial.sql.gz ~/gnusocial-backup/gnusocial-$datestamp.sql.gz
        if [ -f ~/gnusocial-backup/gnusocial-$datestamp.sql.gz ]
        then
                zenity --info --text "Copied mysql dump"
        fi
        rsync -az -e "ssh -p 22" a_user@my_server.net:/var/www/gnusocial/file ~/gnusocial-backup/
        rsync -az -e "ssh -p 22" a_user@my_server.net:/var/www/gnusocial/avatar ~/gnusocial-backup/
        zenity --info --text "rsync files finished"
fi