Self Hosted

Migrate Appwrite from VPS to another.

Dec 27, 2023, 20:32

View on Discord

Votes

Replies

Participants

Unknown

Messages

DavidOriginal post

Rank 2: Process

Jul 10, 2023, 12:42

I installed appwrite on a droplet and also installed appwrite on GCP Compute Engine.

I want to migrate the data in the Droplet over to the Compute Engine.

I followed the instructions on backup and restore topic but didn't succeed?

Any help is highly appreciated.

Summary

User needs help migrating Appwrite from a VPS to another. They are asking for guidance on how to view users in the database and verify if information has been updated. They mention running a command that could potentially reset the database. They also mention signing up and running a restore script, but the data is not appearing in the new instance. They followed the backup and restore instructions but didn't succeed. Solution: Provide instructions on how to properly migrate Appwrite data from one server to another.

Binyamin

Jul 10, 2023, 12:43

What was the issue you've faced

David

Rank 2: Process

Jul 10, 2023, 12:53

I don't see the data in the new instance after running the restoration script

Binyamin

Jul 10, 2023, 12:57

Which script you've used?

David

Rank 2: Process

Jul 10, 2023, 13:02

https://gist.github.com/stnguyen90/fee636ff652b8ecbf761935b2aa254fb

Binyamin

Jul 10, 2023, 13:06

So when you ran the restore.sh you already had an active Appwrite in the new machine?

David

Rank 2: Process

Jul 10, 2023, 13:20

No. It was at the onboarding stage

David

Rank 2: Process

Jul 10, 2023, 13:20

But I had signed up already

Binyamin

Jul 10, 2023, 13:23

This command though, should reset your database

docker compose exec -T mariadb sh -c 'exec mysql -u"$MYSQL_USER" -p"$MYSQL_PASSWORD"' < ./backup/dump.sql

Binyamin

Jul 10, 2023, 13:23

Can you verifiy that the information in the database has been updated?

David

Rank 2: Process

Jul 10, 2023, 13:32

Let me run this and let you know

David

Rank 2: Process

Jul 10, 2023, 13:45

David

Rank 2: Process

Jul 10, 2023, 13:49

Do you know the command I can run to see the users in my database?

Binyamin

Jul 10, 2023, 14:10

The easiest way would be to login to your Appwrite database using this gist https://gist.github.com/byawitz/885510a4d9789e97424337e9472276d7

David

Rank 2: Process

Jul 10, 2023, 16:56

I hoped to create everything manually as learn more about this for future tasks

David

Rank 2: Process

Jul 10, 2023, 16:56

Thank you so much Binyamin

Join the discussion

Reply to this thread by joining our Discord.

Reply on Discord

Need support?_

Join Discord Get premium support