I recently created a new mysql backup script. It is compatible with local mysql-servers or can be used to backup the databases of a docker container. It will save on dump every hour and holds 6 of them normally and one every day, holding a complete week.
I am running this script every hour via crontab:
0 * * * * /opt/mysql/backup.sh > /dev/null 2>&1