Just a simple bash script I use to backup the Mayan installation at work to 
my laptop.  It creates a sub directory based on the date under the 
MOUNT_POINT you specify after that does a complete database and document 
storage copy.


#!/bin/sh
MOUNT_POINT=/home/rosarior/data_disk/ogpe-backup/mayan/backups
MAYAN_SERVER=172.16.1.196
DATE=`date +%Y%m%d`
BACKUP_DIRECTORY="$MOUNT_POINT/$DATE"
REMOTE_SSH_USERNAME=rosarior
REMOTE_MYSQL_USERNAME=root
REMOTE_MYSQL_DATABASE=mayan

echo "Backup directory: $BACKUP_DIRECTORY"
mkdir -p $BACKUP_DIRECTORY

echo -n  "Running mysqldump..."
mysqldump --host=$MAYAN_SERVER -u $REMOTE_MYSQL_USERNAME -p 
$REMOTE_MYSQL_DATABASE > $BACKUP_DIRECTORY/mayan.sql
echo "mysqldump finished."

echo -n "Running rsync..."
rsync -avz --delete --progress -e ssh 
$REMOTE_SSH_USERNAME@$MAYAN_SERVER:/var/local/mayan/document_storage/ 
$BACKUP_DIRECTORY/document_storage/
echo "rsync finished."

echo "Backup complete."

-- 



Reply via email to