Rank 1: Thread
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
Votes
0
Replies
9
Participants
Unknown
Messages
10
Rank 1: Thread
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
Rank 1: Thread
Please what are the steps to do it
Rank 1: Thread
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
Rank 1: Thread
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
Rank 1: Thread
What i am actually looking for is a way to extract the data for an import in another database that is not in appwrite