Back

Moving from Appwrite Cloud to self-hosted(DigitalOcean)

  • 0
  • Tools
  • General
  • Cloud
nightwielder
22 Aug, 2023, 17:38

TLDR: How do I comfortably move all my functions, schemas, data, files etc from Appwrite cloud to a DigitalOcean droplet's Appwrite instance?

I need to transfer all my data to a freshly installed Appwrite instance in DigitalOcean. I can easily transfer the functions, collection schemas, storage bucket names using the appwrite-cli. And I was thinking I would have to write another script to transfer all the documents from the collections. But that would change the '$createdAt' which is not ideal. Moving the users could be a pain too. What is the simplest way to just COPY AND PASTE everything?

TL;DR
Solution: Unfortunately, there is currently no simple one-click solution to migrate from Appwrite Cloud to a self-hosted setup on DigitalOcean. However, you can follow these steps to transfer your data: 1. Set up a new Appwrite instance on your DigitalOcean server. 2. Use the Appwrite server SDK to export all your documents to a CSV file. 3. Use the provided gist (link provided) to connect to your MariaDB database. 4. Locate the collection table in the database. 5. Update the createdAt and updatedAt fields in the table to match the values in the CSV file. Please note that this solution requires some
Binyamin
22 Aug, 2023, 18:29

For now, there's no way to migrate everything in simple one-click solution. Notice that this option is currently in development.

As for your use-case What you can do is something like this.

  1. Move everything to the newly created DigitalOcean server.
  2. Export all the document (using server SDK) to a csv
  3. Use this gist to connect to MariaDB Database.
  4. Locate the collection table in the database
  5. Update the createdAt & updatedAt to those in the CSV.
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