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?
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>
