How to backup redmine?
Database:
/usr/bin/mysqldump -u <username> -p <password> <redmine_database> | gzip > /path/to/backup/db/redmine_`date +%y_%m_%d`.gz
Attachments:
rsync -a /path/to/redmine/files /path/to/backup/files
How to restore redmine?
Restore the database:
mysql --user=root --password=rootpassword redmine_production < ./db/mysql_20130914.sql
Restore files:
cp -r /path/to/backup/files /path/to/redmine/files
Script to synchronize data:
#/bin/sh
SSH_BIN="/usr/bin/ssh"
IP_REDMINE_SERVER="AAA.BBB.CCC.DDD"
THE_SOURCE="root@$IP_REDMINE_SERVER:/opt/redmine/files"
THE_DESTINATION="/opt/redmine"
rsync --rsync-path=/usr/bin/rsync --delete -azogpvvO -e "$SSH_BIN" $THE_SOURCE $THE_DESTINATION