Firebird Cron Backup

Created by: Lester Caine, Last modification: 11 Oct 2012 (20:36 BST)

Thanks to Pierre Yager we have a tidy cron script that provides an automated backup function for the active firebird databases. This has been modified for use with the bitweaver setup and stores the last 5 backups in the storage area of the site that the database relates to. The normal practice is to locate everything in the /srv directory of a linux installation. A /db subdirectory is used to hold the databse itself, with subdirectories for each site, and an alias is established pointing here, mapping the site name to the database. /srv/db/<site>/<site>.fdb is used to marry up with a site located as /srv/website/<site>, and the backups will be located in the storage/backup folder of the website folders. This then allows the site to be rsynced with a backup location. This would normally happen on a daily basis.

What we still need to do is work out how to get the cron jobs to run at a particular time rather than randomly based on when cron was started.

firebird-backup is a copy of the script.

Detailed notes on how it works to be added, but basically the line backup <site> simply needs to be added to the file to add an additional database.