Migrate Appwrite from VPS to another.

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.

What was the issue you've faced

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

Which script you've used?

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

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

No. It was at the onboarding stage

But I had signed up already

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

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

Let me run this and let you know

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

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

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

Thank you so much Binyamin <:appwriteparty:946072712915341333>