lightweight/sqlite-backup
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity
A script which performs backups of an SQLite database on the local filesystem or in a Docker container and maintains dated backup instances as defined in its configuration, e.g. 24 hourly, 7 daily, 4 weekly, 12 monthly, and 7 yearly backups.
8 commits 1 branch 0 tags 31 KiB
Shell 100%
Find a file
Dave Lane 4eec9fbcf9 added a MAIN_DIR variable, and tweaked the conf sample and cron files to reflect how this is deployed in practice
2021-08-19 05:16:01 +00:00
.gitignore initial commit of working script 2020-02-13 15:44:12 +13:00
LICENSE Add LICENSE 2020-02-13 02:41:58 +00:00
README.md updated README's installation instructions 2020-02-14 11:03:09 +13:00
sqlite_backup added a MAIN_DIR variable, and tweaked the conf sample and cron files to reflect how this is deployed in practice 2021-08-19 05:16:01 +00:00
sqlite_backup-cron added a MAIN_DIR variable, and tweaked the conf sample and cron files to reflect how this is deployed in practice 2021-08-19 05:16:01 +00:00
sqlite_backup.conf-sample added a MAIN_DIR variable, and tweaked the conf sample and cron files to reflect how this is deployed in practice 2021-08-19 05:16:01 +00:00

README.md

SQLite Backup

A script which performs backups of an SQLite database on the local filesystem or in a Docker container and maintains dated backup instances as defined in its configuration, e.g. 24 hourly, 7 daily, 4 weekly, 12 monthly, and 7 yearly backups.

This script assumes you're running SQLite 3 (which is commonly available).

Installation

There are 3 components to this script:

  1. the backup BASH script itself, which has all the smarts,
  2. a sample of the .conf configuration file which defines the file paths and other details specific to your installation - like where the SQLite database actually is, or where to put the backup files - and
  3. a cron file which runs the script automatically when you tell it to run on your server.

To install:

  • ensure the SQLite database client is installed on your system: sudo apt install sqlite3
  • copy the code (either via a .zip or .tgz archive or via git clone git@git.oeru.org:dave/sqlite-backup.git onto the computer where you want to do the backups (uncompress it, of course, if required).
  • go into the directory cd sqlite-backup and create a copy of the configuration file: cp sqlite_backup.conf-sample sqlite_backup.conf
  • edit the sqlite_backup.conf file to set your values for BU_DIR, BU_FROOT, DB_DIR, DB_FILE, EMAIL, and EMAIL_SUBJ (to send email your server will need to be configured to send email) and DC_DIR and DC_CONT if desired.
  • make sure the directories you've specified above exist. If any of them doesn't, create it via sudo mkdir -p full/path/you/specified.
  • although it should already be executable (run ls -l sqlite_backup which should look like this: -rwxrwxr-x 1 youruser youruser 5769 Feb 13 17:13 sqlite_backup - if you have r-- or rw- without the "x", you need to make sure the sqlite_backup script is executable: chmod a+x sqlite_backup - you may need to add sudo chmod a+x sqlite_backup
  • edit sqlite_backup-cron to set the path to your script and adjust the timing if you like. Then copy it to /etc/cron.d by running sudo cp sqlite_backup-cron /etc/cron.d and it should "just work" at the appointed times.

You can test to make sure it works by running (from the script directory) ./sqlite_backup --hourly and it should create an hourly backup in the directory you designated as BU_DIR with a filename starting with BU_FROOT.