40

I would like to create a local MySQL copy of Stack Overflow for academic purposes (school project). As far as I know, the database dump of the stackoverflow.com database is available only in an XML format that I will have to convert to SQL on my own with some tool.

Most of direct download links I found were broken (404). The only non-torrent source that I have found and that is still alive is http://tejp.de/files/so/dbdump/ but the latest Stack Overflow dump there is from October 2009, content of which looks like this:

Enter image description here

Where could I find a direct download link with the Stack Overflow dump?

Note: I am not able to use torrents due to network policies, yet for the completeness of this question, here's the link that might help someone: http://www.clearbits.net/creators/146-stack-exchange-data-dump

Other related questions / links that haven't helped me:

Improve this question
5
  • 1
    You really have no access to any network capable of torrent? Your home network? A $5 digitalocean instance? Anything?
    – 000
    Commented Sep 30, 2013 at 18:36
  • 2
    @JoeFrambach: Let's just say it's complicated... for now I hope someone has uploaded somewhere a newer dump than the one from Oct '09 I mentioned
    – LihO
    Commented Sep 30, 2013 at 18:40
  • quick-torrent.com
    – SeanC
    Commented Sep 30, 2013 at 19:30
  • hi @LihO what method did you use to import the data into mysql? i am trying to do the same.
    – ted.strauss
    Commented Dec 21, 2013 at 0:07
  • @ted.strauss: I guess what you actually want to use is: stackapps.com/questions/2511/… ...it's just a bit annoying that you have to specify path to folder that contains another folder named SO that contains the actual dump (xml files).
    – LihO
    Commented Jan 14, 2014 at 11:21

1 Answer 1

Reset to default
34

The latest Stack Exchange data dump with direct download links can be found here at the Internet Archive.

An older data dump (September 2013, uploaded by me to Mega) is below.

Regarding the dumps being "anonymized", please see this question and answer for details. In short: no votes, no personal data.

Improve this answer
5
  • 2
    (JDownloader is useful to download many of those links at once.)
    – Franck Dernoncourt
    Commented Dec 25, 2013 at 23:22
  • Are older dumps available through Archive.org? I couldn't find any.
    – RomanSt
    Commented Apr 16, 2016 at 14:12
  • 1
    @romkyns I guess there are no official older dumps, but you could take a look at this answer that lists magnet links for older dumps. I don't know if the links are alive, but you can try.
    – Smi
    Commented Apr 16, 2016 at 16:31
  • how do you take these xml files and turn them into mysql files?
    – Joseph Astrahan
    Commented Aug 4, 2022 at 18:45
  • The dumps don't contain images. Images can be downloaded here.
    – Franck Dernoncourt
    Commented Jan 16 at 19:27

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .