Hi,

I want to export all of my data including all the post, comment, post I upvoted, list of communities I subscribed to, log of my IP address, all of my logins. In short all the data I gave to the instance I am using.

is there a way to export all of these data to a JSON file or something?

Thank you in advance!

  • Shadow@lemmy.ca
    1·
    6 months ago

    I’m happy to export your data for you from the database if you want it, but I don’t have an easy way to do that beyond writing queries by hand for each table. Is there some subset specifically that you’re looking for?

    We don’t log any IP addresses except web server access logs temporarily, and we can’t identify which log entries are which users. There’s no login history in the DB, it doesn’t even log the last login for a user.

    If you’re willing to write the queries for the data you want, I don’t mind reviewing them and then giving you the output.

    • whoareu@lemmy.caOP
      1·
      6 months ago

      since you don’t log IP addresses I can get most of the stuff using Lemmy api. no need to write SQL queries.

      Thank you for the response <3