Visual Studio Code is a free open source IDE available on Windows, macOS and Linux (since you didn't mention your OS). Just add a PHP extension for the syntax. MySQL extensions are also available if you want. Otherwise, you also have Visual Studio Community, which is free.
For backing up data from servers, I'm using AzCopy v10 to synchronize local files to Azure Blob Storage.
Local copy can be considered always authoritative.
Only new/changed files are
Locally deleted files can be deleted from remote.
Azure Blob Storage has settings to automatically retain deleted blobs for some time period.
Azure offers additional ...