How to back up and restore your Appwrite Cloud database?

I was wonding if i can download scheme and data from database tables from app write cloud and restore it or will i need towrite some routine using python/javascript sdk???

If you have the pro plan, you can backup it with the corresponding feature.
However, you can't download the backups.

If you want to export all the data to a self-hosting instance or locally, you will need to use the built-in migrations feature.

Alternatively, you can build your own script to export the data, but I don't recommend that

yep pro plan .... i have appwrite.json how do i use that to create a new database

nad i need to do "alter" table like change scheme wat will be the best practise

You need the cli and use the init database command if I'm not wrong.
Have in mind that could replace/delete the existing database if not handled properly