AutoGallery SQL - Utilities



AutoGallery SQL - Utilities











Important Notes
The
utilities included with the software are considered experimental, and you
will be using them at your own risk. They are not an official part of the
software at this time, and are not yet fully supported by the tech support
staff. These tools are intended for advanced users who understand how to
use the command line interface of a Unix system. By using these utilities
you acknowledge that you will be doing so at your own risk, and will be
responsbile for your own troubleshooting should you run into problems.








Link Checking Utility
The
linkcheck utility is still in development, and will be completed in a
future release of the beta version.







Backup Utility


Open the backup file from the software zip file, set the $CDIR
variable, and make sure the correct Perl path appears at the top of the
file. You can then upload it to your server in ASCII mode to the same
directory as agp.pl. Set the permissions on the backup file to 755.

You can now telnet or SSH into your server and change into the
directory where you uploaded the backup file.
There are two options for naming your backup files. You can either
have the data backed up to the same file all the time, or you can create
a seperate backup file for each day that the backup function is run.
Either way, the data file will always be created in your data directory.


./backup data.txt Using this command will always backup
your data to the data.txt file. You can choose whatever filename you
want, just replace data.txt with the file you want the data stored in.

./backup If you leave the filename off the end, each time
the backup function is run it will create a filename based on the
current date. For example, it will create a file named 10-01-2001.txt
for the backup that was run on October 1st of 2001.
Once you execute either of the above commands, the backup will be
run. You can then retrieve the backup datafile from the data directory
and download it to your local computer in ASCII mode for safe keeping.

To use this tool with cron, all you need to do is setup a crontab
entry with the full path to the backup file as the command. It is
expected that you know how to use cron and setup crontab entries. An
example crontab entry would be: 0 0 * * *
/home/username/public_html/cgi-bin/tgp/backup This would run the
backup command once a day at midnight, and create a backup filename
based on the current date.