Skip to content
Start building
Back

How to back up and restore your Appwrite Cloud database?

  • 0
  • Databases
  • Cloud
View on Discord
sSr
24 Mar, 2025, 22:30

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???

TL;DR
Developers can back up their Appwrite Cloud database using the CLI and the "init database" command. It's important to handle this process carefully to avoid replacing or deleting the existing database accidentally. For schema changes, the best practice is to use the "alter" table command. With the Pro plan, developers can use the corresponding feature to backup the database, but they can't download the backups. To export data to a self-hosted instance or locally, developers should utilize the built-in migrations feature. Building a custom script to export data is an option, but it's not recommended. Downloading schema and data from database tables in
D5
24 Mar, 2025, 22:39

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

sSr
24 Mar, 2025, 22:40

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

sSr
24 Mar, 2025, 22:41

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

D5
24 Mar, 2025, 22:48

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

Reply

Reply to this thread by joining our Discord

Reply on Discord

Recommended threads

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more