Good Luck and remember that we offer convenient install and support services.
Backing up your data is one of those highly important and extremely mundane things that must be done. Here I will show you a fairly painless, low cost method to backup your SQL Ledger data to an outside location in the event that something happens to the computer where your data resides.
Login to the admin section of your SQL Ledger Install (http://yourdomain.com/sql-ledger/admin.pl.
Create an email account at a third party site such as gmail, yahoo, etc. **This is not secure. In the future we will create a way to encrypt your emails.
You should now create a user entitled backup. Give the user access to nothing except for 1) System 2) Backup and 3) Backup--Send by E-Mail.
For the users email address enter the one you created above.
Login via the command line and create a file called backup.sh The file contains the following:
#!/bin/sh cd /home/users/sqlledger ./am.pl "path=bin/lynx&action=backup&level=System--Backup--Send%2520by%2520E-Mail&login=backup&password=PASSWORD&media=email"
type 'chmod +x backup.sh'
Now for the last part. We are going to add this to cron so that it runs on a recurring basis. If you had followed my instructions previously you would have created a special user just for SQL Ledger. su to that user.
type crontab -e
type i
type * 0 * * * /path/to/sqlledger/backup.sh
type 'esc', then ':' then 'w' then 'q'
You are all set now. Remember to check your email and confirm that you indeed can restore your data from the backup.
Trackback URL for this post:
http://inetws.net/trackback/7
