I downloaded the Stack Overflow data dump for the last month. It has six files, with names like stackoverflow.com.7z.001, stackoverflow.com.7z.002, etc. I tried to open one of them with Notepad++, it showed a pile of binary data, suggesting that it might be a dump. Now, how do I import it into MySQL?

Is the dump already in format Insert into table values (), or is it just the data in some space separated or CSV format, that has to be loaded? Plus any idea about the table schemas? The Meta Stack Overflow post Database schema documentation for the public data dump and Data Explorer gives you an idea about the nature of the data the tables contain, but it doesn't tell you about the schema.


The post you link to, Database schema documentation for the public data dump and SEDE, is the schema; so yes it does contain the schema. You can get column sizes from the Data Explorer if you want.

You might find Scripts to convert data-dump to other formats helpful.

The fact that the files are .001, .002, etc. would imply that it's been split. Probably using 7-Zip's split functionality. You can either use 7-Zip to recombine them or use another tool such as HJSplit.

| improve this answer | |
  • By schema I meant the table structure, structure of the columns. This post only describes what each column represents, for example, name of the voter, his id, etc, whereas I want to know whether that column is of type char(50) or varchar(100). – SexyBeast Sep 1 '12 at 8:32
  • 1
    @Cupidvogel Ben already answered this, you can get the column types & sizes from Data Explorer. – yannis Sep 1 '12 at 8:43
  • Thanks, the scripts are very helpful. I'm able to convert them to SQL Server scripts. – Nicholas Humphrey Jul 26 '19 at 23:51

You must log in to answer this question.

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