Configure and install https://github.com/kiorky/db_smart_backup. This will run it from cron one time a day.