×
Login Register an account
Top Submissions Explore Upgoat Search Random Subverse Random Post Colorize! Site Rules Donate
41

searchvoat archive dump

submitted by v0atmage to TellTalk 3.0 yearsMay 30, 2022 22:42:07 ago (+42/-1)     (TellTalk)

Full disclosure: I have not looked at this data too thoroughly but I think I managed to get it all. It's apparently compressed sql data so to fully leverage it you need to run the sql statements in a mariadb session and then run adhoc queries.

Alternatively you could use something like zgrep.

I am lazily getting around to hosting my own lemmy server so I might try to migrate the data into that database at some point.

https://anonfiles.com/XaX6Adlfy5/svf.sql_gz
https://anonfiles.com/n1YaA0l3y9/images_tgz
https://anonfiles.com/x4Z7A5lfy7/user.sql_gz
https://anonfiles.com/5bZ8A9lbyf/userBadge.sql_gz
https://anonfiles.com/9eZ3Afl4yd/subverse.sql_gz
https://anonfiles.com/J7Z8Ael3y2/www_tgz
https://anonfiles.com/P2Z5A3l3ya/subverseModerator.sql_gz
https://anonfiles.com/R3ZfAfl1y2/submissionAttribute.sql_gz
https://anonfiles.com/z3a3B3l5y0/top50.sql_gz
https://anonfiles.com/J6a5B9l7yb/subverseSubscribers.sql_gz
https://anonfiles.com/D8baB3l5y6/submission.sql_gz
https://anonfiles.com/L2t2B0l1ye/comment.sql_gz


21 comments block