Re: Backup problems

John Pritchard-Williams (jpw@oasis.icl.co.uk) wrote: : I need to be : able to backup the database (since I have only one database) overnight, is : there a better way thann simply unloading everything and saving the datasbase : in ascii format ? Yes, there is. Just write a HERE-script to fake the required input of tbtape: ## Begin of HERE script tbtape -s << ENDE 0 ENDE ## End of HERE script You MUST include the empty line, it is the <RETURN> that tbtape expects after the "Please mount tape..." message. The "0" is the required backup level, you can, of course, substitute 1 or 2 for it if that's the level you want. For reliable unattended backups, you have to make sure that the correct tape is inserted in the drive. If your script is run by cron, you also have to take care of the correct environment (TBCONFIG etc.). Hope this helps, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3421 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+