sqlite-backup/sqlite_backup-cron

SHELL=/bin/sh
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin

#
# run system backups
#
# hourly - at 5 minutes past mon-sat
05 * * * * root cd /home/data/[bw_dir]/scripts/sqlite-backup && ./sqlite_backup --hourly 
#
# daily - at 7:30 pm, mon-sat
30 19 * * * root /home/data/[bw_dir]/scripts/sqlite-backup && ./sqlite_backup --daily
#
# weekly - at 7:30 pm, sun
30 19 * * sun root /home/data/[bw_dir]/scripts/sqlite-backup && ./sqlite_backup --weekly
#
# monthly - at 8:30 pm, on the first of the last of the month
30 20 1 * * root /home/data/[bw_dir]/scripts/sqlite-backup && ./sqlite_backup --monthly
#
# yearly - at 8:30 pm, on the first of January.
30 20 1 1 * root /home/data/[bw_dir]/scripts/sqlite-backup && ./sqlite_backup --yearly
initial commit of working script 2020-02-13 15:44:12 +13:00			`SHELL=/bin/sh`
			`PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin`
improved README and removed problematic shell variables (which don't work on all systems) from the cron script 2020-02-13 18:17:25 +13:00
initial commit of working script 2020-02-13 15:44:12 +13:00			`#`
			`# run system backups`
			`#`
			`# hourly - at 5 minutes past mon-sat`
added a MAIN_DIR variable, and tweaked the conf sample and cron files to reflect how this is deployed in practice 2021-08-19 17:16:01 +12:00			`05 * * * * root cd /home/data/[bw_dir]/scripts/sqlite-backup && ./sqlite_backup --hourly`
initial commit of working script 2020-02-13 15:44:12 +13:00			`#`
			`# daily - at 7:30 pm, mon-sat`
added a MAIN_DIR variable, and tweaked the conf sample and cron files to reflect how this is deployed in practice 2021-08-19 17:16:01 +12:00			`30 19 * * * root /home/data/[bw_dir]/scripts/sqlite-backup && ./sqlite_backup --daily`
initial commit of working script 2020-02-13 15:44:12 +13:00			`#`
			`# weekly - at 7:30 pm, sun`
added a MAIN_DIR variable, and tweaked the conf sample and cron files to reflect how this is deployed in practice 2021-08-19 17:16:01 +12:00			`30 19 * * sun root /home/data/[bw_dir]/scripts/sqlite-backup && ./sqlite_backup --weekly`
initial commit of working script 2020-02-13 15:44:12 +13:00			`#`
			`# monthly - at 8:30 pm, on the first of the last of the month`
added a MAIN_DIR variable, and tweaked the conf sample and cron files to reflect how this is deployed in practice 2021-08-19 17:16:01 +12:00			`30 20 1 * * root /home/data/[bw_dir]/scripts/sqlite-backup && ./sqlite_backup --monthly`
initial commit of working script 2020-02-13 15:44:12 +13:00			`#`
			`# yearly - at 8:30 pm, on the first of January.`
added a MAIN_DIR variable, and tweaked the conf sample and cron files to reflect how this is deployed in practice 2021-08-19 17:16:01 +12:00			`30 20 1 1 * root /home/data/[bw_dir]/scripts/sqlite-backup && ./sqlite_backup --yearly`