#!/bin/sh.
#Backup server options
server=11.11.11.111
user=user
key=/path/key.key
port=22222
backup_dir=/path/
#Archive options
date=`date +%F`
arc_name=arc_$date
tar_dir=/path
data="/var/www/ /etc"
days=22
logfile=/var/log/backup.log
admin=admin@domain.com
#Database options
mysql_u=user
mysql_p=password
databases=database
#Encryption options
gpg_key=email
mysqldump --add-drop-table -u $mysql_u -p$mysql_p $databases > $tar_dir/$date.db 2>>$logfile &&
tar czf - --exclude={*.tar.gz,*.sql} --ignore-failed-read $tar_dir/$date.db $data > $tar_dir/$arc_name.tar.gz | gpg -e -r $gpg_key > $arc_name-$date.tar.gz.gpg 2>>$logfile
/usr/bin/scp -P $port -i $key $tar_dir/$arc_name.tar.gz.gpg $user@$server:$backup_dir 2>>$logfile &&
find $tar_dir -mtime +$days -exec rm {} \; 2>>$logfile &&
echo "$date - Backup successfull" >> $logfile ||
echo "There are some problems with backup on $arc_name" | mail -s "Backup: $arc_name problems" $admin
Backup data and databases to windows share folder
This small script encrypts and backups data and mysql databases to windows share using CIFS protocol. It also logs it's operations and sends notifications to administrator in case of problems.
#!/bin/sh
#CIFS server options
server=
folder=
user=
pass=
domain=DOMAIN
#Logs and notifications options
admin=Administrator e-mail
logfile=/var/log/backup.log
#Encryption options
key=GPG public key ID
#Archive options
arc_name=The name of archive
backup_dir=where to store database copies
data="what files and directories to backup"
mountpoint=/mnt/backup days=10 - how many days to store archives
date=`date +%d-%m-%Y` - date format
#Mysql options
databases="database1 database2"
mysql_user=root
mysql_pass=root
mount.cifs //$server/$folder $mountpoint -ouser=$user,pass=$pass domain=$domain 2>>$logfile &&
/usr/bin/mysqlhotcopy --addtodest --user=$mysql_user --password=$mysql_pass $databases $backup_dir/db 2>>$logfile &&
/usr/bin/mysqlhotcopy --addtodest --user=$mysql_user --password=$mysql_pass $databases $backup_dir/db 2>>$logfile &&
tar czf - $data $backup_dir/db | gpg -e -r $key > $mountpoint/$arc_name-$date.tar.gz.gpg 2>>$logfile &&
find $mountpoint -mtime +$days -exec rm {} \; 2>>$logfile &&
find $mountpoint -mtime +$days -exec rm {} \; 2>>$logfile &&
umount -f $mountpoint 2>>$logfile ||
echo "There are some problems with backup on $arc_name" | mail -s "$arc_name backup problems" $admin
