Skip to content

Setup a crobjob to backup the Index database #49

Closed
Closed
Setup a crobjob to backup the Index database#49
Labels
- Admin -Enjoyable to Install and Setup our SoftwareQuality & AssuranceRelates to QA, Testing, and CI

Description

@josecelano
josecelano
opened on May 9, 2025

We have a weekly backup configured in Digital Ocean for the droplet:

Image

Generating an Index DB backup daily on the same server would be good. It looks like I did it, but it's not working now. It stopped working on December 11th. Maybe I decided to disable it because I enabled the droplet backup (perhaps the disk was smaller then).

total 17G
drwxrwxr-x 2 torrust torrust  20K May  9 07:54 .
drwxr-x--- 9 torrust torrust 4.0K May  9 07:45 ..
-rwxr-x--- 1 root    root    1.7M Dec  3 13:00 backup_2024-12-03_13-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  3 14:00 backup_2024-12-03_14-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  3 15:00 backup_2024-12-03_15-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  3 16:00 backup_2024-12-03_16-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  3 17:00 backup_2024-12-03_17-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  3 18:00 backup_2024-12-03_18-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  3 19:00 backup_2024-12-03_19-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  3 20:00 backup_2024-12-03_20-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  3 21:00 backup_2024-12-03_21-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  3 22:00 backup_2024-12-03_22-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  3 23:00 backup_2024-12-03_23-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 00:00 backup_2024-12-04_00-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 01:00 backup_2024-12-04_01-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 02:00 backup_2024-12-04_02-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 03:00 backup_2024-12-04_03-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 04:00 backup_2024-12-04_04-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 05:00 backup_2024-12-04_05-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 06:00 backup_2024-12-04_06-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 07:00 backup_2024-12-04_07-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 08:00 backup_2024-12-04_08-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 09:00 backup_2024-12-04_09-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 10:00 backup_2024-12-04_10-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 11:00 backup_2024-12-04_11-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 12:00 backup_2024-12-04_12-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 13:00 backup_2024-12-04_13-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 14:00 backup_2024-12-04_14-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 15:00 backup_2024-12-04_15-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 16:00 backup_2024-12-04_16-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 17:00 backup_2024-12-04_17-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 18:00 backup_2024-12-04_18-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 19:00 backup_2024-12-04_19-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 20:00 backup_2024-12-04_20-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 21:00 backup_2024-12-04_21-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 22:00 backup_2024-12-04_22-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  4 23:00 backup_2024-12-04_23-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 00:00 backup_2024-12-05_00-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 01:00 backup_2024-12-05_01-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 02:00 backup_2024-12-05_02-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 03:00 backup_2024-12-05_03-00-02.db
-rwxr-x--- 1 root    root    1.7M Dec  5 04:00 backup_2024-12-05_04-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 05:00 backup_2024-12-05_05-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 06:00 backup_2024-12-05_06-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 07:00 backup_2024-12-05_07-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 08:00 backup_2024-12-05_08-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 09:00 backup_2024-12-05_09-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 10:00 backup_2024-12-05_10-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 11:00 backup_2024-12-05_11-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 12:00 backup_2024-12-05_12-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 13:00 backup_2024-12-05_13-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 14:00 backup_2024-12-05_14-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 15:00 backup_2024-12-05_15-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 16:00 backup_2024-12-05_16-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 17:00 backup_2024-12-05_17-00-02.db
-rwxr-x--- 1 root    root    1.7M Dec  5 18:00 backup_2024-12-05_18-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 19:00 backup_2024-12-05_19-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 20:00 backup_2024-12-05_20-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 21:00 backup_2024-12-05_21-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 22:00 backup_2024-12-05_22-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  5 23:00 backup_2024-12-05_23-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 00:00 backup_2024-12-06_00-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 01:00 backup_2024-12-06_01-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 02:00 backup_2024-12-06_02-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 03:00 backup_2024-12-06_03-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 04:00 backup_2024-12-06_04-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 05:00 backup_2024-12-06_05-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 06:00 backup_2024-12-06_06-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 07:00 backup_2024-12-06_07-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 08:00 backup_2024-12-06_08-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 09:00 backup_2024-12-06_09-00-02.db
-rwxr-x--- 1 root    root    1.7M Dec  6 10:00 backup_2024-12-06_10-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 11:00 backup_2024-12-06_11-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 12:00 backup_2024-12-06_12-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 13:00 backup_2024-12-06_13-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 14:00 backup_2024-12-06_14-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 15:00 backup_2024-12-06_15-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 16:00 backup_2024-12-06_16-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 17:00 backup_2024-12-06_17-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 18:00 backup_2024-12-06_18-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 19:00 backup_2024-12-06_19-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 20:00 backup_2024-12-06_20-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 21:00 backup_2024-12-06_21-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 22:00 backup_2024-12-06_22-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  6 23:00 backup_2024-12-06_23-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 00:00 backup_2024-12-07_00-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 01:00 backup_2024-12-07_01-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 02:00 backup_2024-12-07_02-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 03:00 backup_2024-12-07_03-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 04:00 backup_2024-12-07_04-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 05:00 backup_2024-12-07_05-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 06:00 backup_2024-12-07_06-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 07:00 backup_2024-12-07_07-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 08:00 backup_2024-12-07_08-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 09:00 backup_2024-12-07_09-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 10:00 backup_2024-12-07_10-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 11:00 backup_2024-12-07_11-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 12:00 backup_2024-12-07_12-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 13:00 backup_2024-12-07_13-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 14:00 backup_2024-12-07_14-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 15:00 backup_2024-12-07_15-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 16:00 backup_2024-12-07_16-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 17:00 backup_2024-12-07_17-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 18:00 backup_2024-12-07_18-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 19:00 backup_2024-12-07_19-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 20:00 backup_2024-12-07_20-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 21:00 backup_2024-12-07_21-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 22:00 backup_2024-12-07_22-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  7 23:00 backup_2024-12-07_23-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 00:00 backup_2024-12-08_00-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 01:00 backup_2024-12-08_01-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 02:00 backup_2024-12-08_02-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 03:00 backup_2024-12-08_03-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 04:00 backup_2024-12-08_04-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 05:00 backup_2024-12-08_05-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 06:00 backup_2024-12-08_06-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 07:00 backup_2024-12-08_07-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 08:00 backup_2024-12-08_08-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 09:00 backup_2024-12-08_09-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 10:00 backup_2024-12-08_10-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 11:00 backup_2024-12-08_11-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 12:00 backup_2024-12-08_12-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 13:00 backup_2024-12-08_13-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 14:00 backup_2024-12-08_14-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 15:00 backup_2024-12-08_15-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 16:00 backup_2024-12-08_16-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 17:00 backup_2024-12-08_17-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 18:00 backup_2024-12-08_18-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 19:00 backup_2024-12-08_19-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 20:00 backup_2024-12-08_20-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 21:00 backup_2024-12-08_21-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 22:00 backup_2024-12-08_22-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  8 23:00 backup_2024-12-08_23-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 00:00 backup_2024-12-09_00-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 01:00 backup_2024-12-09_01-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 02:00 backup_2024-12-09_02-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 03:00 backup_2024-12-09_03-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 04:00 backup_2024-12-09_04-00-02.db
-rwxr-x--- 1 root    root    1.7M Dec  9 05:00 backup_2024-12-09_05-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 06:00 backup_2024-12-09_06-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 07:00 backup_2024-12-09_07-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 08:00 backup_2024-12-09_08-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 09:00 backup_2024-12-09_09-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 10:00 backup_2024-12-09_10-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 11:00 backup_2024-12-09_11-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 12:00 backup_2024-12-09_12-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 13:00 backup_2024-12-09_13-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 14:00 backup_2024-12-09_14-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 15:00 backup_2024-12-09_15-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 16:00 backup_2024-12-09_16-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 17:00 backup_2024-12-09_17-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 18:00 backup_2024-12-09_18-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 19:00 backup_2024-12-09_19-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 20:00 backup_2024-12-09_20-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 21:00 backup_2024-12-09_21-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 22:00 backup_2024-12-09_22-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec  9 23:00 backup_2024-12-09_23-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 00:00 backup_2024-12-10_00-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 01:00 backup_2024-12-10_01-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 02:00 backup_2024-12-10_02-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 03:00 backup_2024-12-10_03-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 04:00 backup_2024-12-10_04-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 05:00 backup_2024-12-10_05-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 06:00 backup_2024-12-10_06-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 07:00 backup_2024-12-10_07-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 08:00 backup_2024-12-10_08-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 09:00 backup_2024-12-10_09-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 10:00 backup_2024-12-10_10-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 11:00 backup_2024-12-10_11-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 12:00 backup_2024-12-10_12-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 13:00 backup_2024-12-10_13-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 14:00 backup_2024-12-10_14-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 15:00 backup_2024-12-10_15-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 16:00 backup_2024-12-10_16-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 17:00 backup_2024-12-10_17-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 18:00 backup_2024-12-10_18-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 19:00 backup_2024-12-10_19-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 20:00 backup_2024-12-10_20-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 21:00 backup_2024-12-10_21-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 22:00 backup_2024-12-10_22-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 10 23:00 backup_2024-12-10_23-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 11 00:00 backup_2024-12-11_00-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 11 01:00 backup_2024-12-11_01-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 11 02:00 backup_2024-12-11_02-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 11 03:00 backup_2024-12-11_03-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 11 04:00 backup_2024-12-11_04-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 11 05:00 backup_2024-12-11_05-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 11 06:00 backup_2024-12-11_06-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 11 07:00 backup_2024-12-11_07-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 11 08:00 backup_2024-12-11_08-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 11 09:00 backup_2024-12-11_09-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 11 10:00 backup_2024-12-11_10-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 11 11:00 backup_2024-12-11_11-00-01.db
-rwxr-x--- 1 root    root    1.7M Dec 11 12:00 backup_2024-12-11_12-00-01.db

The Tracker database is too big (17GB).

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    - Admin -Enjoyable to Install and Setup our SoftwareQuality & AssuranceRelates to QA, Testing, and CI

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions