Gossamer Forum
Home : Products : Gossamer Links : Discussions :

linksql automated local and remote backup implementation

Quote Reply
linksql automated local and remote backup implementation
Something to share, hope find valuable:) A cheap solution for people without Tape, RAID etc to backup database data:

1.script to auto dump linksql data from database, gzip it and send as email attachment to free 1G email

#!/bin/bash
_date=`date +%m%d%k%M`
/usr/local/httpd-2.0.54/cgi-bin/test1/admin/nph-import.cgi --backup --source=/usr/local/httpd-2.0.54/cgi-bin/test1/admin/defs --destination=/opt/backup/test1-`echo $_date`.dat --error-file=/opt/backup/err_backup.log --critical-warnings
gzip /opt/backup/test1-`echo $_date`.dat
echo "Backup test1 successfully"
perl /opt/backup/nduo_maildata.pl -s /opt/backup/test1-`echo $_date`.dat.gz -u test_backup@gmail.com,test_backup@yahoo.com -f /opt/backup/test1-`echo $_date`.dat.gz


2.script to send any file as email attachment from command line:

https://www.redhat.com/archives/fedora-list/2004-May/msg02178.html

then you can create crontab to automatically dump your linksql data, gzip and send backup copy anywhere in the world.