Server: backup database cron task

[samoylenkodmitry]

In the deploy.sh

Updated 30/05/2024:
The first iteration of this can include just saving the database zipped copy in the ~/backups/db folder. The filename can include the current timestamp. And we can do some housekeeping to leave at most 3 recent backups. Keep in mind, the database right now lives in the docker container.

The follow up of this task can include some uploading to cloud storages, that can be configured in the .env file. (this is not required)

[RAD1AN1TE]

Hi, I'd like to take on this task. Could you specify the frequency for backing up the database? How about daily at 2AM?

[samoylenkodmitry]

Hi, I'd like to take on this task. Could you specify the frequency for backing up the database? How about daily at 2AM?

Hi, @RAD1AN1TE

Sure, it sounds good. The first iteration of this can include just saving the database zipped copy in the ~/backups/db folder. The filename can include the current timestamp. And we can do some housekeeping to leave at most 3 recent backups. Keep in mind, the database right now lives in the docker container.

The follow up of this task can include some uploading to cloud storages, that can be configured in the .env file. (this is not required)