Automatic Database Backup

In environments where high availability architecture is being used, automatic backups are performed during Cron runs.


By default, automatic database backups are enabled with the following configuration: 

  • Daily backups are stored in the following directory:  .../scratch/autobackups/
  • Backups are maintained for the last 15 days before being overwritten with new backups

The auto backup function requires the Cron function to be working properly.

Cron is a requirement for FileCloud Server in general, so you should already have this service running.

If you have not done this yet, Set up Cron.


As an administrator, you can change the location where backups are stored, the number of backups to maintain, and the number of days between backups. Or, if you already have a back-up strategy, you can disable automatic backups.

To configure automatic database backups:

  1. In the FileCloud admin portal's left navigation bar, scroll down and click Settings. Then, on the Settings navigation page, click Misc .
    By default, General settings are opened.
  2. Scroll down to the backup settings and modify them depending on your system's needs.


    Disable automatic database backup - Enable to prevent database back up during a Cron run. When disabled, automatic backup runs, and the last automatic backup run date is displayed.

    Database backup storage path - The path to the directory where backed-up database files are saved. You must use a path that is accessible to the FileCloud server, can have files saved to it, and has enough room for the backup files

    Number of backups to store -The number of days you want stored in a single backup file. By default, each backup file contains 15 days worth of data. If you want smaller files, you can lower this number. For example, if you type in 2 for Number of backups to store, the backup file will only contain 2 days worth of data. After those 2 days, the backup file is overwritten to store the next 2 days worth of data. This setting controls how far back you can recover data.

    Database backup Interval - The interval in days between each backup. The default is 0 which creates a daily backup of the number of days set in Number of backups to store.
  3. Click Save.

Example

The Cherry Road Real Estate company needs to back up data from the last 30 days and wants the back-up refreshed every week. To do this, these are the settings they use:

  • Disable automatic database backup = not selected
  • Database backup storage path = /var/scratch/autobackups
  • Number of backups to store = 30 
  • Database backup Interval = 7