Export Appwrite database and collections to a MySQL database in Appwrite cloud
Hello, i want to know if its possible to export my appwrite database and collections to a MySQL database incase i do not want to make use of appwrite again
You won't be able to connect directly to the Cloud database to get any data. It would be best to use a server SDK to fetch all the data
Please what are the steps to do it
The thing now is that for example if i make use of the node sdk i can't seem to find a way to fetch all the data in the node sdk code below const sdk = require('node-appwrite');
let client = new sdk.Client();
client .setEndpoint('https://[HOSTNAME_OR_IP]/v1') // Your API Endpoint .setProject('5df5acd0d48c2') // Your project ID .setKey('919c2d18fb5d4...a2ae413da83346ad2') // Your secret API key .setSelfSigned() // Use only on dev mode with a self-signed SSL cert ;
let users = new sdk.Users(client); let promise = users.create(sdk.ID.unique(), "email@example.com", "+123456789", "password", "Walter O'Brien");
promise.then(function (response) { console.log(response); }, function (error) { console.log(error); });
Btw, it's best to use 3 back ticks with multi-line code. See https://www.markdownguide.org/extended-syntax/#syntax-highlighting
Sure you can. Keep reading the docs
i did not find anything in the docs that could help fetch all the data
You're using the users service...so maybe look at docs for that: https://appwrite.io/docs/references/cloud/server-nodejs/users#list
What i am actually looking for is a way to extract the data for an import in another database that is not in appwrite
