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.
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.