Back

Databases for dev, staging and production environments

  • 0
  • Databases
  • Web
murru_AY23-04
5 Sep, 2023, 15:16

Hey there community!

Is there an option to clone a database in Appwrite console? I already have a database created, and that's the one I'm working with for a front end I'm developing for a client, but then I'd like to have a replica of this database only for dev purposes.

It'll be amazing if after making changes to this dev database I could merge it with the staging database, or just clone it and make this cloned database the new staging database.

Is there anything like this? Thank you!

TL;DR
User wants to know if there is an option to clone a database in the Appwrite console. They want to have a replica of their current database for development purposes and then potentially merge it with the staging database or replace the staging database with the cloned one. There is a solution to this - database backup and restore functionality in version 1.4 of Appwrite. This can be used to clone the database and work with it for development purposes.
ideclon
5 Sep, 2023, 17:24

You can copy over the db structure with the CLI

ideclon
5 Sep, 2023, 17:24

$ appwrite init collections

ideclon
5 Sep, 2023, 17:25

v1.4 has backup and restore functionality, which could also be used for this

murru_AY23-04
5 Sep, 2023, 17:25

Wow, didn’t know there was a client 😅. I have the appwrite console in a digital ocean droplet, so I guess that CLI should be installed there

murru_AY23-04
5 Sep, 2023, 17:26

Thank you my friend 🫶🏼

ideclon
5 Sep, 2023, 17:26

CLI would be installed on your local machine

ideclon
5 Sep, 2023, 17:27
murru_AY23-04
5 Sep, 2023, 17:58

I used the digital ocean prepared image of appwrite. It's running on docker, so I guess all stuff should be installed. But thank you for the info, I will check it today

Drake
5 Sep, 2023, 19:11

The CLI is totally separate from an Appwrite installation so you'll need to install it wherever you want to use it

murru_AY23-04
5 Sep, 2023, 21:01

Awesome! Thank you ❤️

Reply

Reply to this thread by joining our Discord

Reply on Discord

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