[SOLVED] Export Entire Data of Collection

Hello, is there an easy way to export the entire data of just a single collection using the cli or docker mariadb commands other than querying from api?

Example I have a Tasks and Projects collection, I just want to export all data from the Tasks collection using cli.

I did this with cloud function. it goes through all the documents of a collection and inserts in a csv. At the end save the file in storage. Help you?

https://github.com/rafagazani/export_collections_to_storage

@hosni.hotelkilow can we Mark it as solved?

Hello! Sorry I forgot to get back, thank you for this snippet ill use it as reference soon. In the end what I did was to echo out from the mariadb container as I did't want to call the api for it, I had to figure out the correct table name though

docker exec appwrite-mariadb sh -c 'exec mysql -B -u"$MYSQL_USER" -p"$MYSQL_PASSWORD" appwrite -e "SELECT * FROM _1_database_1_collection_6;"' \
| sed "s/\"/\"\"/g;s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" > medias.csv

[SOLVED] Export Entire Data of Collection