How to generate a database-setup script out of a appwrite-cloud-instance?
- 0
- Databases
- Tools
- Cloud
![](https://cdn.discordapp.com/embed/avatars/3.png)
I've written a vue.js webapp with appwrite-cloud-db (including relations) and everything works just perfectly! Now I want to release this webapp as an open source project that anyone can checkout and run locally with as much automation as possible.
Therefore I have to find a way to automate the following steps:
- install self-hosted appwrite locally with docker
- import a predefined database schema with sample data into appwrite
- start webserver
How to achieve step 2? If it would be just a sql-db, I would just generate an sql-import-script (create database, create table etc., insert into table ) and run this against the local database in a start script.
But how to do the automated db-import with appwrite? How can I create a local importable database export file from a appwrite cloud database? Can this be achieved only with an external lib like appwrite-utils-cli? Or is the only option to code the import manually by my own using server SDK with commands like databases.createCollection ...?
Any kind of help is greatly appreciated. Tom
![](https://cdn.discordapp.com/avatars/462046107556511744/504fd808296728e8e89d82b8ea1e77a9.webp)
The Appwrite CLI is the easiest way to deploy a collection. updating it is a different matter, though
Recommended threads
- Error uploading more than 1MB
- Access blocked by CORS policy
Getting the following error message while uploading or updating image files at Appwrite Storage. ``` Access to XMLHttpRequest at 'https://cloud.appwrite.io/v1/...
- Many to many relationships restrictions ...
Hi! I'm creating and testing a simple data model and I'm a bit confused about how one way relationship restrictions work with many to many relationship. I will ...
![](/images/bgs/pre-footer.png)