🚀 Feature: Self-hosted | version-agnostic migrations and auto DB backup

[byawitz]

🔖 Feature description

Adding a few flags to Appwrite migrate CLI runner.

• --from-version - set the version in which you've upgraded, the migration will start from that one.
• --backup-db - Dump the current DB into an SQL file before migrating.

When someone is upgrading from version 1.0.0 to version 1.3 for example the command would be

docker exec appwrite migrate --from-version=1.0 --backup-db

The from-version flag would work something like this

flowchart 
    migrate[docker exec appwrite migrate] --> v1[--from-version=1.0] --> V15
    migrate --> v2[--from-version=1.1] --> V16
    migrate --> v3[--from-version=1.2]--> V17    
    migrate --> V18

    V15(V15.php) -.then.-> V16(V16.php)
    V16 -.then.-> V17(V17.php)
    V17 -.then.-> V18(V18.php)
    V18 --> Done

🎤 Pitch

Easy upgrade while adding a backup for safety.

👀 Have you spent some time to check if this issue has been raised before?

• I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• I have read the Code of Conduct

[EVDOG4LIFE]

Thanks for filing! This can definitely be something we work on improving, I will bring this up with the team to see what can be done. Thanks @byawitz!