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.
Subject Author Views Date
Post linksql automated local and remote backup implementation cefs99 1238 Jun 23, 2005, 7:22 AM