Sysadmin MariaDB time based backups

dbbackup.sh scheduled cron can somewhat do it but for finer grain control you need to enable binary logging (ALOT of extra disk space consumed !) and do point in time recovery MySQL :: MySQL 5.6 Reference Manual :: 7.5 Point-in-Time (Incremental) Recovery Using the Binary Log

you can only recovery what the binary log has recorded, so you can't go far back so still need a full backup of mysql database(s) to restore initially and then use binary log to roll back to specific point in time where difference in time is between the time the full backup was made and the time you want to roll back from.

So if you made full backups every 24hrs and had binary logging enabled >24hrs ago. You'd restore your last full backup which is 24hrs old and then replay and recover the last 24hrs of binary logs to bring your database up to date or if you want to restore to 1hr ago, restore full backup 24hrs old and replay and recover the last 23hrs of binary logs to bring database state to 1hr ago. By default, binary log records all databases data on the server by default so you need full backups of all databases on the server and restore all databases on server before rolling back via binary logs.

Alot of disk space will be used as you need space to store binary logs and you also need to backup the binary logs + mysql full database backups as well. Disk space depends on how long you want to keep the binary logs for too which you can configure. I'd make room for at least 6-10x times more disk space that the total dataset size of ALL mysql databases on your server. So if you have 20GB of databases, make room for 200GB of free disk space at least.

Also recommended practice is to have backup of binary logs off server in remote location, so you'd need a 2nd server for that. So yes 2x 200GB extra disk space servers for the source data server and binary log backup server

So read the official mysql documentation