[Feature] Periodical Backups as Config Parameter

[DatDucati]

• Gitea version (or commit ref): not applicable
• Git version: not applicable
• Operating system: Ubuntu
• Database (use [x]):
  • PostgreSQL
  • MySQL
  • MSSQL
  • SQLite
• Can you reproduce the bug at https://try.gitea.io:
  • Yes (provide example URL)
  • No
  • Not relevant
• Log gist: not relevant

Description

I already know about the gitea dump command. But sadly automating it is rather cumbersome and if it was an configurable entity of gitea, it would make the management of backups much better. It would provide various benefits such as:

• tighter control, whether a backup suceeded (Restore tests?)
• (incremental backups Incremental backup of gitea #10135)
• optional: file name schema
• the absolute cherry on top would be configuration of an smb/rsync target
  I would like to help, but I haven't looked much into it. If I get some pointers where one should start, feel free to do so!

[stale]

This issue has been automatically marked as stale because it has not had recent activity. I am here to help clear issues left open even if solved or waiting for more insight. This issue will be closed if no further activity occurs during the next 2 weeks. If the issue is still valid just add a comment to keep it alive. Thank you for your contributions.

[stale]

This issue has been automatically closed because of inactivity. You can re-open it if needed.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. I am here to help clear issues left open even if solved or waiting for more insight. This issue will be closed if no further activity occurs during the next 2 weeks. If the issue is still valid just add a comment to keep it alive. Thank you for your contributions.

[zyansheep]

This would be pretty nice to have and it seems pretty easy to implement. Store the last backup time and see if a certain amount of time has passed. If it has, depending on config, either replace the last backup or create a new file with gitea dump.

EDIT: I wonder if SQL servers have an incremental backup feature.