@Sebastiaan Didn't you want this as well?

@Dennis yes indeed. This is a really pain in my ass right now. Would love to automatically backup db before continuing (especially php artisan migrate) the deployment script. I have to disable the quick deploy and remember to backup the db manually in ploi before manually clicking the deploy button (I may seem lazy but what I mean is that human errors are possible xD)

I actually use Spatie a lot for Laravel apps (https://spatie.be/docs/laravel-backup/v8/introduction) so I just add php artisan backup:run to the deployment process. Works great.

But getting it build-in.... <3

Merged Trigger a backup when syncing from staging to production into this item

Created by: Bow House

It would be great if there was a way to automatically trigger a database and file backup of a site when the "Deploy to production" button is clicked on sites that are linked to a staging environment. This would mean that if anything went wrong in the deployment (a bad database migration for example) the site could be restored to its previous state without too much hassle.

As it stands, it's not currently possible to do this with a command in the deploy script because the deploy script runs after they have already been synced. One way to fix this would be to have a pre deploy script added to the production site, but having it inbuilt into the UI would be great!

I think the easiest way to manage it in the UI would be to have some extra settings in the Production tab of the staging site near the "Ignored folders & files" section, with the ability to enable database and file backups and ideally some sort of retention policy so you don't have to remember to remove old ones.